You'll notice that the email address column is visible below but if you click "Export to Excel" it won't be found in the generated .CSV file.
Conversely, the telephone number column is not visible below but will be visible in the generated .CSV.
This is achieved by setting the condition of the email column to type "PL/SQL Expression" with a source of:
WWV_FLOW.g_excel_format = false
and the condition of the telephone number column to type "PL/SQL Expression" witha source of:
WWV_FLOW.g_excel_format = false
This technique can be particularly useful for hiding Column Links columns when exporting to .CSV.
|
| 1 | Eva | Green | eva.green@france.com | | 3 | Jack | Bauer | jack@ctu.gov | | 2 | John | O'Groats | somewhere@uk.com |
|
Export to Excel
|
|
|
|