Hi All,
I have a problem in importing an excel file into datatable.
code:
is throwing Run Error "The DataTable.ImportSheet operation failed. Invalid file"
Same code till yesterday worked perfectly fine.
When the same script is run in the morning it is throwing the above error. No changes have been made to the file format, only data is changed. it is .xls file only.
I thought the problem is from QTP side,some datatable dll might have got corrupted, and installed QTP11 on another system, the problem persists in other system also.
Please let me know the solution, other wise ill have to modify nearly 20 scripts.
I have a problem in importing an excel file into datatable.
code:
Code:
datatable.addsheet("Login")
datatable.ImportSheet "D:\FolderName\SubFolderName\InputFile.xls","Login","Login"is throwing Run Error "The DataTable.ImportSheet operation failed. Invalid file"
Same code till yesterday worked perfectly fine.
When the same script is run in the morning it is throwing the above error. No changes have been made to the file format, only data is changed. it is .xls file only.
I thought the problem is from QTP side,some datatable dll might have got corrupted, and installed QTP11 on another system, the problem persists in other system also.
Please let me know the solution, other wise ill have to modify nearly 20 scripts.