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.InsertSheet
Inserts a new sheet to this book at position index, returns the new sheet index.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| XL | 3.5 | Yes | Yes | Yes | Yes | Yes |
MBS( "XL.Book.InsertSheet"; bookRef; Index; Name { ; InitSheet } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| bookRef | The reference to the workbook. Please use XL.LoadBook to load a file. | $ref | |
| Index | The index where to insert the sheet. | 0 | |
| Name | The name for the new sheet. | "Taxsheet" | |
| InitSheet | The index of an existing sheet to use as template. | 0 | Optional |
Result
Returns new sheet index or error message.
Description
Inserts a new sheet to this book at position index, returns the new sheet index.Use initSheet parameter if you wish to copy an existing sheet.
Note initSheet must be only from this book.
See also
Created 18th August 2014, last changed 9th July 2015
XL.Book.GetText - XL.Book.IsDate1904
Feedback: Report problem or ask question.
Links
MBS Xojo PDF Plugins
