I am new to UiPath StudioX and working on a POC for my team. I’ve successfully gotten most of the process to work correctly; however, I’m having an issue updating the last active row in an Excel file to record a log record.
Is it possible to use the “Find First/Last Data Row” action to create an expression to use the last row number for the “Where to write” field for the “Write Cell” action?
There might be an easier way to complete the task, but I’m using the “Find First/Last Data Row” action
to save the last row number to a variable titled “LastRow.”
Next, I am using the “Write Cell” action to update the log record in Excel, but have it as a static row reference, i.e., MyExcelFIle.Sheet(“LogNumbers”).Cell(“D1443”). What I would like to do is enter an expression like MyExcelFIle.Sheet(“LogNumbers”).Cell(“D” & LastRow &" )" so the row number updates each time the robot runs.
Thanks in advance for your help.