Prismatic leads in satisfaction for embedded iPaaS!

Prismatic
Connectors
Ms Excel

Microsoft Excel Connector

Quickly build integrations connecting your B2B SaaS to Microsoft Excel.

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 build their own automations
Built-In and custom connectors

About the Microsoft Excel Connector

Parse and build .xlsx files (spreadsheets)
Documentation

Actions

Action NameAction Description
Clear Cell RangeClear range values such as format, fill, and border.
Delete Cell RangeDeletes the cells associated with the range.
Get Cell RangeRetrieve the properties and relationships of range object.
Get CellRetrieves a cell from a worksheet.
Update Cell RangeUpdate the properties of range object.
List ColumnsRetrieve a list of colums from a worksheet table.
Get ColumnRetrieves a column object from a worksheet table.
Update ColumnUpdates a column object from a worksheet table.
Create ColumnCreates a Column object inside a worksheet table.
Delete ColumnDeletes a column object from a worksheet table.
Create Multiple RowsAdds rows to the end of a table.
Create RowCreates a row object inside a worksheet table.
List RowsRetrieve a list of rows from a worksheet table.
List TablesRetrieve a list of tables from a worksheet.
Get TableRetrieves a table object from a worksheet.
Update TableUpdates a table object from a worksheet.
Create TableCreates a table object inside a worksheet.
Delete TableDeletes a table object from a worksheet.
List WorkbooksReturn a collection of Workbooks from either a OneDrive or SharePoint site.
List WorksheetsRetrieve a list of worksheet objects.
Get WorksheetRetrieves a worksheet object from a workbook.
Update WorksheetUpdates a worksheet object from a workbook.
Create WorksheetCreates a worksheet object inside a workbook.
Delete WorksheetDeletes a worksheet from a workbook.
Build SpreadsheetCreates a buffer containing a spreadsheet made from a 2D JavaScript array,
Build Spreadsheet with Multiple SheetsCreates a buffer containing multiple spreadsheets made from a 3D JavaScript array.
Read From URLParse an xlsx file from a URL endpoint, outputs an array of worksheets
Read From BufferParse an xlsx file from a Buffer, outputs an array of worksheets
Raw RequestSend raw HTTP request to Microsoft Excel API.

Triggers

Trigger NameTrigger Description
Get a Demo

Ready to get started?

Book a demo to see how Prismatic can help you deliver integrations fast.