Excel JavaScript API overview
An Excel add-in interacts with objects in Excel by using the Office JavaScript API, which includes two JavaScript object models:
Excel JavaScript API: These are the application-specific APIs for Excel. Introduced with Office 2016, the Excel JavaScript API provides strongly-typed objects that you can use to access worksheets, ranges, tables, charts, and more.
Common 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.
This section of the documentation focuses on the Excel JavaScript API, which you'll use to develop the majority of functionality in add-ins that target Excel on the web or Excel 2016 or later. For information about the Common API, see Common JavaScript API object model.
Learn object model concepts
See Excel JavaScript object model in Office Add-ins for information about important object model concepts.
For hands-on experience using the Excel JavaScript API to access objects in Excel, complete the Excel add-in tutorial.
Learn API capabilities
Each major Excel API feature has an article or set of articles exploring what that feature can do and the relevant object model.
- Charts
- Comments
- Conditional formatting
- Custom functions
- Data validation
- Data types
- Events
- PivotTables
- Ranges and Cells
- RangeAreas (Multiple ranges)
- Shapes
- Tables
- Workbooks and Application-level APIs
- Worksheets
For detailed information about the Excel JavaScript API object model, see the Excel JavaScript API reference documentation.
Try out code samples in Script Lab
Use Script Lab to get started quickly with a collection of built-in samples that show how to complete tasks with the API. You can run the samples in Script Lab to instantly see the result in the task pane or worksheet, examine the samples to learn how the API works, and even use samples to prototype your own add-in.
See also
Office Add-ins
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기