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.2   12.3   12.4   12.5   13.0   13.1   13.2   13.3   13.4   13.5    Statistic    FMM    Blog  

XL.Sheet.SetRowPx

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.SetRowPx"; bookRef; sheetIndex; Row; Height { ; 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
Row The row index to set.
First row is zero.
0
Height The new row height measured in pixels. 20
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 20 pixel height for 3rd row:

Set Variable [ $r ; Value: MBS( "XL.Sheet.SetRowPx"; $book; $sheet; 2; 20 ) ]

See also

Release notes

Blog Entries

This function checks for a license.

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


XL.Sheet.SetRowHidden - XL.Sheet.SetRows

💬 Ask a question or report a problem