Read excel file and paste it to a different template of excel file

[ldiaz (Leonardo Diaz)]

hi. how can i copy transfer specific column value from dt1 to a different template dt.

i only need to get specific columns and value.

[brunabruno (Bruna Cavalcanti Bruno)]

Hello @ldiaz,

This topic here will help you for it:

How to copy data from one excel workbook to another excel workbook

Hi there, I was about to copy data table from one excel workbook to another excel workbook which had been existed with an existing data table. For clearly explanation, I attached two .xlsx file which named Excel 1 and Excel 2. Excel 1.xlsx (8.0 KB) Excel 2.xlsx (10.4 KB) I want to copy the data table from Excel 2 and paste it beside the data table from Excel 1 using UiPath and my result would end up be like following attached image. [Capture] Is there any way to do so? I looking forward any…

Let me know if this helped you! Ok?

Regards,

Bruna Bruno.

[muhamed_fasil]

@ldiaz

t specific columns and value.

You can use a linq query

dt=dt1.asenumerable().select(function(x) x(“ColumnName”)).Copytodatable

[Gokul001 (Gokul Balaji)]

Hi @ldiaz

You can also try with filter data table activity to get specific column

You can pass the Input and Output DataTable

Check out this for your reference

Four Ways to Filter Data Tables in UiPath Studio | UiPath

Regards
Gokul

[ldiaz (Leonardo Diaz)]

i have 3 excel files first is dt1 and dt2
the purpose of dt1 is to compare ID in dt2, if matched id
it will get a value in specific column of dt2 and write it in dt1
then after i will transfer all the value of the dt1 to my 3rd excel which is just a template. the problem is the template columns is mixed.

dt1

template