Read an array value from excel

Help Studio
1

Hello all,

I wanted help in reading an array value from an excel and print it in a message box.

image

In the image above I need to read the column ‘value’ as an array of integers. This is for data driven testing, am able to read every other value just need help with the array part.

2

Whatever value am reading from excel, it is being read as string, so when am trying to read the array there is an error, as it is taking the array as just one string.

3

Hi @arun_menon

Did u trued

row(“Value”).ToArray() ?

4

What should be the data type of the argument when I import the excel values?

5

It should be datarow when u are iterating through each row

6

Hey am not iterating through the excel, I have made a test case and importing data to the test case via excel. So the variables gets stored as argument, I want to store it as an array.

7

with a minimal adoption we can use JSON deserializing methods:
grafik

or doing it classical with a split
grafik

8

Hey @ppr Thanks that workaround worked.

9

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