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.SetNamedRange

Sets the named range.

Component Version macOS Windows Linux Server iOS SDK
XL 3.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Sheet.SetNamedRange"; bookRef; sheetIndex; name; rowFirst; rowLast; colFirst; colLast { ; scopeId } )   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
name The name to use for the named range. "test"
rowFirst The first row for the area. First row has index 0. $row
rowLast The last row for the area. First row has index 0. $row+1
colFirst The first column for the area. First column has index 0. $column
colLast The last column for the area. First column has index 0. $column+1
scopeId The scope ID to use.
Can be -2 for undefined, -1 for workbook or positive number for other IDs.
Default is undefined.
Optional

Result

Returns OK or error.

Description

Sets the named range.

See also

Release notes

Blog Entries

This function checks for a license.

Created 18th August 2014, last changed 21st April 2018


XL.Sheet.SetName - XL.Sheet.SetPaper

💬 Ask a question or report a problem