Jason has attended:
Excel Advanced course
Oracle
Does anyone know a good way to get Oracle reports into Excel?
RE: Oracle
Hi Jason, Thank you for your post, in answer;
First make a report then; in the "File" Menu there is an option to "Generate File", in that select "Delimited". A small box appears with the window title "Delimited Output". In that window, specify the date format you gave in the report, if there is one. Specify numbers and cell wrappers also. Then click "OK". If there are no special formats simply press OK.
Then, it will ask you to type the file name for generating the output.
Next go to "Save As". Type in the window "Select All Files". In file name box give the file name as ".xls" and save it.
Compile and run the report. Then the report will be generated.
In your folder you will see the file name with the name you had saved with .xls type that will contain data of that particular report.
I hope that has helped, best regards Pete
