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.GetText
Queries the text of a workbook.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| XL | 3.5 | Yes | Yes | Yes | Yes | Yes |
MBS( "XL.Book.GetText"; bookRef { ; formulas } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| bookRef | The reference to the workbook. Please use XL.LoadBook to load a file. | $ref | |
| formulas | Whether to return formulas as text. If you pass 1 here, the formulas will be returned instead of their result. | 0 | Optional |
Result
Returns text of workbook.
Description
Queries the text of a workbook.Numbers are formatted as floating point numbers with dot as decimal separator.
Boolean values are returned as FALSE or TRUE.
This function will not calculate formulas.
See also
Example Databases
Created 18th August 2014, last changed 19th April 2016
XL.Book.GetRefR1C1 - XL.Book.InsertSheet
Feedback: Report problem or ask question.
Links
MBS Xojo Plugins
