Linq to get append to values of 3 excel into one excel

Akshaya89 · January 31, 2025, 2:03pm

Hey forum,

I need a help where I want to append 3 excel file values into new excel file. Is this possible to do it using linq?

Parvathy · January 31, 2025, 2:15pm

Check the below thread

Hope it helps!!

Manisha_Ravindra · January 31, 2025, 2:31pm

First Read all 3 excel files let’s say dt1, dt2, dt3 then
newDT = (From row In dt1.AsEnumerable().Concat(dt2.AsEnumerable()).Concat(dt3.AsEnumerable())Select row).CopyToDataTable()
write to excel using write range activity

Akshaya89 · January 31, 2025, 2:55pm

system · February 3, 2025, 2:56pm

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
How To append Two Cloumns in to another column in Excel using linq Activities excel	3	1475	May 15, 2022
Add 3 columns of data into new column Studio excel , question , linq	4	28	December 5, 2025
Append excel data Studio	17	197	June 14, 2024
Using linq, to add two different columns and write it in the third column Studio datatable , excel , uiautomation , activities , data_scraping , string , question , data_manipulation	1	2133	January 28, 2021
To concatenate 2 values in excel using LINQ Activities datatable , excel , selector , database , pdf , mail , outlook , activities , data_scraping , variable , web , string , reframework , question , data_manipulation	3	1939	April 10, 2021