We have a huge excel file and we need to know the number of rows it has. Because of the complexity and time the process requires to complete the operative, we are trying to not read the excel.
Can we extract this information as a “extract file info” or something like this?
PD: Read range or Excel application scope - read range is not an option.
Use below mentioned vba code to find out the number of rows in excel file if you don’t want to use Excel or Workbook activities.
Thank you so much @lakshman. I have a question about this code tho:
Dim crb1 As Long
crb1 = ActiveCell.Row
In this code I see how to count the number of rows of a certain range in a specific sheet, but how do we say which is the file? I am not very familiar with VBA…
1/ You could use some extension package from marketplace, e.g. GetLastRow activity from
2/ If you could modify the excel file you could use following formula to find non-empty row
You can use Find First/Last row activity.
Below thread might help you.