Read Column Excel Integration, variable as range does not working

[Belia_Baez (Belia Báez)]

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,

[Yoichi]

Hi,

Can you try the following expression?

rangeStart+":"+rangeEnd

or

rangeStart.ToString+":"+rangeEnd.ToString

Regards,

[Belia_Baez (Belia Báez)]

Hi Yoichi,

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

Thank you