Cell Address Generator

Overview

Cell Address Generator is an OutSystems extension that provides utility actions for converting row and column indexes into Excel-compatible references.

When generating Excel files programmatically, developers frequently need to work with Excel addresses such as:

A1
E5
AA10
AX5

or ranges such as:

A2:A100
E2:E100
AA5:AA500

This component eliminates the need to manually implement Excel column conversion logic and provides reusable actions that can be used across applications.

Features

Convert numeric column indexes to Excel column names.
Generate Excel cell references from row and column numbers.
Return individual reference components (column name, row number, full address).
Support single-letter and multi-letter Excel columns.
Suitable for Advanced Excel integrations and spreadsheet automation.

Supported Excel Column Formats

Column Number	Excel Column
1	A
2	B
26	Z
27	AA
28	AB
52	AZ
53	BA
702	ZZ
703	AAA

Available Actions

GetCellAddressByIndex

Converts a row and column number into an Excel-style cell reference.

Inputs

Name	Type	Description
RowNumber	Integer	Excel row number
ColumnNumber	Integer	Excel column number

Outputs

Name	Type	Description
CellAddress	Text	Full Excel address
ColumnName	Text	Excel column name
RowName	Text	Excel row number as text

Example

Input

RowNumber = 5
ColumnNumber = 50

Output

CellAddress = AX5
ColumnName = AX
RowName = 5

Additional Examples

Row	Column	Cell Address
1	1	A1
3	1	A3
5	50	AX5
10	27	AA10
100	702	ZZ100
1	703	AAA1

Validation Rules

The component validates the following conditions:

Condition	Result
RowNumber <= 0	Exception
ColumnNumber <= 0	Exception

Excel references require row and column numbers greater than zero.

Technical Notes

Excel columns are generated using a Base-26 alphabetical conversion:

1  -> A
26 -> Z
27 -> AA
28 -> AB
...
703 -> AAA

The component supports any valid positive column number and is not limited to the commonly used Excel columns.