OraFAQ Forum: Client Tools » Spooling xls (merged 2)

Home » Other » Client Tools » Spooling xls (merged 2) (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Spooling xls issue 6.10301E+13 [message #657800 is a reply to message #657799]

Wed, 23 November 2016 05:17

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

Report message to a moderator

Re: Spooling xls issue 6.10301E+13 [message #657802 is a reply to message #657800]

Wed, 23 November 2016 05:24

cookiemonster
Messages: 13966
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.

Report message to a moderator

Previous Topic:	Help on passing variables.
Next Topic:	no orageneric11 in java.library.path

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 03:26:38 CDT 2025