How to import data from one excel file and put it in the desired column in another excel file?

[Famui_Yanisa]

I have data in an excel file.

I want to migrate data to a new excel file, having to sort the data of columns A->C, B->B, C->A.

Best Regrads

[Anil_G (Anil Gorthi)]

@Famui_Yanisa

You can read the datatable and then change the column position…

please check this on how to change column position

How to Change the Ordinal of DataColumn

How to change the ordinal or position of the DataColumn to the specified ordinal or position? Is it possible to reorder Columns? If yes, please share a sample script. Issue/Query: How to change the ordinal or position of the DataColumn to the specified ordinal or position? Resolution steps: The above scenario is achievable with the help of Set Ordinal method. Sample Excel/ DataTable Data: Consider the below data [image] Launch UiPath Studio and create a sample process. Ensure to have …

cheers

[Joe888]

Do you mean copy data from column A to column A, B->B, C->C?

[ppr (Peter Preuss)]

• read in excel1 - read range without header - dt1
• reorder the columns - dt2 = dt1.DefaultView.ToTable(False, {“Column3”,“Column2”,“Column1”})
• append range to Excel2 - dt2

[Famui_Yanisa]

No, sorry for the confusion. I want to migrate data to a new excel file, having to sort the data of columns A->C, B->B, C->A.

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Famui_Yanisa ,
I think you want to write column C in file1 to column Animals (A1) in file2, column B to A-Z, and column A to Column Number(C1)
You can
-use excel read range file1
-filter data to get column what you need keep
-use write range to file2
My in/out

My code

regards,

[Anil_G (Anil Gorthi)]

@Famui_Yanisa

Please try the above method specified its exactly what you asked for I believe

cheers