Bot need to identify N number of Sheet Name

Sample.xlsx (11.1 KB)

Dear Team,

Need to support on this issue where the Bot needs to identify N number of sheets in a excel file. Attached is a sample excel file.

Bot needs to read the sheet name initially and then sequentially move to the next sheets accordingly and be able to read all the sheets in the excel file. Therefore the Bot needs to read all the sheets in a excel file.

use get workbook sheets in excel application scope and output to list of string

then you can loop this list to loop sheets

1 Like

Hello,

You can do as below.