| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
XL.Sheet.SetRows
Sets row height and format for multiple rows.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| XL | 11.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "XL.Sheet.SetRows"; bookRef; sheetIndex; Row; Last 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 | |
| Last row | The last row index to set. | 2 | |
| Height | The new row height measured in point size. | 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.
Description
Sets row height and format for multiple rows.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.
XL.Sheet.SetRow is for one row, but XL.Sheet.SetRows is for a range of rows.
See also
- XL.Book.SheetCount
- XL.LoadBook
- XL.Sheet.GetZoom
- XL.Sheet.SetCol
- XL.Sheet.SetColPx
- XL.Sheet.SetName
- XL.Sheet.SetRow
- XL.Sheet.SetRowPx
- XL.Sheet.SetZoom
Release notes
- Version 11.2
- Added XL.Sheet.SetRows function.
Blog Entries
- New in MBS FileMaker Plugin 11.2
- Neues MBS FileMaker Plugin 11.2
- MBS FileMaker Plugin 11.2 - More than 6500 Functions In One Plugin
- MBS FileMaker Plugin, version 11.2pr1
This function checks for a license.
Created 25th March 2021, last changed 25th March 2021
