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: