How to fetch Excel data row using data table activities?

Help Studio
, ,
1

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”

image

Excel Sheet:
image

Below is the workflow:

image

image
image742×527 12.5 KB

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

2

@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

3

Hi @Vaishnav_Tej

Try to use like this

row(“column name”).ToString

Regards
Gokul

4

Thank you. Both the options working .