I am writing to seek technical guidance on generating a custom-formatted Excel file from an OutSystems ODC application.

REQUIREMENT OVERVIEW

We need to export a Satisfaction Scorecard Excel report with the following structure:

• Rows (Vertical): 16 predefined measurement/survey questions (fixed)

• Columns (Horizontal): Dynamic — each evaluator/user gets their own column

• Each cell in the data grid = the score (1–4) given by that user for that question

• Two fixed summary columns at the end: "Required Score on Attempt" and "Score Secured"

• Summary rows at the bottom: Marks Given, Marks of Questions Attempted, Questions Attempted, % Satisfaction, Average Score

FORMATTING REQUIREMENTS

• Merged cells for the report title across all user columns (Rows 1–2)

• User names displayed horizontally with 90° text rotation in header row

• Alternating row colors (white/light grey) for the 16 question rows

• Green background (#C6E0B4) for the header block

• Soft green (#E2EFDA) for summary rows

• Percentage formatting for the % Satisfaction row

• Bold green font for the overall Score Secured value

CHALLENGE FACED

The built-in OutSystems RecordListToExcel action does not support:

1. Dynamic number of columns (users vary per survey round)

2. Merged cells

3. Cell-level formatting (colors, rotated text, number formats)

4. Formula-based summary rows

REQUEST

Could you please provide:

1. Confirmation of which Forge component (Excel_Library ODC or other) is recommended for this use case

2. A sample Server Action flow or pseudocode for writing dynamic columns with cell-level formatting in ODC

3. Clarification on how to retrieve the final Excel binary for the Download node in ODC

4. Any known limitations of the Excel Library ODC component for this type of export

I share screenshots of the required Excel format or further details if needed.