Facing problem in understanding Excel

[Hanish311 (Hanish Singh)]

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

[Rammohan91 (Rammohan Banda)]

Check this,

ExcelToArray.xaml (10.8 KB)

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

Thanks,
Rammohan B.

[KEntwistle (Katie Entwistle)]

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

[balupad14 (Balamurugan)]

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

File : ExcelToArray.zip (7.6 KB)

Regards
Balamurugan