0 votes
1 view
in RPA by (12.8k points)

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

1 Answer

0 votes
by (29.8k points)

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.

Related questions

+1 vote
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Jul 10, 2019 in RPA by noah kapoor (5.3k points)
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...