Reading Excel files with different sheet no

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

Hi @ahmaddaniyal

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.

1 Like

no one file has one sheet