Read Column Excel Integration, variable as range does not working

Hi everyone,

I am trying to read columns from a sheet and save it in an output variable. But I am trying to have the input range as a variable, instead of having “A:A” I want to have “rangeStart:rangeEnd” with both variables having as value the letter A and being strings.

When I try to debug the file, in that part, an output appears saying “The range does not exist” but if I type “A:A” it runs smoothly. The problems is that the column letter may vary that is why I need a variable instead

Thank you in advanced,

Hi,

Can you try the following expression?

rangeStart+":"+rangeEnd

or

rangeStart.ToString+":"+rangeEnd.ToString

Regards,

Hi Yoichi,

That really work, I didn’t think of putting double quotes for the “:”

Thank you

1 Like

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