1. Administering and Working with Enterprise Profitability and Cost Management
  2. Analyzing Data
  3. Working with Data in Forms
  4. Exporting Data to Microsoft Excel

Exporting Data to Microsoft Excel

By exporting data from a form to Microsoft Excel, you can explore "what-if" scenarios in Excel before copying and pasting values back to your business process.

About exporting data:

  • Your business process doesn't export these details to Excel: Supporting Detail, cell comments, numerical formatting, the application name, user, form folder, attributes, currency tags, or percentages.

  • Full decimal places are exported for numerical values, but scaling isn’t applied to preserve accuracy. When you view the exported data in Oracle Smart View for Office, data displays like it does in the business process form.

  • Member aliases display if your administrator sets the form to display them.

  • Values pasted back to your business process from Excel must be unformatted data.

To export data from forms to Microsoft Excel:

  1. Open a form.
  2. Click Actions, then Spreadsheet Export, and then Export.
  3. Either open or save the file.

    Use standard Excel procedures to make and save your changes.