[Advanced Excel] How to read range of columns and rows
excel-png
Web icon
Forge component by Carlos Freitas
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. 

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

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