Question
VA
US
Last activity: 19 May 2025 14:32 EDT
Finding first empty excel row
Morning,
I realize this may be a simple question but I'm trying to figure out how to copy data into the first empty row in excel. The current automation will accept me extracting data multiple times and paste into different rows but if I run it again it will overwrite the previous info.
Accepted Solution
Updated: 19 May 2025 14:32 EDT
Pegasystems Inc.
US
@JahriC17390650Here is a sample solution. I prefer to use the ExcelConnector.GetLastAddress method. It returns the cell address of the last cell, and you can use the AddressToRowColumn method to convert that to rows and columns. From here, you can add one to the value to get the first empty row.
VA
US
@ThomasSasnettSo I understand what you're saying about finding the cell and adding one to get the first row but I'm lost on how to apply it within my automation lol
VA
US
@JahriC17390650this is probably the better example of the automation
Pegasystems Inc.
US
@JahriC17390650I prefer to use an Integer variable instead of the counter component. The variable has an Increment method, so you could set its value to the result of the GetLastCellAddress method I showed above and then increment the variable to use its value in SetCellValue. You can then increment it every row to ensure you are writing to the next row.
VA
US
@ThomasSasnett hmmm so my integer value has 3 properties but not an increment method. I tried looking into the variabletypes but couldn't find it. I assume I'm in the wrong place?
Pegasystems Inc.
US
@JahriC17390650Would you please show me a screenshot from the Select Action dialog (when you drag the variable onto the automation surface from the Palette)?
VA
US
@ThomasSasnett no need I realized I goofed and was copying and pasting instead of dragging it from the palette lol sorry