The range A0 does not exist

Help StudioX
,
1

Hi, my robot searches for the first empty row using Find First/Last Data Row activity and enters the text using sentences:
Excel3.Sheet(“Sheet1”).Cell(“A” & firstemptyrow.tostring())
But if excel is empty or there are only headers then an error appears: The range A0 does not exist.

Do you have any idea how to make it work?

2

looks like firstemptyrow is not set properly, so the default value (0) is taken.
Minimum range is 1, so first cell is A1

3

Hey @sullivanne try this

This image shows an "Excel Process Scope" in a workflow, including a section for using an Excel file named "file.xlsx" with the option to create the file if it does not exist. (Captioned by AI)
This image shows an "Excel Process Scope" in a workflow, including a section for using an Excel file named "file.xlsx" with the option to create the file if it does not exist. (Captioned by AI)595×306 10.8 KB

The image shows a sequence of steps in an automation script to identify the first and last data row in an Excel sheet and write "Next" in the cell after the last populated row. (Captioned by AI)
The image shows a sequence of steps in an automation script to identify the first and last data row in an Excel sheet and write "Next" in the cell after the last populated row. (Captioned by AI)545×457 18.5 KB

Excel.Sheet(“Sheet1”).Cell(“A” & (OutLastRowIndex + 1).ToString())

so this will check the last row data and update into the next cell
and if you want to run that in the loop check the auto increament option

cheers