Read range only reading 1 column

[nicholas.harvey]

My read range is only reading the first column of excel spread sheet. Here is my settings for the activity:

Screen shoot of excel i am trying to read:

[prasath_S]

Hi @nicholas.harvey

I dont find any problem with that.

Can you share the excel with dummy data, so we can test from our side.

Thanks

[nicholas.harvey]

Here you go:
stuff.xlsx (9.8 KB)

[GersonTun]

ReadRange.xaml (5.2 KB)
I do not see anything wrong with your file, I can read all of the file columns. Test the attached workflow.
Maybe the path is wrong and you are setting up a different file that has only one column (?) just saying.

[nicholas.harvey]

Main.xaml (13.0 KB)
So right now i am trying to read each column as a string put each column into a list. But it is only getting the first column

[prasath_S]

Hi @nicholas.harvey

try to use for each row inside while loop.

curretly it is outside while loop.

Thanks

[nicholas.harvey]

Thanks for all your help guys… this is was really starting to annoy me… i was thinking the for each loop worked like a for loop in coding, but i guess they are slightly different. thanks