Set CSV as the Default Option for Exporting Table Data

You can specify Comma Separated Values (CSV) as the default file format for exporting most table data to excel. To specify this setting, use the File Format for Export to Excel profile option.

Note:

For tables that contain rows with detail facets, the table data doesn't get exported to the CSV format.

Follow these steps:

  1. In the Setup and Maintenance work area, go to the Manage Administrator Profile Values task in the Application Extensions functional area.

  2. Search for the File Format for Export to Excel (ORACLE.ADF.VIEW.EXPORT_DEFAULT_TYPE) profile option.

  3. In the ORACLE.ADF.VIEW.EXPORT_DEFAULT_TYPE: Profile Values section, click the New icon.

  4. From the Profile Level list, select Site.

  5. From the Profile Value field, select Export to CSV.

  6. Click Save and Close.