How to append range in the first blank row?

Hello,

I want to paste some data in an Excel sheet. My Excel sheet is like follows:

CELL_A1 CELL_B1 CELL_C1
CELL_A2 CELL_B2 CELL_C2
CELL_B3 CELL_C3

CELL A5 CELL_B5 CELL_C5

When I use the activity append range, the data i want to paste is typed in the third row (as the CELL A3 is blank) but i really want to type the information in a complete blank row (the forth row).

How can I do?

Please use the write range activity (Address: "A" + (lastRow+1)).ToString)

Use Read Range to find the last row (lastRow = DT.Rows.Count)

Regards,
Karthik Byggari

1 Like

Select the first two rows and delete them manually. save the file and run the bot now.

You might have entered some data earlier and deleted it by selecting the cells and not entire rows. Hence the cache still exists in the file. That’s the reason data is being appended to 3rd row.

Also if you are using build datatable activity, open the column designer in the build datatable activity and check is there any empty rows there. If there, delete them by clicking ‘x’ associated with the row.

2 Likes