UI path write multiple column in excel

Question

I am learning UIPath and my source is excel file. I have excel file with column A, B, C. What I want is to write column A and C only into a new excel file.

I get confused about which function I should use to read/write. I think if I use read range/write range, it will write all columns. However, what I want is only column A and C

Answer 1

The first thing to do here is using 'read range' and get a DataTable as output, now for DataTables there is an activity called Remove Data Column you can use it to delete row B.

Alternatively after reading the entire sheet you can for 'for each row' activity then a write/read cell activity then inside it you can choose the rows you want to write/read like row(0).toString row(2).toString here 0 and 2 are A and C  , basically using dataTables makes life easy.