[Advanced Excel] How to read range of columns and rows

Back to Forums

Lenon Manhães Villeth

Champion

[Advanced Excel] How to read range of columns and rows

Question

Reactive

Forge

Application Type

Reactive

Hello there.

I'm trying to read from a complex excel template. For my usecase I need to read different ranges inside the same tab, for instance, columns from B to M and rows from 91 to 200.

Is that possible? I'm struggling with that.

Thank you so much.

14 Mar

Hasan Derawan

Champion

Hi Lenon,

I think you can create two local variables, one for row count and another for column count. Initialize the column with the value 2. Then apply the following while loops to read the cells you want (column by column):

Hope that will solve your issue.

Regards,

Hasan

15 Mar

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines