- Find workbooks and get their details
- Open and close workbook sessions
- List, get, add, update and delete worksheets
- Read, update and sort ranges
- List, create, update, sort and filter tables, and add, list and delete their rows and columns
- List and add named items
- List, add and update charts, and get chart images
- Find the drives of Microsoft 365 groups and SharePoint sites
- Send any other request to the Microsoft Graph API
Add a Connection to Microsoft Excel 365 in Engini
Prerequisites
- A Microsoft 365 account with access to the workbooks you want to use, in OneDrive or SharePoint.
Connecting Engini to Microsoft Excel 365
- Enter your Engini account at https://app.engini.io.
-
Navigate to the Connections page by clicking on Connections in the left sidebar or by clicking here.

-
Click on the “New Integration” option located at the top bar.

-
Choose the Microsoft Excel 365 option from the available applications.

-
Enter the following details in the “New Integration” form and press Save:
1. Connection Name - Enter a name that helps you identify this connection, for example
Excel - Finance team. 2. Sign in with Microsoft - Click Sign in with Microsoft and sign in with the Microsoft 365 account that has access to the workbooks you want to use. 3. Save - Click Save to create the connection.
Actions
Most actions start with the same three workbook fields: Drive ID, Workbook Item ID and an optional Session ID. Each action below explains them again, so you can read any action on its own.Add Chart
Adds a chart to a worksheet, based on the data in a range of cells.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
- Chart Type - The type of chart to create. Click the field to open the tooltip and choose a type, for example ColumnClustered for vertical bars, Line or Pie.
- Source Data - The range of cells the chart plots, in A1 notation and including the header cells you want as series names, for example
A1:C4. - Series By - How the data in the range is split into series. Click the field to open the tooltip and choose Columns to make each column a series, Rows to make each row a series, or Auto to let Excel decide.
Add Named Item
Adds a named item, such as a named range, to a workbook so you can refer to a range by name in formulas.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
- Name - The name to define. It must start with a letter and can’t contain spaces, for example
Sales_Totals. - Reference - The range the name refers to, written as a formula, for example
=Sheet1!$A$1:$C$5. - Comment - Optional. A free-text comment saved with the name, for example
Q3 sales totals.
Add Table Column
Adds a column to a table.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
- Name - The name of the new column, which becomes its header, for example
Status. - Values - The cell values of the new column, one row per entry. The first entry is the column header, followed by the cell values, for example
[["Status"],["Open"]]. - Insert At Index - Optional. The position of the new column in the table, counted from 0 for the first column. Leave it empty to add the column at the end of the table.
Add Table Row
Adds one or more rows to a table.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
- Values - The rows to add. Each row is a list of cell values in the order of the table’s columns, for example
[["Jan",49,37]]adds one row with three cells. Add several lists to add several rows. - Insert At Index - Optional. The position of the new row in the table, counted from 0 for the first row. Leave it empty to add the row at the end of the table.
Add Worksheet
Adds a new worksheet to a workbook.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
- Name - Optional. The name of the new worksheet, for example
Q3 Report. If left blank, Excel gives the worksheet a default name such as Sheet2.
Clear Table Filter
Clears the filter applied to a column of a table, so all of its rows show again.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
Close Workbook Session
Closes a workbook session that was opened with Create Workbook Session.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - The ID of the session to close, returned by the Create Workbook Session action. Map it from that step.
Create Table
Creates a table from a range of cells.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
- Range Address - The range the table covers, including the worksheet name, in A1 notation, for example
Sheet1!A1:D8. The table is added to the worksheet named in the address. - Has Headers - Whether the first row of the range holds the column headers. Click the empty field to open the tooltip and choose True if it does, or False to let Excel add default headers.
Create Workbook Session
Opens a workbook session. Use the returned session ID in the Session ID field of other actions, and close the session with Close Workbook Session.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Persist Changes - Whether the changes made in the session are saved to the workbook. The field shows
true, which saves them when the session ends. Enterfalseto discard the changes when the session ends.
Delete Table Column
Deletes a column from a table.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
Delete Table Row
Deletes a row from a table.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
0 for the first row.
Delete Worksheet
Deletes a worksheet from a workbook.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
Filter Table Column
Applies a filter to a column of a table, so only the rows that match the filter show.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
- Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.
- Criteria - Required. The filter conditions to apply to the column. Criteria shows the Filter On field, and you click Add Criteria Field to add the others. Filter On is required and sets the type of filter:
customfilters by the conditions in Criterion 1 and Criterion 2, andvalueskeeps only the values listed in Values. Criterion 1 is the first condition, for example=2. Operator sets how Criterion 1 and Criterion 2 are combined,andoror. Criterion 2 is the second condition, for example=5. Values holds the values to keep when Filter On isvalues, for exampleOpen,Pending.
Get Chart Image
Retrieves an image of a chart, for example to attach it to an email or save it as a file.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Width - The width of the image, in pixels, for example
800. The field shows0, which uses the default size. - Height - The height of the image, in pixels, for example
600. The field shows0, which uses the default size. - Fitting Mode - How the chart is fitted into the image. Click the field to open the tooltip and choose
fitto scale the chart to fit inside the image,fitandcenterto scale it and center it, orfillto fill the whole image. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
Get Charts
Retrieves the charts in a worksheet.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
Get Group’s Drive Id
Retrieves the drives of a Microsoft 365 group, with each drive’s ID and name. Use the drive ID to work with a workbook stored in the group’s files.
- Group ID - The Microsoft 365 group whose drives you want. Click the empty field to open the tooltip and choose the group, or map the group ID returned by a previous Get Groups step.
Get Groups
Retrieves the Microsoft 365 groups in your organization. Use it to find the group whose drive holds your workbook.
- Filter - Optional. A filter that narrows down the groups, written as an OData filter expression, for example
groupTypes/any(c:c eq 'Unified')to return Microsoft 365 groups only. Leave it blank to return all groups. - Select - Optional. A comma-separated list of the group properties to return, for example
id,displayName. Leave it blank to return the default properties. - Top - Optional. The maximum number of groups to return per page, for example
50.
Get Named Items
Retrieves the named items defined in a workbook, such as named ranges, with each item’s name, value and scope.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
Get Range
Retrieves the values, formulas and formatting details of a range of cells in a worksheet.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
A1:C10.
Get Site’s Drives
Retrieves the drives (document libraries) of a SharePoint site, with each drive’s ID and name. Use the drive ID to work with a workbook stored on the site.
- Site ID - The SharePoint site whose drives you want. Click the empty field to open the tooltip and choose the site.
Get Table Columns
Retrieves the columns of a table, with each column’s ID and name.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
Get Table Rows
Retrieves the rows of a table.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
Get Tables
Retrieves all the tables in a workbook, with each table’s ID and name.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
Get Workbook
Retrieves the details of a workbook file, such as its ID, name, size and web link. Use it to find the Workbook Item ID that the other actions need.
- OneDrive Location - Where the workbook is stored. Click the empty field to open the tooltip and choose My Drive for your own OneDrive, Site Drive for a SharePoint site, or Group Drive for a Microsoft 365 group.
Get Workbooks
Retrieves the workbooks stored in a OneDrive or SharePoint location, for example to loop over every workbook in a folder.
- OneDrive Location - Where the workbooks are stored. Click the empty field to open the tooltip and choose My Drive for your own OneDrive, Site Drive for a SharePoint site, or Group Drive for a Microsoft 365 group.
Budget. For Site Drive, also enter the Site ID, and for Group Drive, the Group ID.
Get Worksheet
Retrieves the details of a worksheet, such as its ID, name, position and visibility.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
Get Worksheets
Retrieves all the worksheets of a workbook, with each worksheet’s ID, name, position and visibility.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
Sort Range
Sorts the used range of a worksheet (the area that contains data or formatting) by one or more columns.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
- Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.
- Sort Fields - Required. Click Add Sort Field once for each column you want to sort by. Each sort field has a Column Index and an Ascending field. In Column Index, enter the column number to sort by. The count starts at 0, so the first column is 0, the second column is 1 and the third column is 2. In Ascending, choose True to sort that column in ascending order (smallest to largest, A to Z) or False for descending order (largest to smallest, Z to A).
Sort Table
Sorts the rows of a table by one or more columns.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
- Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.
- Sort Fields - Required. Click Add Sort Field once for each column you want to sort by. Each sort field has a Column Index and an Ascending field. In Column Index, enter the column number to sort by. The count starts at 0, so the first column is 0, the second column is 1 and the third column is 2. In Ascending, choose True to sort that column in ascending order (smallest to largest, A to Z) or False for descending order (largest to smallest, Z to A).
Update Chart
Updates the name, size or position of a chart.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
- Name - The new name of the chart, for example
Sales by Month. - Height - The height of the chart, in points, for example
250. - Width - The width of the chart, in points, for example
400. - Left - The distance of the chart from the left edge of the worksheet, in points.
- Top - The distance of the chart from the top edge of the worksheet, in points.
Update Range
Writes values, formulas or number formats to a range of cells in a worksheet.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
- Values - The values to write, as rows. Each row is a list of values, one per cell, for example
[["A1","B1"]]. - Formulas - The formulas to write, as rows. Each row is a list of formulas, for example
[["=SUM(A1:A2)"]]. - Number Format - The number formats to apply, as rows. Each row is a list of formats, for example
[["General"]].
A1:B1; the rows you enter above must have the same size as the range.
Note: Fill in Values, Formulas and Number Format. Leaving one of them empty causes the action to fail.
Update Table
Updates the name, header row, total row or style of a table.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
- Name - The new name of the table, for example
SalesData. - Show Headers - Whether the table shows its header row. Click the empty field to open the tooltip and choose True or False.
- Show Totals - Whether the table shows its total row. Click the empty field to open the tooltip and choose True or False.
- Style - The table style, for example
TableStyleMedium4.
Update Worksheet
Updates the name, position or visibility of a worksheet.
- Drive ID - The drive that holds the workbook: your own OneDrive, a SharePoint site’s document library or a Microsoft 365 group’s drive. Click the empty field to open the tooltip and choose the drive, for example My Drive. To work with a site or group drive, map the drive ID returned by Get Site’s Drives or Get Group’s Drive Id in a previous step.
- Workbook Item ID - The ID of the Excel workbook file in that drive, for example
01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K. This is the file’s ID, not its name. Map it from the ID returned by Get Workbook or Get Workbooks in a previous step. - Session ID - Optional. The ID of a workbook session, returned by the Create Workbook Session action. Map it from that step if you want the action to run inside the session, or leave it blank to run without one.
- Name - The new name of the worksheet, for example
Q3 Report. - Position - The position of the worksheet among the workbook’s tabs, counted from 0 for the first tab, for example
0to make it the first tab. - Visibility - Whether the worksheet is shown. Click the field to open the tooltip and choose Visible, Hidden (the user can unhide it from Excel) or VeryHidden (it can’t be unhidden from Excel).
Initialize Object Array
Creates a new object array variable in your workflow to store structured Microsoft Excel 365 data for use in later steps.
- Variable name - Enter the name of the variable that will hold the object array. This name will be used throughout the workflow whenever you refer to this object array.
- Object Element Type - Select the type of object the array will store. The selected type determines the structure of the array and opens its fields so you can fill in the values for the first entry.
Append to Object Array
Adds a new entry to an existing object array variable in your workflow.
- Variable - Select the object array variable you want to append to. This must be an already initialized object array.
- Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.
Map Object Array
Transforms a list of data into a structured object array that can be used later in the workflow. It iterates over each item in the selected data list and maps it into a structured entry.
- Data List - Select or map the array or list of data you want to iterate over and transform.
- Object name - Define the name of the temporary object that represents each item during the mapping. You will use this name when referencing fields from the current item.
- Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.
Send API Request
This activity allows you to send a custom API request directly to the Microsoft Graph API. Use it for Excel features that the actions above don’t cover.
- Base Url - The root URL of the Microsoft Graph API (https://graph.microsoft.com/v1.0). It is filled in from your Microsoft Excel 365 connection and can’t be edited here.
- Relative url - You can specify additional path segments or parameters that need to be added to the end of the Base Url. This allows you to customize the specific request you want to perform. For example, /me/drive/items/{workbook-id}/workbook/worksheets lists the worksheets of a workbook in your OneDrive.
- Method - Select the HTTP method (e.g., Get, Post, Put, Delete, Patch). The default is POST.
- Body Type - Defines the format of the data in the body of your request. The default, application/json, means the body contains a JSON-formatted payload.
- application/json – Sends the request body in JSON format. Commonly used by REST APIs.
- custom – Allows you to define a custom body format by manually setting the Content-Type header. Add a
Content-Typerow in Add Headers with the media type you need (for exampleapplication/xml). With any other Body Type, a Content-Type you type in Add Headers is not sent; Engini sets it from the Body Type, and the run history shows it underheadersnotsent. - application/x-www-form-urlencoded – Sends the body as URL-encoded key-value pairs, commonly used in form submissions.
- file – Sends a file as the request body.
- multipart/form-data – Sends form data that may include both text fields and files.
- text/html – Sends the request body as HTML content.
- text/plain – Sends the request body as plain text.
- text/xml – Sends the request body in XML format.
- Body - Contains any data that is being sent to the server.
- Add Headers - Additional metadata about the request, such as the type of data the Engini can accept, the length of the request body, and authentication information.
- Add Queries - The query refers to the parameters or data that are included in the URL of an HTTP request to provide additional information or instructions to the server.