Error in "Append Range Workbook" activity

Help Studio
1

What is the maximum number of rows that can be appended using “Append Range Workbook”?
Appending works fine when creating a new sheet, but when appending to an existing sheet, it throws this error.
“447428” rows data

image
image363×135 9.14 KB

image
image395×132 15.3 KB

Forum Engagement Daily Reports
2

Hi @Munkhnasan_G

The error happens because appending a large number of rows to an existing sheet can cause memory issues in Excel/UiPath, not because of a row limit. To fix this, split your data into smaller chunks (like 50k rows) and append them one by one. This avoids crashes and makes the process more stable.

3

hi, @Munkhnasan_G

Excel row limit: 1,048,576 rows per sheet.

  1. Use Excel Application Scope instead of Workbook activities
  • Use Excel Application Scope → Append Range (Excel) (or Write Range with StartingCell) instead of Append Range Workbook.
  • The Excel COM engine is more robust for large and formatted sheets.
  1. Split the append into chunks
  • Break your DataTable into pieces (e.g., 50k or 100k rows):
    • First chunk: Write Range to a clean sheet.
    • Subsequent chunks: Append Range.
  • You can do this with dt.AsEnumerable().Skip().Take() in an Assign or via a small loop.
  1. Append via CSV as an intermediate step
  • Write your 447k rows to a CSV (Write CSV).
  • In Excel, either:
    • Import the CSV, or
    • Use a macro / separate automation to combine CSV with the existing sheet.
  • This is often more stable for very large data.
4

Append Range Workbook has no fixed row limit, but practically fails beyond 300k rows when appending to an existing sheet due to Excel memory constraints.

This happens due to memory flow, best to reduce in smaller chunks and append it accordingly.

Also, my suggestion would be to use excel activities instead of workbook activities for this scenario.

5

Hi @Munkhnasan_G

Please try to use excel activities instead of workbook or if you want to use workbook activity better you can divide into multiple sheets.

Thanks

6

Hi @Munkhnasan_G

There is no UiPath-specific row limit for Append Range (Workbook).
The failure happens because of Excel’s maximum row limit.

Excel limit

  • Maximum rows per sheet: 1,048,576
  • You are appending 447,428 rows to an existing sheet that already has data
    → total rows exceed the Excel limit, causing exit code 0xE0434352.

Work around

  • Append to a new sheet
  • Split data into multiple sheets (e.g., 300k rows per sheet)
  • Check existing row count before appending
  • Use multiple Excel files

Regards
Gokul

7

@Munkhnasan_G

This is due to the limitation of the workbook activity. Use Excel Process Scope approach instead of Workbook activity as the number of rows your automation is handling is higher which will make it unreliable.

8

Hi @Munkhnasan_G

Append Range Workbook is limited by the Excel worksheet maximum of 1,048,576 rows, and the error occurs when the existing rows plus appended rows exceed this limit.

Happy Automation

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.