Exporting Cash Forecasts to Microsoft Excel Spreadsheets
You can transfer cash forecast spreadsheets to Microsoft Excel. Excel can be very useful to manipulate information for analysis and graphical representation.
Use the Export feature in Oracle Applications to export cash forecasts from Cash Management to Microsoft Excel.
Note: This option is available only on the Windows platform, and only if Excel is installed.
To export cash forecasts to Excel:
1. Navigate to the Cash Forecasts window.
4. Choose Export... from the Action menu. The Export Data window appears.
5. Select the To Microsoft Excel option to export your cash forecast to an Excel Spreadsheet.
6. Choose whether to check the Autosize all columns check box. Checking this check box ensures that Excel will display all records in correctly sized columns. If you do not autosize all columns Excel may display "#####" when the record for a cell exceeds the default column size. However, if you do autosize all columns and your data contains very large entries, the columns created in Excel may be excessively wide and difficult to read.
7. Choose the Export button. Cash Management exports all selected records, excluding summary rows, and opens Excel. Excel automatically displays your forecast.
8. You can make any modifications to your spreadsheet in Excel. You should name and save your spreadsheet to a directory on your PC or network.
Note: Saving in Excel does not save an updated spreadsheet in your Oracle database.
See Also