Oracle reports to Excel?

[Guest_imported]

I'm trying to run oracle reports from an application server and automatically output them as Excel files...is this possible?

 

[Scunningham99]

Dont think this is possible. How would oracle invoke excell???


however you could run the report and from your form select "special copy" which would then allow you to copy and paste in to excell speadsheet.

 

[mcgibbong]

The way I do it is to generate the report (without headings and text) to a delimited file and open it in excel. This works a treat.

 

[Guest_imported]

You can create a layout such that the output value (separate ones) displayed in the layout is delimited by comma. Run the report from the url using mode=character, destype=File, desformat=wide180 or wide1000 (preferably) and write it to a csv file. When a csv file is launched it will automatically open in Excel.

The headings can also be taken care of adjusting field values in the layout. When a heading needs to be displyed display it as the required value or hide the object (make it invisible).