Requirement sets are named groups of API members. Office Add-ins use requirement sets specified in the manifest or use a runtime check to determine whether an Office application supports APIs that an add-in needs. For more information, see Office versions and requirement sets.
Tip
Looking for the application-specific API requirement sets? See the following API requirement sets.
Common API requirement sets
The following sections list the Common API requirement sets, the methods in each set, and the Office client applications that support that requirement set. All of these API requirement sets are version 1.1, unless otherwise specified.
ActiveView
Minimum Office application support |
Methods in set |
- PowerPoint on the web
- PowerPoint on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- PowerPoint on Mac
- PowerPoint on iPad
|
- Document.getActiveViewAsync
|
AddInCommands
See Add-in command requirement sets.
BindingEvents
Minimum Office application support |
Methods in set |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
- Binding.addHandlerAsync
- Binding.removeHandlerAsync
|
CompressedFile
Minimum Office application support |
Methods in set |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- PowerPoint on the web
- PowerPoint on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- PowerPoint on Mac
- PowerPoint on iPad
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
Supports output to Office Open XML (OOXML) format as a byte array (Office.FileType.Compressed) when using the Document.getFileAsync method. |
CustomXmlParts
Minimum Office application support |
Methods in set |
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
- CustomXmlNode.getNodesAsync
- CustomXmlNode.getNodeValueAsync
- CustomXmlNode.getTextAsync
- CustomXmlNode.getXmlAsync
- CustomXmlNode.setNodeValueAsync
- CustomXmlNode.setTextAsync
- CustomXmlNode.setXmlAsync
- CustomXmlPart.addHandlerAsync
- CustomXmlPart.deleteAsync
- CustomXmlPart.getNodesAsync
- CustomXmlPart.getXmlAsync
- CustomXmlPart.removeHandlerAsync
- CustomXmlParts.addAsync
- CustomXmlParts.getByIdAsync
- CustomXmlParts.getByNamespaceAsync
- CustomXmlPrefixMappings.addNamespaceAsync
- CustomXmlPrefixMappings.getNamespaceAsync
- CustomXmlPrefixMappings.getPrefixAsync
|
DevicePermissionService
DialogApi
Minimum Office application support |
Methods in set |
See Dialog API requirement sets. |
- UI.messageParent
- UI.displayDialogAsync
- UI.closeContainer
- UI.Dialog
|
DialogOrigin
DocumentEvents
Minimum Office application support |
Methods in set |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
- OneNote on the web
- PowerPoint on the web
- PowerPoint on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- PowerPoint on Mac
- PowerPoint on iPad
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
- Document.addHandlerAsync
- Document.removeHandlerAsync
|
File
Minimum Office application support |
Methods in set |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
- PowerPoint on the web
- PowerPoint on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- PowerPoint on Mac
- PowerPoint on iPad
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
- Document.getFileAsync
- File.closeAsync
- File.getSliceAsync
|
HtmlCoercion
Minimum Office application support |
Methods in set |
- OneNote on the web
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
Supports coercion to HTML (Office.CoercionType.Html) when reading and writing data using the Document.getSelectedDataAsync, Document.setSelectedDataAsync, Binding.getDataAsync, or Binding.setDataAsync methods. |
IdentityAPI
ImageCoercion
KeyboardShortcuts
Minimum Office application support |
Methods in set |
See Keyboard Shortcuts requirement sets. |
- Office.actions.areShortcutsInUse
- Office.actions.getShortcuts
- Office.actions.replaceShortcuts
|
Mailbox
MatrixBindings
Minimum Office application support |
Methods in set |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
- Bindings.addFromNamedItemAsync
- Bindings.addFromSelectionAsync
- Bindings.getAllAsync
- Bindings.getByIdAsync
- Bindings.releaseByIdAsync
- Binding.getDataAsync
- Binding.setDataAsync
|
MatrixCoercion
Minimum Office application support |
Methods in set |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
Supports coercion to the "matrix" (array of arrays) data structure (Office.CoercionType.Matrix) when reading and writing data using the Document.getSelectedDataAsync, Document.setSelectedDataAsync, Binding.getDataAsync, or Binding.setDataAsync methods. |
NestedAppAuth
OoxmlCoercion
Minimum Office application support |
Methods in set |
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
Supports coercion to Open Office XML (OOXML) format (Office.CoercionType.Ooxml) when reading and writing data using the Document.getSelectedDataAsync, Document.setSelectedDataAsync, Binding.getDataAsync, or Binding.setDataAsync methods. |
OpenBrowserWindowApi
PdfFile
Minimum Office application support |
Methods in set |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- PowerPoint on the web
- PowerPoint on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- PowerPoint on Mac
- PowerPoint on iPad
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
Supports output to PDF format (Office.FileType.Pdf) when using the Document.getFileAsync method. |
RibbonApi
Selection
Minimum Office application support |
Methods in set |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
- PowerPoint on the web
- PowerPoint on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- PowerPoint on Mac
- PowerPoint on iPad
- Project on Windows
- volume-licensed perpetual Office 2016
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
- Document.getSelectedDataAsync
- Document.setSelectedDataAsync
|
Settings
Minimum Office application support |
Methods in set |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
- OneNote on the web
- PowerPoint on the web
- PowerPoint on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- PowerPoint on Mac
- PowerPoint on iPad
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
- Settings.get
- Settings.remove
- Settings.saveAsync
- Settings.set
|
SharedRuntime
Minimum Office application support |
Methods in set |
See Shared runtime requirement sets. |
- Office.addin.getStartupBehavior
- Office.addin.hide
- Office.addin.onVisibilityModeChanged
- Office.addin.setStartupBehavior
- Office.addin.showAsTaskpane
- Office.BeforeDocumentCloseNotification.disable
- Office.BeforeDocumentCloseNotification.enable
- Office.BeforeDocumentCloseNotification.onCloseActionCancelled
|
TableBindings
Minimum Office application support |
Methods in set |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
- Bindings.addFromNamedItemAsync
- Bindings.addFromSelectionAsync
- Bindings.getAllAsync
- Bindings.getByIdAsync
- Bindings.releaseByIdAsync
- Binding.addColumnsAsync
- Binding.addRowsAsync
- Binding.deleteAllDataValuesAsync
- Binding.getDataAsync
- Binding.setDataAsync
|
TableCoercion
Minimum Office application support |
Methods in set |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
Supports coercion to the "table" data structure (Office.CoercionType.Table) when reading and writing data using the Document.getSelectedDataAsync, Document.setSelectedDataAsync, Binding.getDataAsync, or Binding.setDataAsync methods. |
TextBindings
Minimum Office application support |
Methods in set |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
- Bindings.addFromNamedItemAsync
- Bindings.addFromSelectionAsync
- Bindings.getAllAsync
- Bindings.getByIdAsync
- Bindings.releaseByIdAsync
- Binding.getDataAsync
- Binding.setDataAsync
|
TextCoercion
Minimum Office application support |
Methods in set |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on iPad
- OneNote on the web
- PowerPoint on the web
- PowerPoint on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- PowerPoint on Mac
- PowerPoint on iPad
- Project on Windows
- volume-licensed perpetual Office 2016
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
Supports coercion to text format (Office.CoercionType.Text) when reading and writing data using the Document.getSelectedDataAsync, Document.setSelectedDataAsync, Binding.getDataAsync, or Binding.setDataAsync methods. |
TextFile
Minimum Office application support |
Methods in set |
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
Supports output to text format (Office.FileType.Text) when using the Document.getFileAsync method. |
Methods that aren't part of a requirement set
The following methods in the Office JavaScript API aren't part of a requirement set. If your add-in requires any of these methods, use the <Methods> and <Method> elements in the add-in's manifest to declare that they are required, or perform the runtime check using an if
statement. For more information, see Specify Office applications and API requirements.
Method name |
Minimum Office application support |
Bindings.addFromPromptAsync |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
|
Document.getFilePropertiesAsync |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
- PowerPoint on the web
- PowerPoint on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- PowerPoint on Mac
- PowerPoint on iPad
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
Document.getProjectFieldAsync |
- Project Standard 2016
- Project Professional 2016
|
Document.getResourceFieldAsync |
- Project Standard 2016
- Project Professional 2016
|
Document.getSelectedResourceAsync |
- Project Standard 2016
- Project Professional 2016
|
Document.getSelectedTaskAsync |
- Project Standard 2016
- Project Professional 2016
|
Document.getSelectedViewAsync |
- Project Standard 2016
- Project Professional 2016
|
Document.getTaskAsync |
- Project Standard 2016
- Project Professional 2016
|
Document.getTaskFieldAsync |
- Project Standard 2016
- Project Professional 2016
|
Document.goToByIdAsync |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
- PowerPoint on the web
- PowerPoint on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- PowerPoint on Mac
- PowerPoint on iPad
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on Mac
- Word on iPad
|
Settings.addHandlerAsync |
|
Settings.refreshAsync |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- PowerPoint on the web
- PowerPoint on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Word on the web
- Word on Windows
- Microsoft 365 subscription
- perpetual Office 2016
|
Settings.removeHandlerAsync |
|
TableBinding.clearFormatsAsync |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
|
TableBinding.setFormatsAsync |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
|
TableBinding.setTableOptionsAsync |
- Excel on the web
- Excel on Windows
- Microsoft 365 subscription
- perpetual Office 2016
- Excel on Mac
- Excel on iPad
|
See also