Forum Discussion

Anumakonda_mahe's avatar
Anumakonda_mahe
Frequent Contributor
14 years ago

Facing problem to Get Data form 3rd sheet in single Excel File

Hi guys, i have added test data in 8 sheets in a single Excel file. Now i am trying to get date from each sheet using DDT. Exceldriver. It is working fine for Sheet1 & Sheet 2 after th...
  • tristaanogre's avatar
    tristaanogre
    14 years ago
    There shouldn't be any restriction to the number of sheets.  I'm using a spreadsheet in one of my current tests of which I have 8 different sheets that I reference.  I have my own custom names on them (not sheet 1, sheet 2, etc).  



    Could you post the relevant code?  It could be possible that you're not defining the excel driver properly and, if you're using DDT.CurrentDriver, you may accidentally be getting a DIFFERENT driver.


Anumakonda_mahe's avatar
Anumakonda_mahe
Frequent Contributor
14 years ago
Hi Robert,



Good Morning..



Thank You for your reply.



Yes exactly, it is accepting N number of sheets. Yesterday i did some R & D on it then i came to know that problem is occurring only with Sheet3 then i deleted that and added one more new sheet with same Test data now its working fine. But i don't the reason why it is not worked earlier, why it is working now.  Any how problem is solved for Now.





Regards,

Mahesh. A