I wonder why there are no topics on merging multiple excel sheets into 1 here

Help Studio
, ,
1

Hi,

just curious, for seemingly common automation task, i find no direct query and solution to the above. Any leads?

2

@er_bar

You can use Read Range activity to output to Datatable, once that one you can use Merge Datatable activity to merge the Datatables and use write Range activity to write back to excel

Hope this may help you

Thanks

3

great. have done that. but now i need to use the specific sheet names in a new column for the newly combined sheet. this is to indicate which rows pertain to which sheet. can be done?

4

@er_bar

You can add a column before merge Datatable and fill that column with the sheet name

Once Read Range activity completes you use Add Data Column activity, after that For Each row you can set that column name to fill using Add data row

To set that value check below for your reference

Hope this may help you

Thanks

5

hi, tks. can you be more specific?