getCellCollection

getCellCollection(String formula, boolean skipHiddenCells) function

Gets the set of cells.

Parameters

NameTypeDescription
formulaStringExcel formula like “Sheet1!$A$2:$A$5”.
skipHiddenCellsbooleanIf true then function returns collection without hidden cells.

Result

ChartCellCollection