Export (0) Print
Expand All

TableBinding object (JavaScript API for Office v1.1)

JavaScript API for Office v1.1

Represents a binding in two dimensions of rows and columns, optionally with headers.

Last modified: June 12, 2014

Introduced in Office.js version

1.0

Updated in Office.js version

1.1

TableBinding

Properties

Name

Description

Updates for Office.js v1.1

columnCount

Gets the number of columns in the specified TableBinding object.

Added support for table binding in content apps for Access.

hasHeaders

If the specified TableBinding has headers, returns true; otherwise false.

Added support for table binding in content apps for Access.

rowCount

The number of rows in the specified TableBinding object.

For performance reasons, always returns -1 in content apps for Access.

Methods

Name

Description

Updates for Office.js v1.1

addColumnsAsync

Adds columns and values to a table.

addRowsAsync

Adds rows and values to a table.

Added support for table binding in content apps for Access.

clearFormatsAsync

Clears formatting on the bound table.

New in Office.js v1.1 for apps for Excel.

deleteAllDataValuesAsync

Deletes all non-header rows and their values in the table, shifting appropriately for the host application.

Added support for table binding in content apps for Access.

setDataAsync

Writes data to the bound section of the document represented by the specified binding object.

  • Added support for table binding in content apps for Access.

  • Added support for setting formatting when writing data to bound tables in apps for Excel.

setFormatsAsync

Sets cell and table formatting on specified items and data in the bound table.

Can set table formatting in apps for Excel.

setTableOptionsAsync

Updates table formatting options on the bound table.

Can set table formatting in apps for Excel.

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

After you establish a table binding in Excel, each new row a user adds to the table is automatically included in the binding (rowCount will increase).

App types

Content apps, Task pane apps

Supported clients

Access app for SharePoint, Excel 2013, Excel Online, Excel 2013 SP1, Excel 2013 RT, Word 2013, Word 2013 SP1, Word 2013 RT

Library

Office.js

Namespace

Office

Show:
© 2014 Microsoft