CheckBoxCollection

CheckBoxCollection class

Represents a collection of CheckBox objects in a worksheet.

class CheckBoxCollection;

Example

const { Workbook } = require("aspose.cells.node");

var excel = new Workbook();
var index = excel.getWorksheets().get(0).getCheckBoxes().add(15, 15, 20, 100);
var checkBox = excel.getWorksheets().get(0).getCheckBoxes().get(index);
checkBox.setText("Check Box 1");

Methods

MethodDescription
get(number)Gets the CheckBox element at the specified index.
add(number, number, number, number)Adds a checkBox to the collection.
getCount()Gets the number of elements contained in.
isNull()Checks whether the implementation object is null.

get(number)

Gets the CheckBox element at the specified index.

get(index: number) : CheckBox;

Parameters:

ParameterTypeDescription
indexnumberThe zero based index of the element.

Returns

The element at the specified index.

add(number, number, number, number)

Adds a checkBox to the collection.

add(upperLeftRow: number, upperLeftColumn: number, height: number, width: number) : number;

Parameters:

ParameterTypeDescription
upperLeftRownumberUpper left row index.
upperLeftColumnnumberUpper left column index.
heightnumberHeight of checkBox, in unit of pixel.
widthnumberWidth of checkBox, in unit of pixel.

Returns

CheckBox object index.

getCount()

Gets the number of elements contained in.

getCount() : number;

isNull()

Checks whether the implementation object is null.

isNull() : boolean;