How to read multiple sheets in excel

Help Activities
, ,
1

Hie all hope doing very well. I have excel with multipe sheets, it is input file. How can i use read excel with all sheets.

2

Hi @Zuber_Shaikh

Use the below activities

Excel Process Scope => Use Excel File => For Each Excel Sheet => Read Range and pass SheetName as CurrentSheet.Name.

Regards

3

Hi @Zuber_Shaikh

Please refer the below thread. It will combine all the excel to single data table.