How to get the file path of an active excel file?

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
image
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

image

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

Hi @MetaCake

Are you doing any process before reading the excel.

Regards

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.