Export (0) Print
Expand All

CoercionType enumeration (JavaScript API for Office v1.0)

apps for Office

Specifies how to coerce data returned or set by the invoked method.

Last modified: February 26, 2015

Office.CoercionType

Values

Enumeration

Value

Description

Office.CoercionType.Html

"html"

Return or set data as HTML.

Note Note

This is only applicable for data in Word 2013, Word 2013 RT.

Office.CoercionType.Matrix

"matrix"

Return or set data as tabular data with no headers.

Data is returned or set as an array of arrays containing one-dimensional runs of characters. For example, three rows of string values in two columns would be: [["R1C1", "R1C2"], ["R2C1", "R2C2"], ["R3C1", "R3C2"]].

Note Note

This is only applicable for data in Excel 2013, Excel 2013 RTWord 2013, Word 2013 RT.

Office.CoercionType.Ooxml

"ooxml"

Return or set data as Office Open XML.

Note Note

This is only applicable for data in Word 2013, Word 2013 RT.

Office.CoercionType.Table

"table"

Return or set data as tabular data with optional headers.

Data is returned or set as an array of arrays with optional headers.

Note Note

This is only applicable for data in Excel 2013, Excel 2013 RTWord 2013, Word 2013 RT.

Office.CoercionType.Text

"text"

Return or set data as text (string).

Data is returned or set as a one-dimensional run of characters.

Supported clients

Excel 2013, Excel 2013 RT, Excel Online, Word 2013, Word 2013 RT.

PowerPoint 2013, PowerPoint 2013 RT and Project Professional 2013 support only Office.CoercionType.Text.

Outlook for Mac.

Library

Office.js

Namespace

Office

Show:
© 2015 Microsoft