How to interchange the columns in excel?

[Vrishchik (Naveenkumar Shivaraju)]

Hi All,

I want to interchange the column in an excel.

for example: if there are 4 columns in an excel (Column1, column2,Column3,column4)

then the output should be: (Column4, column2,Column3,column1)

Please do needful to resolve this.

@ppr
@yoichi
@gokul
@vishal.kp @Gokul001
@ushu

[ppr (Peter Preuss)]

dtNew =

dtData.DefaultView.ToTable(false, new String(){"Column4", "column2","Column3","column1"})

[Mohammed_Ismail_Rahid]

dt.AsDataView().ToTable(False,“Column4”, “column2”,“Column3”,“column1”)

[Vrishchik (Naveenkumar Shivaraju)]

But I have to interchange the column A with Column BA, so the total column would be more than 60, how can we achieve??

[Vrishchik (Naveenkumar Shivaraju)]

Need to move the column “bill_identifier” from column “BK” to column “A”

[Mohammed_Ismail_Rahid]

can you explain in detail…

[Vrishchik (Naveenkumar Shivaraju)]

I want to move or replace the column A, with the column “BK”

First image is the input and second image the output

[Vrishchik (Naveenkumar Shivaraju)]

The column BK should move to column A

[ppr (Peter Preuss)]

@Vrishchik

so the total column would be more than 60, how can we achieve??

wa not mentioned on top when case was described

[ppr (Peter Preuss)]

Also have a look at the SetOrdinal Method of a datrow

How to add a column in-between the column in datatable

Add the Datacolumn to the datatable and use later SetOrdinal for moving it on a particular position [grafik] [grafik] e.g. 1 Adopt the variables and argument values to your specific scenario. Screenshots just illustrate the essentials

[Vrishchik (Naveenkumar Shivaraju)]

Sorry for that , please consider the images