How to read every row in a Data Table and have it as String?

Help Studio
, ,
1

Hello everyone,

I have a problem reading the data table (from Excel) in the for each row activity. In an older version from 2019 the assign activity with str_row = String.join(“,”,Row.itemArray) was working without problems and could read (every) row in a data table.
In 2023.10 version I have problems with the mentioned assign activity.

Has someone from you similar problem after getting the newest update? How did you solve it?

Thank you!

2

Hi @Baltanaktis

May be in for each row in datatable it was giving CurrentRow. In your assign you have given Row change it to CurrentRow and try.

str_row = String.join(",",CurrentRow.itemArray)

image

Hope it helps!!

1 Like
3

@Baltanaktis

str_row = String.Join(",", Row.ItemArray.Select(Function(item) item.ToString()))
1 Like
4

Sorry, I forgot to add the Error description:

Assign: Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run. Please ensure that the workflow has been complied.

5

Hi @Baltanaktis

Try below steps (use CurrentRow)

String.Join(“,”,CurrentRow.ItemArray)

image
image842×492 14 KB

Hope it will helps you :slight_smile:
Cheers!!

1 Like
6

Is it working for you @Baltanaktis

If yes, Make My post mark as solution to close the loop, else I am happy to help.

Happy Automation!!

7

All of the solutions were helpful. I appreciate the help from all of you!

In my case the problem was the double quote character, which hat to be 0x22. Very confusing, but I’m happy to have my automation working again!

2 Likes
8

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