Array reading

Hi,

I have an excel sheet, inside particular cells, there are multiple values separated by comma for eg A1 = AB,BC,DE,EF …How do I read this dynamic array as im not sure of the number of values inside that cell. It can vary in each cell.

@shreyaank,

if you need to read the cell alone then you can read it as a string using “Read Cell Activity”
then split it using Comma(,).

If you are reading it as datatable, then in for each row of the datatable you can do the same as

Convert.Tostring( row("Columnname") ).Split(",")

This will return you a string array, so you can use it later

Hi @shreyaank

I have attached workflow based on your requirement check and let me know if any doubts.

ArrayReading.zip (23.9 KB)

Regards,
Kommi Jeevan

1 Like