Column Read Range

Help Activities
, ,
1

HI Team,
Reading excel file
Column 1 2 3 4 5 6 7 8 9 10
Row x x x x x x x x x x

Using Read Range activity
In Range tried with “D1:J1” which is not working
I want to read column wise. Help needed

2

Hi

  1. Add a Read Range Activity - In the Range property, specify "D:J"
  2. Ensure Add Headers is checked if the Excel sheet has headers.
    Regards
    Gokul
3

Thanks. Gokul. But it’s reading the column 1 2 3 4 5… instead of x. Attached screenshot. This excel having values from A to J only.

image
image1264×505 26.6 KB

4

Hi @Honda ,

in your for each you given dt_cols.Columns that means it will get only columnname.

if you want row data you can just pass dt_cols.

May be this will helps.

5

Hi

  1. Use a For Each activity to loop through the DataTable.Columns
  2. Inside the loop, Use For each activity DataTable.Row
For Each column As DataColumn In DataTable.Columns
    For Each row As DataRow In DataTable.Rows
        Console.WriteLine(row(column.ColumnName).ToString)
    Next
Next