Forum Stats

  • 3,874,662 Users
  • 2,266,761 Discussions
  • 7,911,933 Comments

Discussions

How to export hidden field to Excel (CSV)

729883
729883 Member Posts: 39
edited Feb 11, 2010 1:24PM in APEX Discussions
Hi,

I would like to export my report to Excel. There are some hidden fields (lat modification date of the record, primary key column etc.) that are not displayed on the screen but the user would like to have it in the export output.

Can I persuade Apex to export not only displayed items to the CSV file? Currently Apex seems to ignore all report columns that are not displayed.

Tamas
Tagged:

Answers

  • 631222
    631222 Member Posts: 778 Gold Badge
    Hi,

    1. Unhide the hidden filed which you want to show by ticking the show checkbox.

    2. Edit that column -> go to condition tab
    select PL/SQL expression in condition type and in expression enter apex_application.g_excel_format = TRUE


    apex_application.g_excel_format = TRUE hides the field on report but will export it.


    Regards,
    Shijesh
  • 729883
    729883 Member Posts: 39
    Thanks, it works!
  • RD
    RD Member Posts: 241 Bronze Badge
    Hi Shijesh,

    I have an interactive report column that I do not want to be part of my csv export.
    Is there a way I can do that similar to your reply below .
    I tried this :
    apex_application.g_excel_format = FALSE thinking that it would show up on the report but not be included in the export but it did not work.
    Sorry to bump it in this post but I started a new post but haven't found any reply.
    Also are these documented somewhere for reference ?


    Thanks,
    Dippy
This discussion has been closed.