Home » SQL & PL/SQL » SQL & PL/SQL » report output to an excel file
report output to an excel file [message #36920] Thu, 03 January 2002 23:06 Go to next message
hnetscape
Messages: 30
Registered: December 2001
Location: India
Member

Hi,

How can we send the output of the d2k report to an excel sheet.

regards,
raju.

----------------------------------------------------------------------
Re: report output to an excel file [message #36923 is a reply to message #36920] Fri, 04 January 2002 03:58 Go to previous messageGo to next message
Shilpa
Messages: 59
Registered: November 2001
Member
Send the output to a file with tab as the delimiter. Once the file is created open the file using excel.

----------------------------------------------------------------------
Re: report output to an excel file [message #36926 is a reply to message #36920] Fri, 04 January 2002 04:18 Go to previous message
RYAN
Messages: 22
Registered: December 2000
Junior Member
got portal?

if so, you should be able to call an intermedia api to do that for ya...i don't know which, but i'm pretty sure i've seen this before.

if this is going through webDB, you could also do what Shilpa said, "output to a file with tab as the delimiter", with a file name of <file>.xls, then redirect to that filename. with IE, it'll automatically open excel, in NS, depending on setup, should automatically download it for ya.

don't know if this will help or not...just an idea.

r.

----------------------------------------------------------------------
Previous Topic: PLS-00201 error ...
Next Topic: Terminating an Oracle PL/SQL procedure from Unix
Goto Forum:
  


Current Time: Wed Dec 25 09:37:32 CST 2024