Read 5 columns

Help Activities
1

Hello everyone. Does Read Column Activity can only get 1 column in excel? Would it be possible to read 5 columns using only 1 Read Column Activity? Thank you

2

Hi evan.joy.celino,
If you want to read multiple column use read range activity.

3

Hello!

What if only I only want specific columns? like the column of A2, column of D2, and column of N2?

4

@

@evan.joy.celino,

First you read entire sheet, put filter data table, supply datattable variable you got from read range.
Click on Filter Wizard, go to Output Columns tab, select keep option and provide column names those you want.

image

Cheers,
Pankaj

1 Like