Excel is not getting read

Help Studio
, ,
1

Hi All,

I’m trying to read my excel and loop through it but instead of whatever data is mentioned over excel, I’m getting the output written System.Data.DataRow. And this output I’m getting with respect to the data count present in the excel file.
Uploading the flowchart for your reference.
Please assist me with this.
Flowchart2Challenges.xaml (10.6 KB)

2

Hi @Tanya_Verma

Saw your workflow.

image
image735×473 13.5 KB

You need to pass CurrentRow like CurrentRow(“ColumnName”)

Specify you column name then you will get all values

1 Like
3

You need to specify the column name after in brackets or the column ID as in currentrow(0) for the first column and currentrow(1) for the second etc…

4

Hi @Tanya_Verma ,

Could you let us know what should be the output according to you ?

Also, Try with the below to print all the values of the row :

String.Join("|",CurrentRow.ItemArray)
5

Thanks, @Gvivek9889. It worked

6

Thank you @supermanPunch

1 Like
7

Thank you @aquinn

1 Like
8

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