--- sourceDocument: Yokohama Data and Automation sourceDocumentLink: https://www.servicenow.com/docs/r/yokohama/integrate-applications Release : - yokohama ft:locale : - en-US ft:publication_title : - Yokohama Data and Automation ft:clusterId : - crint bundleId : - crint workflow : - Creator --- # Microsoft 365 Excel Spoke # Microsoft 365 Excel Spoke {#ariaid-title1} * Release version: Yokohama * * Updated January 30, 2025 * * ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read Summarize ![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete. ## Summary of Microsoft 365 Excel Spoke The Microsoft 365 Excel Spoke enables ServiceNow customers to manage Microsoft Office 365 Excel workbooks stored in Microsoft OneDrive directly from their ServiceNow instance. This integration allows automation of Excel workbook tasks triggered by events within ServiceNow, streamlining workflows involving Excel data management. Show full answer Show less This spoke requires an Integration Hub subscription and depends on several ServiceNow plugins for full functionality. It is designed for Microsoft Office 365 Excel v1.0 but may support later versions. ## Key Features * **Cell and Range Management:** Retrieve and update properties of individual cells or ranges of cells. * **Table Management:** Add rows, create tables, retrieve and look up details of tables, columns, and rows within Excel worksheets. * **Workbook Management:** List all workbooks in a specified folder. * **Worksheet Management:** Add worksheets, retrieve used cells, get worksheet details, list worksheets, and update worksheets within a workbook. * **Connection and Credential Management:** Uses Integration Hub aliases for managing OAuth credentials and connection information efficiently across multiple environments, minimizing the need for repetitive configuration updates. ## Practical Use and Requirements * An Azure Portal account with a registered application providing a Client ID and Client Secret is necessary to authenticate and connect the spoke. * Licenses may be required for some dependent plugins outside the spoke implementation. * Input formats for actions like Add Row and Update Cells require precise value mappings corresponding to table columns and rows, including formulas and number formats. * By leveraging this spoke, ServiceNow customers can automate Excel data operations such as updating cell values, managing tables, and organizing worksheets without leaving the ServiceNow platform. Manage Microsoft Office 365 Excel workbooks stored in Microsoft OneDrive from your ServiceNow instance. ## Request apps on the Store {#office-365-spoke__section_sz5_jv3_z3b} Visit the [ServiceNow Store](https://store.servicenow.com/sn_appstore_store.do#!/store/home) website to view all the available apps and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the [ServiceNow Store version history release notes](https://www.servicenow.com/docs/r/store-release-notes/sn-store-release-notes.html).{#office-365-spoke__inline-send-to-store} ## Integration Hub subscription {#office-365-spoke__section_xt3_wqw_xmb} This spoke requires an Integration Hub subscription. For more information, see [Legal schedules - IntegrationHub overview](https://www.servicenow.com/content/dam/servicenow-assets/public/en-us/doc-type/legal/snc-addendum-integrationhub.pdf). ## Spoke version {#office-365-spoke__section_q23_svw_bsb} Microsoft 365 Excel spoke v1.0.4 is the latest version.{#office-365-spoke__ms365excel} ## Supported versions {#office-365-spoke__section_yt3_wqw_xmb} This spoke was built for Microsoft Office 365 Excel v1.0, but may be compatible with later versions. ## Spoke requirements {#office-365-spoke__section_b53_wqw_xmb} * Microsoft Azure Portal account * Client ID and Client Secret of the application registered in Azure Portal {#office-365-spoke__ul_c53_wqw_xmb} ## Spoke dependencies {#office-365-spoke__section_d53_wqw_xmb} If you're having trouble installing the app, ensure that these dependent plugins are installed: * ServiceNow IntegrationHub Action Template - Data Stream (com.glide.hub.action_type.datastream) * ServiceNow Flow Designer - Dynamic Inputs (com.glide.hub.dynamic_inputs) * ServiceNow IntegrationHub Action Step - REST (com.glide.hub.action_step.rest) * ServiceNow IntegrationHub Runtime (com.glide.hub.integration.runtime) * Complex Object (com.glide.cobject) {#office-365-spoke__ul_e53_wqw_xmb} Note: Some of these plugins are licensable features and require appropriate licenses, if used outside the spoke implementation. ## Spoke actions {#office-365-spoke__section_j53_wqw_xmb} The Microsoft 365 Excel Spoke provides actions to automate tasks when events occurs in your ServiceNow instance. Available actions include: {#office-365-spoke__table_t2x_1qb_xmb__entry__3} | Category | Action | Description | |-|-|-| | Cell and Range Management | Get Cell Details | Retrieves the properties of the specified cell. | | Cell and Range Management | Get Cells | Retrieves the properties of the selected range of cells. | | Cell and Range Management | Update Cells | Updates the properties of the selected range of cells. | | Table Management | Add Rows | Adds one or more rows to the given table. | | Table Management | Create Table | Adds a table to the worksheet. | | Table Management | Get Table Cells | Retrieves the properties of the selected range of table cells. | | Table Management | Get Table Details | Retrieves the properties of the specified table. | | Table Management | Look up Table Columns | Lists the details of the specified range columns from the selected table. | | Table Management | Look up Table Rows | Lists the details of the specified range of rows from the selected table. | | Workbook Management | Look up Workbooks | Lists all the workbooks in the specified folder. | | Worksheet Management | Add Worksheet | Adds a worksheet to a workbook. | | Worksheet Management | Get Used Cells | Retrieves the properties of the specified range of cells in the worksheet. | | Worksheet Management | Get Worksheet Details | Retrieves the properties of the worksheet. | | Worksheet Management | Look up Worksheets | Lists all the worksheets in the workbook. | | Worksheet Management | Update Worksheet | Updates a worksheet of a workbook. | [ ] {#office-365-spoke__table_t2x_1qb_xmb} Note: You must specify the input values for Update Cells and Add Row actions as shown in the following examples. Add Row action: The action input, Value 1 corresponds to the first row in your table. The values Hello and 100 correspond to the values of the first and second column respectively. You must provide values in the same format for the action inputs: Formulas, Formulas R1C1, Formulas Local, and Number Format. For more information, see [Add Row](https://docs.microsoft.com/en-us/graph/api/table-post-rows?view=graph-rest-1.0&tabs=http). Update Cells action: The action input, Value 1 corresponds to the first row in your range. The values Hello and 100 correspond to the values of the first and second column respectively. You must provide values in the same format for the action inputs: Formulas, Formulas R1C1, Formulas Local, and Number Format. For more information, see [Update Rage](https://docs.microsoft.com/en-us/graph/api/range-update?view=graph-rest-1.0&tabs=http). ## Connection and credential alias requirements {#office-365-spoke__section_q53_wqw_xmb} Integration Hub uses aliases to manage connection and credential information, and OAuth credentials. Using an alias eliminates the need to configure multiple credentials and connection information profiles when using multiple environments. If the connection or credential information changes, you don't need to update any actions that use the connection. For information about setting up the spoke, see [Set up the Microsoft 365 Excel spoke](https://www.servicenow.com/docs/r5hiGcGa7g4OOC8byUAtMQ#setup-office-365-excel "Integrate the ServiceNow instance and Microsoft 365 Excel by using the OAuth credentials to authenticate ServiceNow requests.").