Reading multiple sheets in a spreadsheet and adding them all in 1 DT

Help Studio
, ,
1

I have a spreadsheet with multiple sheets that have the same format, i.e. same number of columns and same column names. I want to be able to read all the sheets in that spreadsheet and put all the data in 1 data table.

How do I do this?

2

@redanime94
Hi please follow these steps.
1)use excel scope
2)Inside it put get workbook sheets activity. It will return you all the sheets in array.
3) put for each loop over sheets and inside read sheet by giviing variable in sheetname section.
4) after read range activity use merge datatable activity and merge datatable in another Datatable.