How to use UiPath Append Range with Excel Example |Video upload date:  · Duration: PT9M5S  · Language: EN

Step by step guide to using UiPath Append Range with Excel to add rows without overwriting data and fix common problems

Think of Append Range as the polite way to add rows to an Excel sheet without bulldozing existing entries. This guide walks you through using UiPath Append Range with Excel so your robot does not act like a vandal. We will cover preparing a DataTable, choosing Excel Application Scope or Workbook activities, configuring Append Range, and troubleshooting common problems in RPA workflows.

Why Append Range matters in UiPath

Append Range is built to add rows from a System DataTable into a worksheet while preserving existing data. If you prefer your data to stay alive and arranged this is the activity you want. Use Build Data Table for small test tables or Read Range to read an existing sheet into a DataTable. Make sure column names match the target headers to avoid misalignment and missing values.

Choose the right workbook approach

UiPath offers two common approaches to work with Excel files. Use Excel Application Scope when you need Excel features or macros. Use Workbook activities when Excel is not available or when you want faster unattended runs. Workbook activities avoid COM locks and usually perform better for high volume automation.

Configure the Append Range activity

  • Place Append Range inside Excel Application Scope or call the Workbook Append Range activity directly
  • Pass your DataTable variable in the DataTable field
  • Set the SheetName string to the exact sheet name being written to
  • Leave StartingCell blank to append after the last used row
  • Toggle AddHeaders off if the target sheet already has headers or on if the sheet is empty

Run verify and troubleshoot

Run the workflow and open the workbook to confirm new rows appear below the existing data. If nothing shows up check these usual suspects.

Quick checklist

  • DataTable has rows
  • Column names align with target sheet headers
  • SheetName matches exactly including case if you are on a case sensitive system
  • File is not locked by another process or user

Common problems and fixes

  • If the file is locked close other instances of Excel or terminate the locking process responsibly
  • If you see duplicates filter source data or use a unique key to prevent repeats
  • For very large inserts consider batching rows or using Workbook activities to avoid heavy Excel interop overhead
  • When appending many rows write to a temporary sheet first then move the block to the target sheet to reduce redraw and COM operations

Pro tips that save time

Log the row count before and after the append so your robot can admit success or failure. If you use Excel Application Scope be prepared for COM quirks and test the workflow in an unattended environment. And do not rely on guesswork for sheet names. Get them from a config file or enum and your future self will send you a thank you email that will probably be ignored.

This covers creating or reading a DataTable preparing the correct workbook approach configuring Append Range and validating results while giving practical troubleshooting tips for locks duplicates and performance in RPA projects. Happy automating and try not to crash Excel with large bursts of rows.

I know how you can get Azure Certified, Google Cloud Certified and AWS Certified. It's a cool certification exam simulator site called certificationexams.pro. Check it out, and tell them Cameron sent ya!

This is a dedicated watch page for a single video.