How to reorder the column

[anjani_priya]

file.xlsx (11.3 KB)
for reference check this excel file

[vrdabberu (Varunraj Dabberu)]

Hi @anjani_priya

=> Read Range Workbook
Output → dt

=> Use the below syntax in Assign:

newdt = dt.DefaultView.ToTable(False,"name","marks of sub2","marks of sub 1","place")

newdt is of DataType System.Data.DataTable`

=> Write Range Workbook newdt to excel.

Regards

[ppr (Peter Preuss)]

Assign Activity
dtReordered =

dtOrig.DefaultView.ToTable(False, {"name","marks of sub2","marks of sub 1","place"})

UPD1 - out order fixed

[lrtetala (Lakshman Reddy)]

Hi @anjani_priya

Try this

Output:

Regards,

[vrdabberu (Varunraj Dabberu)]

@anjani_priya

Check the below flow:

=> Read Range Workbook

Output → dt

=> Use the below syntax in Assign:

newdt = dt.DefaultView.ToTable(False,"name","marks of sub2","marks of sub 1","place")

newdt is of DataType System.Data.DataTable

=> Write Range Workbook newdt to excel.

FLOW:

XAML:
Sequence84.xaml (10.4 KB)

Regards

[ppr (Peter Preuss)]

A formal reminder on the method signature:

DataView.ToTable Method (System.Data)

So we are using an array