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

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

Moves a sheet.

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

MBS( "XL.Book.MoveSheet"; bookRef; SourceIndex; DestIndex ) More

Parameters

Parameter Description Example

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

SourceIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0

DestIndex The destination index of the sheet. 0

Parameter	Description	Example
bookRef	The reference to the workbook. Please use XL.LoadBook to load a file.	$ref
SourceIndex	The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1.	0
DestIndex	The destination index of the sheet.	0

Result

Returns OK or error.

Description

Moves a sheet.
Takes a sheet with SourceIndex and insert it in front of a sheet with DestIndex.
Returns OK on success and error on failure.

Blog Entries

MBS FileMaker Plugin, version 7.2pr5

Release notes

Version 7.2
- Added XL.Book.MoveSheet function.

Created 27th April 2017, last changed 27th April 2017

XL.Book.IsTemplate - XL.Book.PictureCount