• Exporting a Report into Excel
• Exporting a Report into Excel
• "6e8f30c3-934d-4617-bd56-ce8732ceee3f
• All of the
• Standard Oracle Reports
• open in a browser window and have the capability to be exported into
• Excel
• .
• When the report has completed the request process and the
• Phase = Completed
• and the
• Status: Normal
• , we are now able to review the report.
• Click the 
• View Output
•  button to review the report (
• RU Revenue/Expense-3 Selections Report
• ).
• Click the 
• Save As...
•  menu option.
• Select the location that you would like to save the report to.
• For this example select the 
• Desktop
•  button.
• Click the 
• Save
•  button to save the report as a text file.
• click the windows
• Start menu
•  button.
• Click the 
• Office Button
•  button to open the text file that was saved to the Desktop earlier.
• Click
• Open
•  from the menu.
• Click the 
• Files of type
• drop down list.
• Select
• All Files (*.*)
•  from the drop down list.
• Select the location that you save the text file to. 
• For this example, click the 
• Desktop
•  button.
• Select the file name:
• RU_Rev/Exp_Report.txt
•  from the desktop.
• Click the 
• Open
•  button.
• Select
• Fixed width
• as the
• Original data type
• .
• For this example leave the data preview with the break lines as the default.
• Click the 
• Next >
•  button.
• Note:
• The default break lines can be moved, deleted or new lines can be created as needed by clicking on them or dragging them.
• Click the 
• Finish
•  button.
• Note:
• Default
• Column data format: General
• - leave as is for this example.
• Click the 
• File
•  menu.
• The standard report opens in a browser window.
• In the 
• File name
• field enter the name you would like the report to be saved as. For this example enter
•  a valid value e.g.
•  "
• RU_Rev/Exp_Report
• ".
• Note:
• Leave the following fields as the default:
• Save as type
• : Text File (*.txt)
• Encoding
• : Western European (Windows)
• The report is now saved in the location you chose, For this example we saved the report on the
• Desktop
• so we will now navigate to Excel to find the file and complete the export.
• Click the 
• Microsoft Office Excel 2007
•  from the programs list.
• Microsoft Excel will open a new workbook.
• Modify the report in excel by expanding the columns and moving the figures around as needed.
• Original Path
• View Output
• Save As...
• Desktop
• Save
• Start
• Office Button
• Open
• Files of type:
• All Files (*.*)
• Desktop
• RU_Revenue_Expense_3_Selection_080909.txt
• Open
• Next >
• Next >
• Finish
• File
• File Name
• Microsoft Office Excel 2007