Re-arrange the columns position in Excel

[Hey_hi]

Hi Everyone,

I would like to ask how can I re-arrange the columns position in excel from this:

To this:

I am able to use the Data Set-Ordinal method but I would not want to use it as it requires additional third party packages. Is there any way to change the position of the columns using a for loop etc ?

[aanandsanraj (Anandraj Rajendran)]

Hi @Hey_hi ,

• Read the excel
• Use Filter Datatable Activity in output column tab add all the columns in the order you want
• Get the output and Write the datatable back to the same excel

[jack.chan]

look at the answer here @Hey_hi

How to do I use a filter to output a data table by column names, but column names is in a list of string and the list can change size?

Example table: [image] For example my columns list is List(Of String)({“a”,“b”}) i.e. i want to only show columns “a” and “b” Steps to filter datatable by column names thats in a list::: read datatable from excel e.g. to variable called dt assign New DataView(dt) to a dataview variable assign dataView.ToTable(false,new List(Of String)({"a","b"}).ToArray) to filteredTable variable now your filteredTable variable will be a table with only columns “a” and “b” you can use output data table + wr…

[Hey_hi]

Alright!! thank you!