A Range represents a group of contiguous cells.A Worksheet contains collections of those data objects that are present in the individual sheet, and gives access to cells through Range objects.A Workbook contains one or more Worksheets.
To understand the Excel APIs, you must understand how the components of a workbook are related to one another. The following image illustrates when you might use the Excel JavaScript API or the Common APIs. Document: The Document object provides the getFileAsync() method, which you can use to download the Excel file where the add-in is running.Additionally, it provides the requirements.isSetSupported() method, which you can use to check whether the specified requirement set is supported by the Excel application where the add-in is running. It consists of workbook configuration details such as contentLanguage and officeTheme and also provides information about the add-in's runtime environment such as host and platform. Context: The Context object represents the runtime environment of the add-in and provides access to key objects of the API.While you'll likely use the Excel JavaScript API to develop the majority of functionality in add-ins that target Excel 2016 or later, you'll also use objects in the Common API. Office.js APIs for ExcelĪn Excel add-in interacts with objects in Excel by using the Office JavaScript API, which includes two JavaScript object models:Įxcel JavaScript API: Introduced with Office 2016, the Excel JavaScript API provides strongly-typed objects that you can use to access worksheets, ranges, tables, charts, and more.Ĭommon APIs: Introduced with Office 2013, the Common API can be used to access features such as UI, dialogs, and client settings that are common across multiple types of Office applications.
See Using the application-specific API model to learn about the asynchronous nature of the Excel APIs and how they work with the workbook.
It introduces core concepts that are fundamental to using the API and provides guidance for performing specific tasks such as reading or writing to a large range, updating all cells in range, and more. This article describes how to use the Excel JavaScript API to build add-ins for Excel 2016 or later. Excel JavaScript object model in Office Add-ins
0 kommentar(er)
