Microsoft Excel is a powerful spreadsheet software by Microsoft used for data organization, analysis, visualization, and automation through formulas and macros. It supports a wide range of functions, from basic calculations to advanced data modeling.
Integrating Excel helps seamlessly manage, analyze and visualize structured data in real-time across systems or workflows.
Authentication
Before you begin, make sure you have the following information:
Connection Name: Select a descriptive name for your connection, like "MyAppExcelIntegration". This helps in easily identifying the connection within your application or integration settings.Authentication Type: Select the type of authentication for connecting to your Slack account.OAuth
OAuth with Client Credentials
OAuth Based Authentication
Select OAuth as the provide the appropriate scopes.
A pop-up screen opens, sign in to your Microsoft account.
Login into the Microsoft Azure Portal by clicking here.
In the search Bar, search for App Registration and then Click on new Registration.
Provide the Name and supported account types and register your app.
The Client ID refers to the Application(client) ID.
Click on “
Add a credential or scope” to generate the client secret.Copy and store these securely to prevent unauthorised access.
Permissions
Scope Code | Description |
| Have full access to all files user can access |
| Maintain access to data you have given it access to |
| Edit or delete items in all site collections |
| Sign in and read user profile |
| Create, read, update, and delete all teams and channels, including private channels and sensitive settings. |
Sensitive Permissions
Scope Code | Description |
| Read all users' full profiles |
Actions
Actions | Description |
| Add rows in batches in Microsoft Excel |
| Add table in Microsoft Excel |
| Add worksheet in Microsoft Excel |
| Delete a row in Microsoft Excel |
| Downloads the contents of a file in Microsoft Excel |
| Fetch permissions for files and folders in Microsoft Excel |
| Get file metadata in Microsoft Excel |
| Get OneDrive drive ID in Microsoft Excel |
| Get organizations in Microsoft Excel |
| Get rows from table in Microsoft Excel |
| Get teams of a user by user ID in Microsoft Excel |
| Get details of a user by user email in Microsoft Excel |
| List SharePoint sites in Microsoft Excel |
| List table objects in Microsoft Excel |
| List worksheet objects in Microsoft Excel |
| Search workbook items in Microsoft Excel |
| Update a row in Microsoft Excel |
