Office.MatrixBinding interface

Package:

office

Represents a binding in two dimensions of rows and columns.

Extends

Office.Binding

Remarks

The MatrixBinding object inherits the id property, type property, getDataAsync method, and setDataAsync method from the Binding object.

Properties

columnCount	Gets the number of columns in the matrix data structure, as an integer value.
rowCount	Gets the number of rows in the matrix data structure, as an integer value.

Property Details

columnCount

Gets the number of columns in the matrix data structure, as an integer value.

TypeScript

columnCount: number;

Property Value

number

Examples

TypeScript

function showBindingColumnCount() {
    Office.context.document.bindings.getByIdAsync("myBinding", function (asyncResult) {
        write("Column: " + asyncResult.value.columnCount);
    });
}
// Function that writes to a div with id='message' on the page.
function write(message){
    document.getElementById('message').innerText += message; 
}

rowCount

Gets the number of rows in the matrix data structure, as an integer value.

TypeScript

rowCount: number;

Property Value

number

Examples

TypeScript

function showBindingRowCount() {
    Office.context.document.bindings.getByIdAsync("myBinding", function (asyncResult) {
        write("Rows: " + asyncResult.value.rowCount);
    });
}
// Function that writes to a div with id='message' on the page.
function write(message){
    document.getElementById('message').innerText += message; 
}