Hi guys, I want to consolidate multiple excel - sheet data into one excel. example - abc.xls - sheet 3 - need to read. def.xls - sheet 1 - need to read. xyz.xls - sheet2 - need to read. output.xls should have all consolidated data available. Please help.

Let’s say like we have aground five sheets or workbooks and all has to be merged —now we shall create two datatable variables named dt and finaldt with default value as New System.Data.Datatable defines in the variable panel —now use a ASSIGN activity like this arr_files = Directory.GetFiles(“Yo…

Merge - excel data

Help

kadiravan_kalidoss (Kadiravan K) January 14, 2020, 10:15am 3

Topic		Replies	Views
How to merge Data into one excel sheet Help datatable , excel , activities , question	7	2718	January 14, 2020
Merge dataTable issue Help	4	796	September 12, 2019
How to merge multiple sheets Help datatable , excel , activities , question	3	2038	January 3, 2021
I wonder why there are no topics on merging multiple excel sheets into 1 here Studio studio , question , activities_panel	4	921	June 13, 2021
Merged DataTable Issue Help	5	806	September 12, 2019

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Merge - excel data

Related Topics