Setting a COLUMN WIDTH for EXCEL output

[LeonelSanchezJr]

I need to force a column width for my Excel Output.
I have tried this

TABLE FILE SQLOUT
PRINT FIELD1/A10 AS 'DATE'
END

But, the column width is still much wider than 10 and the widest field is less than 10 even the heading.


Thanks,

Leo ;-)

 

[focwizard]

When you say 'Excel Output', what TYPE of excel (EXCEL, EXL95, EXL97, EXL2K)? If EXL2K, you can control the width with the WRAP parameter of stylesheets.

 

[LeonelSanchezJr]

EXL2K

Thanks,

Leo ;-)