Hi all, I have one doubt how to add column1 and column2 values into Column3 using linq. Kindly Help me to do. For your reference i have attached snapshot. [image]

Hi @Buvaneshwaran_R Try this appraoch Read the excel using read range and store in dt1 use invoke code for writing the code by passing the dt1 as in/Out argument to the invoke code Write the below code: dt1.AsEnumerable().ToList().ForEach(Sub(r) r(“Column3”)= r(“Column1”).ToString+r(“Colu…

How To append Two Cloumns in to another column in Excel using linq

Help Activities

Rahul_Unnikrishnan (Rahul Unnikrishnan) May 15, 2022, 3:59pm 2

Hello @Buvaneshwaran_R

Refer to the below post.

Topic		Replies	Views
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	1904	April 10, 2021
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	2061	January 28, 2021
Concatenate two Columns in LINQ to search Help studio	1	3170	April 23, 2019
Based on two column value we need concatenate remain column value _ Studio datatable , excel , studio , question , activities_panel	7	434	December 28, 2023
Append row (add column) Help	4	860	April 14, 2019

Most Active Users - Yesterday
mkankatala
ashokkarale
pravallikapaluri
postwick
Yoichi
Anushka_Purohit
A_Learner
sullivanne
dokumentor
Yomi_Oluwadara
More details...

How To append Two Cloumns in to another column in Excel using linq

Related Topics