How can i modify the datatable so that i can append/ write it on excel in particular format

Help Studio
, ,
1

how can i modify the data table so that i can append/ write it on excel in particular format

as one excel has fixed columns and the data that i am getting has some columns that in not needed and havee to be realigned as per the excel columns

2

You will have to build datatable in such a way that it matches the excel file

3

@mint,

You can add or remove DataTable columns as per your need using Activities - Add Data Column & Activities - Remove Data Column

To rearrange the columns use Invoke Method and SetOrdinal. Tutorial here - How to Change the Ordinal of DataColumn

Hope this is helpful. Do not for get to mark this as answer if it helps.

Thanks,
Ashok :slight_smile:

4

You can use the Filter DataTable Activity, you have the option to configure filters. Clicking on “Configure Filter” allows you to specify which columns you’d like to Keep or remove by selecting the appropriate radio button under “Output Columns” and providing the column names accordingly.

image
image745×458 13.7 KB