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.GetText
Queries the text of a sheet in a workbook.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| XL | 3.5 | Yes | Yes | Yes | Yes | Yes |
MBS( "XL.Sheet.GetText"; bookRef; Index { ; formulas } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| bookRef | The reference to the workbook. Please use XL.LoadBook to load a file. | $ref | |
| Index | The index of the sheet you want to query text. Value can be 0 to XL.Book.SheetCount-1. | $index | |
| 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 sheet.
Description
Queries the text of a sheet in a workbook.Numbers are formatted as floating point numbers with dot as decimal separator.
Boolean values are returned as FALSE or TRUE.
See also
Created 18th August 2014, last changed 19th April 2016
XL.Sheet.GetRowHidden - XL.Sheet.GetTopLeftView
Feedback: Report problem or ask question.
Links
MBS Xojo PDF Plugins
