How to read multiple sheets in excel

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.

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.


Hi @Zuber_Shaikh

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