Hello,
i have excel file in folder
i am reading each excel file through loop.
the problem is that each excel file has unique sheet name.
how can i read these files
thanks in advance
Hello,
i have excel file in folder
i am reading each excel file through loop.
the problem is that each excel file has unique sheet name.
how can i read these files
thanks in advance
you have single excel file contains different sheets or not?
Regards,
Kommi Jeevan.
Using
create a variable of type workbook as the output, and then use workbook.GetSheets to get and array of all sheets in that excel.
no one file has one sheet