Read the data of a specific column row by row

[askPWC (PwC)]

Hello everyone, I need your help to be able to carry out this process. I want to read a data stored inside two different columns of an excel file, for example the x column and the y column, and that is row by row, This excel file varies in the length of the number of rows, since it is never the same. and verify that this is bringing the data that I need Thanks for the support

[arivu96 (Arivazhagan A)]

Hi @askPWC,
Try below code,

Convert.ToString(Dt.Rows(rowindex)(columnindex))
Or
Convert.ToString(Dt.Rows(rowindex)(columnName))

Regards,
Arivu

[Lahiru.Fernando]

HI @askPWC

As another suggestion, You can also try using the Read Column activity to read the data in a specific column of a excel file. The output of this will be IEnumerable type variable. You can then use a For Each loop to loop through and access the values in it…

[sivapradeep (sivapradeep ponnam)]

Hi @askPWC

Try below steps

1. Read the Excel File
2. Add For Each row
3. Inside For Each row add row(“column name you want to read”)
   to the Write line to print the values.
   E.g: row(“Column x”).tostring
   row(“Column y”).tostring

Thanks