EXCEL_SETCOLW

Syntax

Example

Description/Remarks

EXCEL_SETCOLW first_column, last_column, column_width

EXCEL_SETCOLW 1, 3, 15

 

This formula sets columns 1-3 to a width of 15.

 

See also: Creating a file in Microsoft Excel format.

This command sets the approximate width of a range of columns in the new file created by the EXCEL_CREATE command.

Columns are counted 1, 2, 3, etc., and correspond to Microsoft Excel columns A, B, C, etc.

A valid column_width is any number from 0 to 255.  This width represents the approximate number of characters that can be displayed in a cell that is formatted with the standard font for Excel worksheets.  

By default, columns 1-100 are set to a width of 12.

Note:  If using an existing Excel worksheet to determine approximate column_width values, best results are achieved by adding 2 to the actual width of the column and then setting the column_width to this number.