Facing problem in understanding Excel

excel

#1

Hi ,
I want to read a excel workbook with one column and n number of rows ,after reading i want to store the results in an array.If any body could provide me with flow or the code it would really help me. Thanks in advance.
Hanish


#2

Check this,

ExcelToArray.xaml (10.8 KB)

Let me know if that’s what you are looking for.

Thanks,
Rammohan B.


#3

Read range into datatable, then loop through datatable and add each row item to an array?


#4

Hi @Hanish311,
Here I have attached the sample for ur situation with simple steps without loop.

File : ExcelToArray.zip (7.6 KB)

image

Regards
Balamurugan