I am using QTP9.0,I am facing problem with import sheet from excel.
In my excel i have 10 sheets when i am importing 6 sheet i am facing problem that Datatable.Importsheet...........,
when i run for two to three times It imported the sheet very well,when i imported the same sheet for 5th run i am getting the problem that Datatable.Importsheet...........,
If anybody had the same problem and solved the problem.so,Please let me know how to solve it.
In my excel i have 10 excel sheets.so,I want to import the data from 9th excelsheet,So i gave datatable.Importsheet "c:\ABC\DEF\GHI.xls",9,"XYZ".But i am getting an error Datatable.importsheet failed.Invalidfile .
But igave correct path.When I run the script for 5 runs it imported the sheet very well.But when i modified some data in 9th excelsheet it is giving this error.
I didn't have any urls or email id's in sheet.I have just normal data in sheet.when i first imported it imported very well.
I have a doubt,Do an excel have a limit for sheets.
In the starting when error occured i thought only in my system it is giving problem,But when i tested in my collegues system,the same problem occured.