Skip to Main Content
Feature Request FR-4294
Product Area APIs
Status CLOSED

1 Voters

APEX Export When Excel can support output formulas and multiple sheets

gberp Public · Feb 27 2025

Idea Summary
APEX Export When Excel can support output formulas and multiple sheets?

Use Case
Sometimes the output data is more than 1 million rows, and it may be necessary to divide multiple sheets to output Excel. Most Excel users have formulas, and you can see the formula calculated by the column data by exporting formulas to Excel, and users will automatically update the data according to the formula when modifying a column data.

Preferred Solution (Optional)
Output Excel through PL/SQL packages, but it violates the low-code principle.

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Comments

Comments

  • menno.hoogendijk APEX Team OP 11 days ago

    Hi @gberp ,

    Would the idea be to define formulas in addition of columns?

    Something like this?

    apex_data_export.add_xlsx_formula(
        p_formulas       => l_xlsx_formulas,
        p_formula        => '=COUNT(E2:E5)',
        p_cell           => 'D1' );