Write selective range

[A_Learner]

Hi,
I have a data table. I need to write only columns from A:P and skip the rest of the columns into an Excel. How to do that?

Thank you,

[Parvathy (PS Parvathy)]

Hi @A_Learner …

Check the below thread. This should help you.

Writing specific datatable columns to excel

@Marla_Ch have a look on the filter datatable Activity and also on the Column Setting part. Here you fetch out a new table using it for write range to Excel. For more Custom cases we can have a look on solution approaches with Linq, Datatable.Select, DataTable.Default view…

Regards

[A_Learner]

@Parvathy
Thank you. Need more information on how to do this.

[Parvathy (PS Parvathy)]

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

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