Skip to Content (Press Enter)
2026-02-05 15-36-36
Lenon Manhães Villeth
Champion
245Views
2Comments
Solved
[Advanced Excel] How to read range of columns and rows
Question
Reactive
Forge
advanced-excel
Service icon
Advanced Excel (O11)
Forge asset 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. 

0
0
14 Mar 2022
Copy Link
2023-09-01 08-29-06
Hasan Derawan
Staff
Solution

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

1
0
15 Mar 2022
Copy Link
2023-07-03 01-27-22
Naaliel Corrêa de Oliveira Lima

Thank you, it helped with my problem

0
0
13 Jul 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.