Microsoft 365 Excel Spoke
Summarize
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 facilitates automation of Excel workbook tasks, improving efficiency and streamlining workflow management within the ServiceNow platform.
Show less
This spoke requires an Integration Hub subscription and uses OAuth credentials managed through connection and credential aliases to simplify configuration and maintenance across multiple environments.
Key Features
- Cell and Range Management: Retrieve and update properties of individual cells or ranges of cells in Excel worksheets.
- Table Management: Add rows, create tables, and retrieve detailed information about tables, rows, and columns within Excel worksheets.
- Workbook Management: Lookup and list all workbooks within a specified OneDrive folder.
- Worksheet Management: Add new worksheets, retrieve details and used cells, list worksheets, and update worksheet properties.
- Action Inputs: Actions like Add Row and Update Cells require structured input values corresponding to rows and columns, supporting formula and number format configurations.
Requirements and Dependencies
- A Microsoft Azure Portal account with a registered application providing Client ID and Client Secret is required for authentication.
- Dependent ServiceNow plugins must be installed, including IntegrationHub Action Template - Data Stream, Flow Designer - Dynamic Inputs, IntegrationHub Action Step - REST, IntegrationHub Runtime, and Complex Object plugins. Some may require separate licenses.
- The spoke is compatible with Microsoft Office 365 Excel version 1.0 and potentially later versions.
Practical Benefits for ServiceNow Customers
By integrating Excel workbook management into ServiceNow workflows, customers can automate data updates, retrieve detailed spreadsheet information, and maintain synchronized Excel documents without leaving the ServiceNow environment. This reduces manual effort and ensures data consistency between ServiceNow and Microsoft Excel stored on OneDrive.
Manage Microsoft Office 365 Excel workbooks stored in Microsoft OneDrive from your ServiceNow instance.
Request apps on the Store
Visit the ServiceNow Store 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.
Integration Hub subscription
This spoke requires an Integration Hub subscription. For more information, see Legal schedules - IntegrationHub overview.
Spoke version
Microsoft 365 Excel spoke v1.0.4 is the latest version.
Supported versions
This spoke was built for Microsoft Office 365 Excel v1.0, but may be compatible with later versions.
Spoke requirements
- Microsoft Azure Portal account
- Client ID and Client Secret of the application registered in Azure Portal
Spoke dependencies
- 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)
Spoke actions
The Microsoft 365 Excel Spoke provides actions to automate tasks when events occurs in your ServiceNow instance. Available actions include:
| Category | Action | Description |
|---|---|---|
| Cell and Range Management | Get Cell Details | Retrieves the properties of the specified cell. |
| Get Cells | Retrieves the properties of the selected range of cells. | |
| Update Cells | Updates the properties of the selected range of cells. | |
| Table Management | Add Rows | Adds one or more rows to the given table. |
| Create Table | Adds a table to the worksheet. | |
| Get Table Cells | Retrieves the properties of the selected range of table cells. | |
| Get Table Details | Retrieves the properties of the specified table. | |
| Look up Table Columns | Lists the details of the specified range columns from the selected table. | |
| 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. |
| Get Used Cells | Retrieves the properties of the specified range of cells in the worksheet. | |
| Get Worksheet Details | Retrieves the properties of the worksheet. | |
| Look up Worksheets | Lists all the worksheets in the workbook. | |
| Update Worksheet | Updates a worksheet of a workbook. |
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.
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.
Connection and credential alias requirements
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.