open an excel sheet from PL/SQL program [message #465325] |
Tue, 13 July 2010 11:21 |
blackpanther
Messages: 17 Registered: June 2010 Location: Bangalore
|
Junior Member |
|
|
I need to open an excel sheet from PL/SQL program where I will put in the data.Does anybody know how to open an excel sheet from Pl/sql code.I got hold of a code as below but id does not help...Looks like I need to configure DAD PL/SQL ...Can ayone tell me how???
BEGIN
-- Prepare Headers
owa_util.mime_header('application/vnd.ms-excel',FALSE);
--htp.p('Content-Length: '||document_length||NL_CHAR);
--htp.p('Content-Length: '||document_length);
--p_document_nam is the name of the excel sheet
IF p_document_name IS NOT NULL THEN
htp.p('Content-Disposition: attachement; name="'||p_document_name||'"'||NL_CHAR);
END IF;
owa_util.http_header_close;
END;
[Updated on: Tue, 13 July 2010 11:23] Report message to a moderator
|
|
|
|
|
|
Re: open an excel sheet from PL/SQL program [message #465971 is a reply to message #465857] |
Fri, 16 July 2010 03:10 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Then I think you are out of luck. IF your database was on a Windows box then you might be able to invoke Excel but on a non-Windows box I don't think that you could get Excel to run.
Would writing a 'csv' file be good enough?
David
|
|
|