Microsoft Excel 365 × AmbactiBring Microsoft Excel 365 into
the flow of work.
A little less busywork with Microsoft Excel 365.
Table9 capabilities+
- Get columnsRead
Retrieve a list of table columns
- Get rowsRead
Retrieve a list of table rows
- Look up a columnRead
Looks for a specific column value and then returns the matching row
- Lookup a columnRead
Look for rows that match a given value in a column
- Add a rowWrite
Adds rows to the end of the table
- Append rows to tableWrite
Add rows to the end of the table
- Create a tableWrite
Add a table based on range
- Delete a tableWrite
- Convert to range
Convert a table to a range
Workbook5 capabilities+
- Get many workbooksRead
Get data of many workbooks
- Get workbooksRead
- Add a worksheet to a workbookWrite
Adds a new worksheet to the workbook
- Add a sheet to a workbookWrite
Add a new sheet to the workbook
- Delete workbookWrite
Sheet7 capabilities+
- Get sheetsRead
Get a list of sheets
- Get rows from sheetRead
Retrieve a list of sheet rows
- Append or update a sheetWrite
Append a new row or update the current one if it already exists (upsert)
- Append data to sheetWrite
- Clear sheetWrite
- Delete sheetWrite
- Update sheetWrite
Update rows of a sheet or sheet range
Worksheet2 capabilities+
- Get a worksheetRead
Get worksheet content
- Get many worksheetsRead
Frequently asked
questions.
What could an Ambacti integration do with Microsoft Excel 365?
The documented operations include Table: Get columns; Table: Get rows; Table: Look up a column; Table: Lookup a column.
Could I keep a workflow read-only?
For a read-only workflow, limit account permissions to reading data and exclude actions that create, update, or delete records.
Will every action run automatically?
Choose which steps could run on their own and which should pause for review. Changes should follow the permissions and approval rules you set.
Do I need to review actions in Microsoft Excel 365?
Decide which work could run on its own and which steps need your review.