[OAUGNet]-Re: Output to Excel Format

[Carol Francum <cfrancum@earthlink.net>]

There are a couple of options --
There are PL/SQL routines for writing to file, and you can use these to write to Excel formats.  Check metalink for details.  
You could also write to a text file using tab delimited fields ( ||chr(9)||) , and have excel have a start-up macro to bring in the data and format. Tho that's kind of back-wards.

You'd call Excel with command line controls for the file and (i think) macro

Good luck!

-----Original Message-----
From: "Lin, Iris" <Iris.Lin@UNIFORM.ARAMARK.com>
Sent: Oct 14, 2004 4:48 PM
To: OAUG Net listserver <OAUGNet@oaug.com>
Subject: [OAUGNet]-Re: Output to Excel Format

I am not sure this is what you want.  We use "OraExcel".  It is Excel with
ability to write SQL query. You write SQL in Excel and execute it. It is a
good ad-hoc report or research tool.  But it is not for mass production.
You can't link to output of a concurrent request. It is PC based and
inexpensive, around $100+.  Hope this can help. 

Thank You


Iris Lin
Information Technology
Aramark Uniform Services
Phone: 818-953-2073




-----Original Message-----
From: Scott, Ian (KAM.RHQ) [mailto:Ian.Scott@us.kline.com] 
Sent: Thursday, October 14, 2004 11:50 AM
To: OAUG Net listserver
Subject: [OAUGNet]-Output to Excel Format

Folks,

Probably a bad question given the relationship between Bill and Larry but
has anyone been successful directing output from the 11i application
DIRECTLY to Microsoft Excel file?

I do not want to use a CSV file or TXT file I would like to direct my output
directly to an Excel file.

Is the a PL/SQL package or Java something out there somewhere?

All comments welcome and thanks in advance.

Scotty.

#############################################################
This message is sent to you because you are subscribed to the mailing list
<OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>

#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>



#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>