How to copy a column from one excel file to another excel file?

[Natapong (Natapong Raojutitam)]

Hi @Sidney_Vogel,

I would like to share another way with you

1.Read Range from file that you want to copy (Range “”)
2.Count row by assign rowCount = dt.Rows.Count
3.Read Range with (Range “A”+rowCount.toString)
4.Write Range

Please refer as below attachment:
CopyExcel.zip (24.2 KB)

Read Range activity: How to select specific columns only?

@tomato25 use Read Range Activity to read data and will give you output as dataTable and named it as DT1. (Specify range as " ") Int32 rowCount = DT1.rows.count use Read Range Activity to read data from column A to Column S. And specify range like this: “A1:S”+rowCount.Tostring

I hope it will be useful to you