| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
XL.Sheet.SetRow
Sets row height and format.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| XL | 3.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "XL.Sheet.SetRow"; 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 point size. Zero for automatic height. |
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 row height and format.Row may be hidden.
Height is in points. If you want to convert from pixels to points you can use this calculation: points = pixels * 72 / 96. So for a height of 72 pixel, you pass 54 points.
See also
- XL.Book.AddFormat
- XL.Book.SheetCount
- XL.Format.SetAlignH
- XL.LoadBook
- XL.Sheet.GetZoom
- XL.Sheet.SetCol
- XL.Sheet.SetColPx
- XL.Sheet.SetName
- XL.Sheet.SetRowPx
- XL.Sheet.SetZoom
Release notes
- Version 13.3
- Added XL.Sheet.SetColPx and XL.Sheet.SetRowPx functions.
- Version 13.0
- Fixed XL.Sheet.SetColumn and XL.Sheet.SetRow to better.
- Version 11.2
- Added XL.Sheet.SetRows function.
Blog Entries
This function checks for a license.
Created 18th August 2014, last changed 17th July 2023
