Cell Address Generator is a lightweight utility component for OutSystems that simplifies working with Excel cell references and addresses programmatically.

When generating or manipulating Excel files dynamically, developers often need to convert row and column indexes into Excel-compatible references such as A1, AX5, AA10, or ranges like E2:E100. This component provides reusable actions to perform these conversions without requiring custom logic in every application.

Features

• Convert column numbers to Excel column names
  • 1 ? A
  • 26 ? Z
  • 27 ? AA
  • 50 ? AX
  • 703 ? AAA
• Generate Excel cell addresses from row and column numbers
  • (Row=1, Column=1) ? A1
  • (Row=5, Column=50) ? AX5
  • (Row=10, Column=27) ? AA10
• Return individual reference components
  • Cell Address (AX5)
  • Column Name (AX)
  • Row Number (5)
• Build dynamic Excel ranges for scenarios such as:
  • Data validation dropdowns
  • Conditional formatting
  • Formula generation
  • Dynamic spreadsheet creation
  • Advanced Excel integrations