Read Range for Selected columns only in Excel workbook

Learning Hub
1

Hi,

I have 5 columns in my workbook(A, B, C , D and E) .I want to use read range and read only column A and D and not the rest of the columns. Please let me know how can i do it in the read range activity.

Thanks !

2

hi @Purnima_Sambasivan,

Read Range you can specify the range , but we cannot skip the in between columns. we can read A:D.

In you case , if you wanr only A and D.

  1. Read the Complete sheet in Datable say DtInput
  2. now we have 2 Options - Either we use Filter DataTable and FilterOut only 2 Columns in a New DataTable as shown below

image

or ,
we Delete the extra columns from the DtInput - using Remove Column and specifying the column number.

–
Mukesh

1 Like
3

Thank you Mukesh. I was hoping we could do this through read range itself.

4

Read Range we have to Specify Range .

we can achieve the same with 2 Read Range :slightly_smiling_face:

1 Read Range to Read Column A - we Specify Range as “A1:A10” and other for D as “D1: D10”.

then we combine the 2 datatable - assuming we want a single Datatable as output.

–
Mukesh

5

wow! thats another way. Then use join table ? wonder which is the best /efficient way

1 Like
6

Now that’s depend on the developer choice … If you want to know the efficient way , you can always have a small poc code and run … and compare the efficiency.

–
Mukesh

7

Hi Mukesh,
In your response on using read range to read 2 separate columns then combining them to a data table I’m wondering if you can provide an example on how to combine the 2 data tables without a primary key?