Selecting entire A:K without A1

[maciek]

Hi,

I want to select entire columns from A:K but without first row (A1). I dont want it to be hardcoded for example A2:K10000.

Thanks in advance for your help.

[ashokkarale]

@maciek,

What’s the end goal you are trying to achieve here by selecting? May be there will be easier solution for this. Kindly explain.

[maciek]

After K column there are several columns that i want to skip and also i want to skip A1 row while reading range.

[ashokkarale]

@maciek,

Ok. Try this approach to clean the file first and then read the range.

Open file using Excel Process Scope.
Use Delete Rows activity and delete first row.
Use Delete Column activity and delete columns from L to end of columns.
Save the File.

Use Read Range Workbook activity to read the useful data from the cleaned file.

Thanks,
Ashok

[lrtetala (Lakshman Reddy)]

Hi @maciek

• Use Read Range with "A:K" as the range to get all the data.
• Use an Assign activity to assign the filtered DataTable:

dataTable = dataTable.AsEnumerable().Skip(1).CopyToDataTable()

Regards,