Forum Discussion

Anumakonda_mahe's avatar
Anumakonda_mahe
Frequent Contributor
13 years ago
Solved

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
    13 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.


tristaanogre's avatar
tristaanogre
Esteemed Contributor
13 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.