Microsoft Excel Connector

Quickly build integrations connecting your B2B SaaS to Microsoft Excel.

Get a demo Start a free trial

About the Microsoft Excel Connector

Parse and build .xlsx files (spreadsheets)

Go to Docs

Actions

Actions are tasks that you add to your workflow. One action might update records in a third-party API, while another action might fetch a list of records.

Jump to actions

Triggers

Triggers cause workflows to run. Some triggers run on a schedule. Others are invoked by a webhook request, or poll an API for new data. If a connector does not have a built-in trigger, you can use a generic scheduled or webhook trigger.

Jump to triggers

FAQs

Learn more about this connector and related integration functionality.

Jump to FAQs

Actions

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 a range object.
Get Cell	Retrieves a cell from a worksheet.
Update Cell Range	Update the properties of a 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	Returns 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	Parses an xlsx file from a URL endpoint and outputs an array of worksheets.
Read from Buffer	Parses an xlsx file from a buffer and outputs an array of worksheets.
Raw Request	Send raw HTTP request to Microsoft Excel API.

Triggers

Trigger Name	Trigger Description

API Connectors

Integrate with customers' other SaaS apps, fast

Prismatic’s API connectors make it easy to integrate other SaaS apps – without reinventing the wheel. Triggers, actions, and auth are fully handled. And they work with all of Prismatic’s options for building integrations:

Empower non-devs with a low-code designer
Give devs freedom to build completely in code
Let customers create their own workflows

Low-code Code-native