Home » SQL & PL/SQL » Client Tools » Spooling xls (merged 2) (Oracle 11g)
Spooling xls (merged 2) [message #657799] Wed, 23 November 2016 05:03 Go to next message
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


icon5.gif  Spooling xls issue 6.10301E+13 [message #657800 is a reply to message #657799] Wed, 23 November 2016 05:17 Go to previous messageGo to next message
ash25
Messages: 2
Registered: November 2016
Junior Member
having issue to spool the data to xls file using sqlplus. when spooling is done i could see few column values with 6.10301E+13 after clicking the column value 61030100015696 gets displayed properly.

have tried few options like set column format,set numwidth but in vain.

Please suggest how do i fix it. As of now i am using below values to spool the data.

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
--COLUMN DEBITING_ACCOUNT FORMAT 999999999999999999999999
--COLUMN BENEFICIARY_ACCT FORMAT 999999999999999999999999

Re: Spooling xls issue 6.10301E+13 [message #657802 is a reply to message #657800] Wed, 23 November 2016 05:24 Go to previous message
cookiemonster
Messages: 12961
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.
Previous Topic: Help on passing variables.
Next Topic: no orageneric11 in java.library.path
Goto Forum:
  


Current Time: Fri Dec 15 12:11:37 CST 2017

Total time taken to generate the page: 0.01415 seconds