Read range only reading 1 column

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:

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.


Here you go:
stuff.xlsx (9.8 KB)

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.

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

Hi @nicholas.harvey

try to use for each row inside while loop.

curretly it is outside while loop.


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

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