Monkeybread Software - MBS FileMaker Plugin: XL.Sheet.NamedRange

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: 9.3 9.4 9.5 10.0 10.1 10.2 10.3 10.4 10.5 10.6 Statistic FMM Blog

XL.Sheet.NamedRange

Gets the named range coordinates by index.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
XL	3.5	Yes	Yes	Yes	Yes	Yes

MBS( "XL.Sheet.NamedRange"; bookRef; sheetIndex; Index; selector { ; 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

Index The index of the named range from 0 to XL.Sheet.NamedRangeCount. 0

selector What information to return: rowFirst, rowLast, colFirst, colLast and name. "name"

ScopeID The scope ID to use for search.
Can be -2 for undefined, -1 for workbook or positive number for other IDs.
Default is undefined. -1 Optional

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
Index	The index of the named range from 0 to XL.Sheet.NamedRangeCount.	0
selector	What information to return: rowFirst, rowLast, colFirst, colLast and name.	"name"
ScopeID	The scope ID to use for search. Can be -2 for undefined, -1 for workbook or positive number for other IDs. Default is undefined.	-1	Optional

Result

Returns value or error.

Description

Gets the named range coordinates by index.

Blog Entries

MBS FileMaker Plugin, version 8.2pr1

Release notes

Version 8.2
- Added scope ID parameter for XL.Sheet.GetNamedRange and XL.Sheet.NamedRange.

Created 18th August 2014, last changed 16th March 2018

XL.Sheet.MergeSize - XL.Sheet.NamedRangeCount