I’m using a program that outputs an Excel file which I am manipulating and then sending it off. One of the things I need to do is get the total number of rows. I found people use the “Read Range” activity to do this. Though it seems that the range is required and I can’t leave it blank, giving it a blank variable returns a multitude of other errors
I’m not sure what the issue is at this point, is there a working way to get the total number of used rows?
Just use “” in the range, to read your entire sheet
@MetaCake can you send a screenshot of variable panel?
Hi @MetaCake
Try this way:
Make sure to change the scope of the output of Read Range to Outermost Scope.
Regards
I don’t have a filepath for the Excel doc, as it is generated by the program I’m using so I can’t use the “Use Excel File” activity
Hi @MetaCake
Can you specify what is the exact process you are doing?
Regards
Im not sure I understand what you’re asking
Yes, I’m using the “Use Application” activity to to send commands to the opened excel doc. The last thing I’m doing is trying to get the total number of cells of which I would output to a variable and type at the bottom of the doc
Yeah so Read Range failed me so I found a better way to do it
I have to save the file and then generate the path to the file from that but I guess that’s ok
(Counter variable is set to a default of 1)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.