Worksheet Data Selection
Many Excel activities operate on specific rows, columns, cells, or ranges within a worksheet.
Depending on the activity, worksheet data can be identified using row indexes, column indexes, column letters, cell addresses, or range addresses.
Not all activities support every selection method. Refer to the activity-specific documentation for the supported options.
Row Index
Zero-based position of a row within the worksheet.
For example:
| Index | Row |
|---|---|
| 0 | First row |
| 1 | Second row |
| 2 | Third row |
Row indexes are commonly used by activities that read, write, insert, delete, or format worksheet rows.
Column Index
Zero-based position of a column within the worksheet.
For example:
| Index | Column |
|---|---|
| 0 | A |
| 1 | B |
| 2 | C |
Column indexes are commonly used by activities that read, write, insert, delete, or format worksheet columns.
Column Letter
Excel column identifier.
Examples include:
- A
- B
- C
- Z
- AA
- AB
Column letters are not case-sensitive.
Column letters provide an alternative to column indexes when referencing worksheet columns.
Cell Address
Excel cell reference that identifies a single cell within a worksheet.
Examples:
- A1
- B5
- C10
- AA25
Cell addresses are commonly used by activities that read or write individual cell values, formulas, comments, or formatting.
Range Address
Excel range reference that identifies a group of cells within a worksheet.
Examples:
- A1:B10
- C5:C20
- A1:F100
- B2:D5
Range addresses are commonly used by activities that read, write, copy, clear, or format multiple cells.
Excel Addressing Model
Excel uses a combination of column identifiers and row numbers to locate cells.
Examples:
| Address | Description |
|---|---|
| A1 | First column, first row |
| B3 | Second column, third row |
| D10 | Fourth column, tenth row |
| AA1 | Twenty-seventh column, first row |
Range addresses are defined using two cell addresses separated by a colon (:).
For example:
A1:A10— First ten cells in column AA1:D1— First row across columns A through DA1:D10— Rectangular range spanning multiple rows and columns
Process Data Support
Row indexes, column indexes, column letters, cell addresses, and range addresses can be configured dynamically using variables from the Process Data drawer.
This allows activities to target worksheet data based on runtime conditions, user input, or outputs from previous activities.