Read a excel different sheets in one datatable


#1

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.


#2

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.

Regards,
Ranjith.


#3

One way