Topics
All
Mac OS X
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Guides
Examples
New in version:
7.4
7.5
8.0
8.1
8.2
8.3
8.4
8.5
9.0
9.1
Statistic
XL.Sheet.CellReadComments
Reads all the comments from cells in an area.
Component | Version | macOS | Windows | Server | FileMaker Cloud | FileMaker iOS SDK |
XL | 8.0 | Yes | Yes | Yes | Yes | Yes |
MBS( "XL.Sheet.CellReadComments"; bookRef; sheetIndex; First row; Last row; First column; Last column { ; Row Delimiter; Column Delimiter } ) More
Parameters
Parameter | Description | Example value |
---|---|---|
bookRef | The reference to the workbook. Please use XL.LoadBook to load a file. | $ref |
sheetIndex | The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. | 0 |
First row | The first row to process. First row has index 0. | 3 |
Last row | The last row to process. First row has index 0. | 6 |
First column | The first column to process. First column has index 0. | 2 |
Last column | The last column to process. First column has index 0. | 4 |
Row Delimiter | Optional The row delimiter for the result. Default is new line character. |
"¶" |
Column Delimiter | Optional The column delimiter for the result. Default is tab character. |
char(9) |
Result
Returns list of values or error.
Description
Reads all the comments from cells in an area.If one cell can’t be read or has no comment, the value in the result will be empty.
See also
- XL.Book.SheetCount
- XL.LoadBook
- XL.Sheet.CellReadComment
- XL.Sheet.CellReadFormula
- XL.Sheet.CellReadFormulas
- XL.Sheet.CellReadNumber
- XL.Sheet.CellReadNumbers
- XL.Sheet.CellReadText
- XL.Sheet.CellReadTexts
- XL.Sheet.CellWriteComment
- XL.Sheet.CellWriteComments
- XL.Sheet.RemoveComments
Blog Entries
Created 15th January 2018, last changed 15th January 2018
XL.Sheet.CellReadComment - XL.Sheet.CellReadDate
Feedback: Report problem or ask question.
Links
MBS FileMaker Plugins