Creates a buffer containing a spreadsheet made from a 2D JavaScript array,

Creates a buffer containing multiple spreadsheets made from a 3D JavaScript array.

Clear range values such as format, fill, and border.

Creates a Column object inside a worksheet table.

name-value

Creates a row object inside a worksheet table.

Creates a table object inside a worksheet.

Creates a worksheet object inside a workbook.

Deletes the cells associated with the range.

Deletes a column object from a worksheet table.

Retrieve the properties and relationships of range object.

Retrieves a column object from a worksheet table.

Retrieves a table object from a worksheet.

Retrieves a worksheet object from a workbook.

Retrieve a list of columns from a worksheet table.

Retrieve a list of rows from a worksheet table.

Retrieve a list of tables from a worksheet.

Return a collection of Workbooks from either a OneDrive or SharePoint site.

Parse an xlsx file from a URL endpoint, outputs an array of worksheets

Parse an xlsx file from a Buffer, outputs an array of worksheets

Send raw HTTP request to Microsoft Excel API.

Updates a column object from a worksheet table.

Updates a worksheet object from a workbook.

Once you have an instance of Microsoft SharePoint or OneDrive licensed to your account, you will need to create and configure a new "App Registration" within your [Azure Active Directory tenant](https://portal.azure.com/#home).
When creating the application you will be prompted to select the 'Supported account types'. Under this section, be sure to select 'Accounts in any organizational directory (Any Azure AD directory - Multitenant)'.

You will need to go to "Platforms" and add the "Web" platform. In that section you should add Prismatic's OAuth 2.0 callback URL - `https://oauth2.prismatic.io/callback` - as a **Redirect URI** for US based integrations.
  - For integrations outside the US refer to this [guide](https://prismatic.io/docs/connections/#creating-an-oauth-20-app-in-a-third-party-service) to find your region's Callback URL.

Next, go to "Certificates & Secrets" for the app and add a new **Client Secret**. Note this value as you will need to supply it to the connection within Prismatic.

You will also need the **Application (client) ID** from the "Overview" page.

The last step of configuring the "App Registration" is assigning "App Permissions". Click "Add Permission", click on the square labeled ", and then "Delegated permissions". You should select all permissions that are required for your desired integration.

Now, configure the OAuth 2.0 connection in Prismatic.
Add an Microsoft Excel OAuth 2.0 connection config variable:

- Use the **Application (client) ID** value for the **Client ID** field.
- Use the **Client Secret** for the same named field.
- If you didn't select Multitenant when creating the Azure application, you will need to replace the **Authorize URL** and **Token URL** with ones specific to your tenant.

Save your integration and you should be able to authenticate a user through Microsoft Excel with OAuth 2.0.


Parse and build .xlsx files (spreadsheets)

[Microsoft Excel](https://www.microsoft.com/en-us/microsoft-365/excel) is a spreadsheet application developed by Microsoft. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
This component allows you to read and build .xlsx files. (spreadsheets)


Action Name	Action Description
Clear Cell Range	Clear range values such as format, fill, and border.
Delete Cell Range	Deletes the cells associated with the range.
Get Cell Range	Retrieve the properties and relationships of range object.
Get Cell	Retrieves a cell from a worksheet.
Update Cell Range	Update the properties of range object.
List Columns	Retrieve a list of columns from a worksheet table.
Get Column	Retrieves a column object from a worksheet table.
Update Column	Updates a column object from a worksheet table.
Create Column	Creates a Column object inside a worksheet table.
Delete Column	Deletes a column object from a worksheet table.
Create Multiple Rows	Adds rows to the end of a table.
Create Row	Creates a row object inside a worksheet table.
List Rows	Retrieve a list of rows from a worksheet table.
List Tables	Retrieve a list of tables from a worksheet.
Get Table	Retrieves a table object from a worksheet.
Update Table	Updates a table object from a worksheet.
Create Table	Creates a table object inside a worksheet.
Delete Table	Deletes a table object from a worksheet.
List Workbooks	Return a collection of Workbooks from either a OneDrive or SharePoint site.
List Worksheets	Retrieve a list of worksheet objects.
Get Worksheet	Retrieves a worksheet object from a workbook.
Update Worksheet	Updates a worksheet object from a workbook.
Create Worksheet	Creates a worksheet object inside a workbook.
Delete Worksheet	Deletes a worksheet from a workbook.
Build Spreadsheet	Creates a buffer containing a spreadsheet made from a 2D JavaScript array,
Build Spreadsheet with Multiple Sheets	Creates a buffer containing multiple spreadsheets made from a 3D JavaScript array.
Read From URL	Parse an xlsx file from a URL endpoint, outputs an array of worksheets
Read From Buffer	Parse an xlsx file from a Buffer, outputs an array of worksheets
Raw Request	Send raw HTTP request to Microsoft Excel API.

Microsoft Excel Connector

Integrate with customers’ other SaaS apps, fast

About the Microsoft Excel Connector

Actions

Triggers

Ready to get started?