Monkeybread Software - MBS FileMaker Plugin: XL.Book.SheetIndexForName

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.Book.SheetIndexForName

Queries sheet index for sheet name.

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

MBS( "XL.Book.SheetIndexForName"; bookRef; Name ) More

Parameters

Parameter Description Example

bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref

Name The name of the sheet to keep. "People"

Parameter	Description	Example
bookRef	The reference to the workbook. Please use XL.LoadBook to load a file.	$ref
Name	The name of the sheet to keep.	"People"

Result

Returns number or error.

Description

Queries sheet index for sheet name.
Returns empty result if not found.

Examples

Shows index for a sheet:

Show Custom Dialog ["Sheets"; MBS("XL.Book.SheetIndexForName"; $bookRef; "Reiter 2")]

Blog Entries

MBS FileMaker Plugin, version 5.4pr5

Created 4th November 2015, last changed 4th November 2015

XL.Book.SheetCount - XL.Book.Sheets