| Formatting using UTL_FILE package [message #407060] |
Mon, 08 June 2009 05:42  |
ashok_lila
Messages: 9
Registered: April 2006
Location: New Delhi
|
Junior Member |
|
|
Hi,
I created a excel file using UTL_FILE package.
This file is generating in excel format from RDF.
I can move the data without any formatting like BOLD/ITALIC.
I want to format the data also using this package.
Can anyone tell the way using of that I can format the data in file.
Code:
v_FileID:= Utl_File.Fopen(Location=>'FLS_ORAOUT', FileName=>:p_filename, Open_Mode=>'A', Max_Linesize => 32767);
Utl_File.Put(v_FileID,CHR(9));
Utl_File.Put(v_FileID,CHR(9));
Utl_File.Put(v_FileID,CHR(9)||CHR(9)||:p_report_title);
Utl_File.Putf(v_FileID, '\n');
Utl_File.Putf(v_FileID, '\n');
Utl_File.Put(v_FileID,CHR(9)||CHR(9)||:p_cust_name_no);
Utl_File.Putf(v_FileID, '\n');
Utl_File.Put(v_FileID,CHR(9)||CHR(9)||:p_plant_name);
Utl_File.Putf(v_FileID, '\n');
Utl_File.Put(v_FileID,CHR(9)||CHR(9)||:p_location);
Utl_File.Putf(v_FileID, '\n');
Utl_File.Putf(v_FileID, '\n');
Utl_File.Put(v_FileID,CHR(9)||CHR(9)||'Spare parts Lists');
Utl_File.Putf(v_FileID, '\n');
Utl_File.Putf(v_FileID, '\n');
Utl_File.Putf(v_FileID, '\n');
Utl_File.Putf(v_FileID, '\n');
Utl_File.Putf(v_FileID, '\n');
Utl_File.Fclose(v_FileID);
Where :p_filename = filename.xls
Thanks in advance...
Thanks
Ashok K Gupta
|
|
|
|
|
|
|
|
|
|
| Re: Formatting using UTL_FILE package [message #407184 is a reply to message #407060] |
Tue, 09 June 2009 00:02  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
| ashok_lila wrote on Mon, 08 June 2009 12:42 | I created a excel file using UTL_FILE package.
|
No you did NOT. You created a comma separated file (csv), which can be read by Excel.
This is not the same as an Excel file. An Excel file typically has a .xls extension and is binary.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
