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.
Learn object model concepts
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.
- Conditional formatting
- Custom functions
- Data validation
- Data types
- Ranges and Cells
- RangeAreas (Multiple ranges)
- Workbooks and Application-level APIs
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.