Copy excel columns to another excel with different positions

Help Activities
, , , ,
2

I can give you some guidance but not readymade code. It is your job = your learninig.

Less effective approach:
1/ read existing excel to datatable, dtSource
2/ create new datatable in newformat, dtDest
loop through all records in dtSource (forEachRow)
3/ transform source row to new format, you could use procedure you described above

A workflow sequence assigns a value from column "C" to variable "colF", checks if column "A" is not empty, and conditionally appends its value to "colF". (Captioned by AI)
A workflow sequence assigns a value from column "C" to variable "colF", checks if column "A" is not empty, and conditionally appends its value to "colF". (Captioned by AI)706×426 7.21 KB

4/ add row to dtDest (AddDataRow)

image
image419×111 2.79 KB

endloop
5/ write dtDest to Excel (WriteRange)

Advanced approach:
The loop and steps 3/ and 4/ can be replaced by LINQ query
There are many resources about it.

Cheers