How to fetch Excel data row using data table activities?

[Vaishnav_Tej]

Hi All,

I’m trying to fetch excel data using “For Each Row Data Table Activity”.
But when I execute , it is not giving exact values. Instead showing “System.Data.DataRow”

Excel Sheet:

Below is the workflow:

Please let me know where I was wrong.
Thanks in Advance

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@Vaishnav_Tej
You need to access row(0) in your case
Here 0 is the index of column and row indicates datarow in your datatable

[Gokul001 (Gokul Balaji)]

Hi @Vaishnav_Tej

Try to use like this

row(“column name”).ToString

Regards
Gokul

[Vaishnav_Tej]

Thank you. Both the options working .