Forum Discussion

windend's avatar
windend
Occasional Contributor
14 years ago

How to know sheet is not present in Excel workbook with DDT.ExcelDriver

hi, I'm using DDT.ExcelDriver to fetch data in excel like this : excelDriver = DDT.ExcelDriver(excelPath,sheetName) However, sometimes the sheetName is not present in my excel workbook,...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
14 years ago
How are you utilizing the ExcelDriver in that you don't know the sheet names that exist ahead of time?  The standard usage of the DDT objects is that they are used with files and/or databases that have a set of data that is predetermined prior to script execution.