Spooling xls (merged 2) [message #657799] |
Wed, 23 November 2016 05:03 |
|
ash25
Messages: 2 Registered: November 2016
|
Junior Member |
|
|
I am having issues to spool the data to xls file. Though i have tried set numwidth,set column format nothing seems to be working.
My output shows 6.20301E+13 for few columns. if i click on the value it will show complete number 62030100033074.
How do i fix this issue? as of now i am using below values to spool the values
set heading on
set feedback off
SET MARKUP HTML ON
set linesize 32766
set pagesize 1000
set numwidth 40
spool /ebapp_inst1/workingdir/log/Reports/Failed_Transaction_$tdy.xls REPLACE
col DEBITING_ACCOUNT hea 'DEBITING ACCOUNT' for 9999999999999999
|
|
|
|
Re: Spooling xls issue 6.10301E+13 [message #657802 is a reply to message #657800] |
Wed, 23 November 2016 05:24 |
cookiemonster
Messages: 13943 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
This would be an issue with excel not making the columns wide enough by default. I doubt there's anything you can do in sqlplus to fix it.
Bear in mind that you're not really creating an actual true xls, you're creating an text file that excel can interpret as a spreadsheet. There's no way I no of of setting excel column widths in a plain text file. That information is stored in real xls as binary data.
|
|
|