Append Excel Range

Append Excel Range

Type: excel-append-range  ·  Package: Excel Activities v1.0.0

Adds rows immediately below the last row of data on the sheet, starting in column A. Unlike Write Excel Range (which writes to a fixed position that you indicate), Append calculates where what’s already there ends and adds next — ideal for accumulating data on a sheet over time without overwriting.

Takes a DataTable (or a single row as a DataRow) and writes only the cell values, not the row of column names (it does not add a header).

How it works

1. Detects the last row with data on the sheet.
2. Write data starting from the next row, always from column A.
3. The DataTable is written row by row, without headers (a DataRow, in a single row).
4. Guarda.

Accepts session or path — see the two modes.

What does “no headers” mean?

Append Range writes only the values of the cells. If you need column names to be entered the first time as well (and only rows to be added the following times), use Append Excel Rows, which handles the header for you.

Required parameters

Parameter	Editor	Description
data	expression	The DataTable to add (or a DataRow for a single row). Writes the values, without headers.

Optional parameters

Parameter	Editor	Description
session	expression	Excel Open session (instead of path).
path	expression	Route to .xlsx (quick mode: open, save and close alone).
sheet	expression	Name or index of the sheet. By default, the first.

Example

Append the rows of a DataTable to the end of a history file:

Append Excel Range   path = = "C:/logs/history.xlsx"   data = = records    // a DataTable

Append Range vs Append Rows

• Append Excel Range: Adds only the values (a DataTable or a DataRow) without writing headers. Start in column A.
• Append Excel Rows: adds the rows of a DataTable and writes the headers only if the sheet is empty — designed to accumulate tables with titles.

Related activities

• Append Excel Rows — accumulate DataTables with smart header.
• Write Excel Range — write at a fixed position.