DataTable Adding data to Excel

[A_Learner]

Hi,
I need to add some columns from a data table to Excel file.
And add few new columns to the Excel file.

Now the Excel file structure is in place.
I need to add more data from datatables to Excel with data in additional columns built above. How to do that?

Thank you,

[vrdabberu (Varunraj Dabberu)]

Hi @A_Learner

You can follow the same process given in below thread.

Write selective range

Hi @A_Learner Way 1: In Filter Data Table activity open the Configure Filter and give the respective column names you want keep within double quotes [image] and store the output in a new variable. Pass that data table variable in Write Range Workbook Way 2: You can below syntax also. It’s an linq query: dt_Filtered = yourdatatable.defaultView.ToTable(False,"column name1", "column name2",......so on) Give all your column names this will also work Regards

In Write Range Workbook please give the range from where you want to write.

Regards