What is the fastest way to copy many cells value from excel to an other excel

[Soudios (Sou)]

I started to use for each and assign

[T0Bi]

Use read range to read all the cells into a datatable

Read Range

then use write range to write the data in another excel file

Write Range

If this has helped you, please mark this answer as the solution.

[ermanoj3101 (MANOJ)]

Hi @Soudios,

Use read range activity to read respective range and then use write range activity to paste it another excel.

[Soudios (Sou)]

@ermanoj3101
but if i need to past many cell but not with same position
Did i need to use many write cell ?

[ermanoj3101 (MANOJ)]

Then you can define it in Range from where to where you wan to paste it.

And if you want to paste rows on the basis of some conditions then use foreach row and iterate each row and paste it wherever you want.

[Soudios (Sou)]

i need to copy cells not rows because cells postion name in excel 1 have different position in excel 2

[ermanoj3101 (MANOJ)]

Can you show me through the screenshot or if you want to share excel with input and output you can send that to me so that i can i have a clear picture what you want ?

Thanks.

[Soudios (Sou)]

@ermanoj3101

Excel 1 :

I need to copy the information from excel 1 to excel 2 but the sequence is not the same, i can’t just copy past the row

Excel 2 :

[ermanoj3101 (MANOJ)]

Is their two columns with same name i.e “Name3” or you have missed Name4 ?

If it’s Name4 then it can be done through linq, please first confirm it’s “Name3” or “Name4”

[Soudios (Sou)]

Yes i just missed Name4

[ermanoj3101 (MANOJ)]

You can use below query it will change the sequence of columns.
So the question should be asked as "Can we change the sequence of column ?

(From r In dtInput Where r.Item(“Department”).Equals(“IT”) Select dtOutput.LoadDataRow(New Object() { r.Field(of Object)(“Name3”),r.Field(of Object)(“Name1”),r.Field(of Object)(“Name4”),r.Field(of Object)(“Name5”),r.Field(of Object)(“Name2”) },False)).CopyToDataTable

Thanks.

[Soudios (Sou)]

Non we can’t change the sequence in Excel 2, but the screen its just un example, the columns do not always follow each other

My question is if i can do the same than using assign and write cell for every cell or there is a fasted way

[ermanoj3101 (MANOJ)]

Not sure, i thought you want this as result and that is what you have shown in your screenshot…

Maybe someone can help you.

Thanks.

[postwick (Paul Ostwick)]

Read into a datatable. Reorder the columns in the datatable. Write to Excel.

[Soudios (Sou)]

how can i reorder the columns ?

[T0Bi]

Check out this for reordering and renaming datatable columns:

Datatable column transformation

Not totally sure what the goal is, do you want to rename the columns or reorder them (or both)? For simply reordering, you can use dataTable.Columns["Qty"].SetOrdinal(0); This simply changes the position of the column. If you want to rename it, you can do something like this in an assign activity: dataTable.Columns["C"].ColumnName = "B" For deleting columns I’d use the activity Remove Data Column And at last, combining columns can be done either with a simple for each row loop [image] …

[postwick (Paul Ostwick)]

3 posts above mine, ermanoj3101 told you how to reorder them. Well, one way anyway.