Read a excel different sheets in one datatable

Hi All,

I want to read a excel different sheet in one datable.
Can you please give me any suggestion . how can I go to achieve this.

Hi @Sandy

I have no idea whether we can read every sheets of a workbook in a single Read Range activity but we can read every sheet’s data by using Read Range activity individually and merge them into single data table using Merge Data Table activity.


1 Like

One way