Monkeybread Software - MBS FileMaker Plugin: XL.Sheet.CellReadComments

Topics All MacOS (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Guides Examples
New in version: 9.0 9.1 9.2 9.3 9.4 9.5 10.0 10.1 10.2 10.3 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)

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.

Blog Entries

MBS FileMaker Plugin, version 8.0pr8

Release notes

Version 8.0
- Added XL.Sheet.CellReadBooleans, XL.Sheet.CellReadComments, XL.Sheet.CellReadDates, XL.Sheet.CellReadFormulas, XL.Sheet.CellReadNumbers, XL.Sheet.CellReadTexts, XL.Sheet.CellWriteBlanks, XL.Sheet.CellWriteBooleans, XL.Sheet.CellWriteComments, XL.Sheet.CellWriteDates, XL.Sheet.CellWriteFormulas, XL.Sheet.CellWriteNumbers, XL.Sheet.CellWriteTexts, XL.Sheet.GetCellErrors, XL.Sheet.GetCellFormats, XL.Sheet.RemoveComments and XL.Sheet.SetCellFormats.

Created 15th January 2018, last changed 15th January 2018

XL.Sheet.CellReadComment - XL.Sheet.CellReadDate