I'm working on an application in APEX 24.1 and need to implement a custom Excel export feature for a report. The core requirement is to have a custom header at the top of the Excel sheet that includes two pieces of dynamic information:
- The Report Name (e.g., "Quarterly Sales Report").
- The Filter Parameters selected by the user on the page (e.g., "Start Date: 01-JAN-2024, End Date: 31-MAR-2024, Region: North").
I know that the default download options for Interactive Reports and Classic Reports don't provide a way to add this kind of custom header. I've been exploring a few methods but am running into some challenges and would appreciate some guidance on the best approach.