Home » SQL & PL/SQL » SQL & PL/SQL » Writing Excel Document from PL/SQL
Writing Excel Document from PL/SQL [message #247603] Tue, 26 June 2007 08:31 Go to next message
bsharif
Messages: 2
Registered: June 2007
Location: I am - where - I am ........
Junior Member

Sample code :

if p_doc_type = 'E' then --display in excel format

owa_util.mime_header(ccontent_type => 'application/vnd.ms-excel');
owa_util.HTTP_HEADER_CLOSE;




(p_doc_type ='E' ) (p_doc_type is the name of the radio button,
E=excel and H=html for the value )is coming from a radio button
which allows the user to choose to have the format of the query
seen in Excel or Html.. For some reason the information is able
to be seen in Html, but when the user select the radio button to show the
query in Excel, does not work, query still displays in HTML. Please help,
hit a complete Brick Wall. Do I need to input any libraries or any
meta tags for the browser
to know to show the query/information in Excel format?

[Updated on: Tue, 26 June 2007 08:34]

Report message to a moderator

Re: Writing Excel Document from PL/SQL [message #247662 is a reply to message #247603] Tue, 26 June 2007 13:18 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://www.bloggingaboutoracle.org/archives/how-to-create-neatly-formatted-excel-documents-using-plsql
Re: Writing Excel Document from PL/SQL [message #247676 is a reply to message #247662] Tue, 26 June 2007 14:06 Go to previous message
bsharif
Messages: 2
Registered: June 2007
Location: I am - where - I am ........
Junior Member

^^^ Thanks .. We'll appreciated...Very helpful indeed!!!!!!!
Previous Topic: ORA-01008 Error
Next Topic: to_char doesn't work with date of 1/1/1900
Goto Forum:
  


Current Time: Wed Dec 07 20:41:44 CST 2016

Total time taken to generate the page: 0.21743 seconds