Roland,
IFf you separate each column with the tab character (chr(9)), excel will
open the file without requiring you to go through the import steps.
You should be aware that the file is still not a true Excel file, and that
when you save the file, you will then be asked if you want to save it as a
true spreadsheet.
The pl/sql block below would produce a simple excel type file.
DECLARE
CURSOR c1 IS
SELECT 1 || CHR(9) || 2 || CHR(9) || 3 out_rec
FROM dual;
file_handle utl_file.file_type;
BEGIN
file_handle:=UTL_FILE.FOPEN('directory','Test.xls', 'W');
FOR c1_rec IN c1 LOOP
UTL_FILE.PUT_LINE(file_handle,c1_rec.out_rec);
END LOOP;
utl_file.fclose(file_handle);
END;
/
Hope this helps
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Monday, September 24, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L
Hallo,
How can I create a excelfile with the UTL_FILE packet, I wantthe file to be
able to opened directly in excel, without goingthrough the import step when
I open the file.
Give me an example, please.
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
