Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 12.1   12.2   12.3   12.4   12.5   13.0   13.1   13.2   13.3   13.4    Statistic    FMM    Blog  

XL.Sheet.SetColPx

Sets column width in pixels and format for all columns from colFirst to colLast.

Component Version macOS Windows Linux Server iOS SDK
XL 13.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Sheet.SetColPx"; bookRef; sheetIndex; ColFirst; ColLast; Width { ; Format; Hidden } )   More

Parameters

Parameter Description Example Flags
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
sheetIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0
ColFirst The first column. 0
ColLast The last column. 0
Width The new column width in pixels.
Value -1 is used for autofit column widths.
100
Format The format for the cell. This is index from 0 to XL.GetFormatCount-1 in the book's list of formats. 0 Optional
Hidden Whether to hide columns. 0 Optional

Result

Returns OK or error message.

Description

Sets column width in pixels and format for all columns from colFirst to colLast.
If format equals 0 then format is ignored. Columns may be hidden.

Examples

Set first column to 200 pixel:

Set Variable [ $r ; Value: MBS( "XL.Sheet.SetColPx"; $book; $sheet; 0; 0; 200) ]

See also

Release notes

Blog Entries

This function checks for a license.

Created 2nd July 2023, last changed 27th August 2023


XL.Sheet.SetColHidden - XL.Sheet.SetColumn

💬 Ask a question or report a problem