How to fetch Excel data row using data table activities?

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 :slight_smile:

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

1 Like

Hi @Vaishnav_Tej

Try to use like this

row(“column name”).ToString


1 Like

Thank you. Both the options working .

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.