Home » Developer & Programmer » Forms » how to generate excel file from oracle reports?
how to generate excel file from oracle reports? [message #673246] Tue, 13 November 2018 06:08 Go to next message
rehmankhan
Messages: 22
Registered: July 2018
Junior Member
Form version : Oracle 10g

Report version : Oracle 10g

OS : Windows xp

Oracle APPS ERP

I have report need to generate via excel by click button in the oracle form The existing reports are in pdf format. I tried to find something, but I couldn't succeed. Please provide better solution. I am using oracle database 10g and Application ERP
Re: how to generate excel file from oracle reports? [message #673250 is a reply to message #673246] Tue, 13 November 2018 07:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
rehmankhan wrote on Tue, 13 November 2018 04:08
Form version : Oracle 10g

Report version : Oracle 10g

OS : Windows xp

Oracle APPS ERP

I have report need to generate via excel by click button in the oracle form The existing reports are in pdf format. I tried to find something, but I couldn't succeed. Please provide better solution. I am using oracle database 10g and Application ERP

Oracle 10g has NO native ability to generate true (*.XLS) Excel file directly.
Oracle can produce either Comma Separated Value (*.CSV) or XML files that can be read into Excel.
Is either (*.CSV or *.XML) of above acceptable to you?
Re: how to generate excel file from oracle reports? [message #673260 is a reply to message #673250] Tue, 13 November 2018 22:38 Go to previous messageGo to next message
rehmankhan
Messages: 22
Registered: July 2018
Junior Member
ok can you provide me sample code about (*.csv). I am a beginner in this field.
Re: how to generate excel file from oracle reports? [message #673336 is a reply to message #673260] Thu, 15 November 2018 08:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
rehmankhan wrote on Tue, 13 November 2018 20:38
ok can you provide me sample code about (*.csv). I am a beginner in this field.

Unwilling or incapable to use GOOGLE yourself?

http://lmgtfy.com/?q=oracle+output+csv+file+example
Re: how to generate excel file from oracle reports? [message #673351 is a reply to message #673246] Fri, 16 November 2018 01:15 Go to previous message
John Watson
Messages: 8644
Registered: January 2010
Location: Global Village
Senior Member
You could use Apex Office Print,
https://www.apexofficeprint.com/index.html
you send it the data as a JSON doc and it comes back as an Excel spreadsheet. Very impressive.
Previous Topic: Data missing in excel report using RUN_REPORT_OBJECT procedure
Next Topic: 40735: when-button-pressed trigger raised unhandled exception ORA-305500
Goto Forum:
  


Current Time: Tue Dec 07 10:07:22 CST 2021