Skip to main content
Let’s learn how to connect Engini to Microsoft Excel 365. This integration connects Engini workflows with Excel workbooks stored in OneDrive or SharePoint, allowing you to read worksheet data, add named ranges and charts, and call any other Excel feature through the Microsoft Graph API. With the Microsoft Excel 365 activities in Engini you can:
  • 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

  1. Enter your Engini account at https://app.engini.io.
  2. Navigate to the Connections page by clicking on Connections in the left sidebar or by clicking here. Engini — Connections page
  3. Click on the “New Integration” option located at the top bar. Engini — New Integration button
  4. Choose the Microsoft Excel 365 option from the available applications. Microsoft Excel 365 — Choose Application
  5. Enter the following details in the “New Integration” form and press Save: Microsoft Excel 365 — New Integration form 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.
Engini sends the access token with every request made through this connection, so you don’t need to add it to any action.

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. Microsoft Excel 365 — Add Chart action
  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
After you fill in the Workbook Item ID, the Worksheet ID or Name field appears. Choose the worksheet, or map its ID or name from a previous step such as Get Worksheets. This is the worksheet the chart is added to.

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. Microsoft Excel 365 — Add Named Item action
  1. 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.
  2. 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.
  3. 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.
  4. Name - The name to define. It must start with a letter and can’t contain spaces, for example Sales_Totals.
  5. Reference - The range the name refers to, written as a formula, for example =Sheet1!$A$1:$C$5.
  6. Comment - Optional. A free-text comment saved with the name, for example Q3 sales totals.

Add Table Column

Adds a column to a table. Microsoft Excel 365 — Add Table Column action
  1. 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.
  2. 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.
  3. 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.
  4. Name - The name of the new column, which becomes its header, for example Status.
  5. 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"]].
  6. 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.
After you fill in the Workbook Item ID, the Table ID or Name field appears. Choose the table, or map its ID or name from a previous step such as Get Tables.

Add Table Row

Adds one or more rows to a table. Microsoft Excel 365 — Add Table Row action
  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
After you fill in the Workbook Item ID, the Table ID or Name field appears. Choose the table, or map its ID or name from a previous step such as Get Tables.

Add Worksheet

Adds a new worksheet to a workbook. Microsoft Excel 365 — Add Worksheet action
  1. 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.
  2. 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.
  3. 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.
  4. 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. Microsoft Excel 365 — Clear Table Filter action
  1. 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.
  2. 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.
  3. 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.
After you fill in the Workbook Item ID, the Worksheet ID or Name field appears. Choose the worksheet, or map its ID or name from a previous step such as Get Worksheets. After you choose the worksheet, the Table ID or Name field appears. Choose the table, or map its ID or name from a previous step such as Get Tables, and after you choose the table, the Column ID or Index field appears. Choose the column, or enter its ID or its position counted from 0.

Close Workbook Session

Closes a workbook session that was opened with Create Workbook Session. Microsoft Excel 365 — Close Workbook Session action
  1. 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.
  2. 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.
  3. 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. Microsoft Excel 365 — Create Table action
  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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. Microsoft Excel 365 — Create Workbook Session action
  1. 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.
  2. 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.
  3. 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. Enter false to discard the changes when the session ends.

Delete Table Column

Deletes a column from a table. Microsoft Excel 365 — Delete Table Column action
  1. 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.
  2. 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.
  3. 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.
After you fill in the Workbook Item ID, the Table ID or Name field appears. Choose the table, or map its ID or name from a previous step such as Get Tables, and after you choose the table, the Column ID or Name field appears. Choose the column to delete, or map its ID or name from a previous step such as Get Table Columns.

Delete Table Row

Deletes a row from a table. Microsoft Excel 365 — Delete Table Row action
  1. 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.
  2. 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.
  3. 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.
After you fill in the Workbook Item ID, the Table ID or Name field appears. Choose the table, or map its ID or name from a previous step such as Get Tables, and after you choose the table, the Row Index field appears. Enter the position of the row to delete, counted from 0 for the first row of the table, for example 0 for the first row.

Delete Worksheet

Deletes a worksheet from a workbook. Microsoft Excel 365 — Delete Worksheet action
  1. 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.
  2. 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.
  3. 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.
After you fill in the Workbook Item ID, the Worksheet ID or Name field appears. Choose the worksheet, or map its ID or name from a previous step such as Get Worksheets. This is the worksheet that is deleted.

Filter Table Column

Applies a filter to a column of a table, so only the rows that match the filter show. Microsoft Excel 365 — Filter Table Column action
  1. 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.
  2. 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.
  3. 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.
  4. Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.
After you fill in the Workbook Item ID, the Worksheet ID or Name field appears. Choose the worksheet, or map its ID or name from a previous step such as Get Worksheets. After you choose the worksheet, the Table ID or Name field appears. Choose the table, or map its ID or name from a previous step such as Get Tables, and after you choose the table, the Column ID or Index field appears. Choose the column, or enter its ID or its position counted from 0. The following field is added through Add Field:
  • 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: custom filters by the conditions in Criterion 1 and Criterion 2, and values keeps 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, and or or. Criterion 2 is the second condition, for example =5. Values holds the values to keep when Filter On is values, for example Open, Pending.

Get Chart Image

Retrieves an image of a chart, for example to attach it to an email or save it as a file. Microsoft Excel 365 — Get Chart Image action
  1. 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.
  2. 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.
  3. Width - The width of the image, in pixels, for example 800. The field shows 0, which uses the default size.
  4. Height - The height of the image, in pixels, for example 600. The field shows 0, which uses the default size.
  5. Fitting Mode - How the chart is fitted into the image. Click the field to open the tooltip and choose fit to scale the chart to fit inside the image, fitandcenter to scale it and center it, or fill to fill the whole image.
  6. 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.
After you fill in the Workbook Item ID, the Worksheet ID or Name field appears. Choose the worksheet, or map its ID or name from a previous step such as Get Worksheets. After you choose the worksheet, the Chart ID or Name field appears. Choose the chart, or map its ID or name from a previous step such as Get Charts.

Get Charts

Retrieves the charts in a worksheet. Microsoft Excel 365 - Get Charts action
  1. 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.
  2. 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.
  3. 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.
After you fill in the Workbook Item ID, the Worksheet ID or Name field appears. Choose the worksheet, or map its ID or name from a previous step such as Get Worksheets. This is the worksheet whose charts are listed.

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. Microsoft Excel 365 — Get Group's Drive Id action
  • 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. Microsoft Excel 365 - Get Groups action
  1. 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.
  2. Select - Optional. A comma-separated list of the group properties to return, for example id,displayName. Leave it blank to return the default properties.
  3. 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. Microsoft Excel 365 - Get Named Items action
  1. 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.
  2. 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.
  3. 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. Microsoft Excel 365 — Get Range action
  1. 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.
  2. 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.
  3. 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.
After you fill in the Workbook Item ID, the Worksheet ID or Name field appears. Choose the worksheet, or map its ID or name from a previous step such as Get Worksheets. After you choose the worksheet, the Range Address field appears. Enter the cells to read in A1 notation, for example 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. Microsoft Excel 365 — Get Site's Drives action
  • 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. Microsoft Excel 365 - Get Table Columns action
  1. 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.
  2. 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.
  3. 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.
After you fill in the Workbook Item ID, the Table ID or Name field appears. Choose the table, or map its ID or name from a previous step such as Get Tables.

Get Table Rows

Retrieves the rows of a table. Microsoft Excel 365 - Get Table Rows action
  1. 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.
  2. 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.
  3. 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.
After you fill in the Workbook Item ID, the Table ID or Name field appears. Choose the table, or map its ID or name from a previous step such as Get Tables.

Get Tables

Retrieves all the tables in a workbook, with each table’s ID and name. Microsoft Excel 365 - Get Tables action
  1. 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.
  2. 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.
  3. 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. Microsoft Excel 365 — Get Workbook action
  • 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.
After you choose a location, select the folder, then the workbook. The Workbook list shows the Excel files in the selected folder. For My Drive, the drive is selected automatically and isn’t shown. For Group Drive, select the group and its drive before the folder.

Get Workbooks

Retrieves the workbooks stored in a OneDrive or SharePoint location, for example to loop over every workbook in a folder. Microsoft Excel 365 — Get Workbooks action
  • 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.
After you choose a location, the Query field appears. Enter text to search for in the file names, for example 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. Microsoft Excel 365 — Get Worksheet action
  1. 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.
  2. 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.
  3. 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.
After you fill in the Workbook Item ID, the Worksheet ID or Name field appears. Choose the worksheet, or map its ID or name from a previous step such as Get Worksheets. This is the worksheet whose details are returned.

Get Worksheets

Retrieves all the worksheets of a workbook, with each worksheet’s ID, name, position and visibility. Microsoft Excel 365 - Get Worksheets action
  1. 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.
  2. 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.
  3. 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. Microsoft Excel 365 — Sort Range action
  1. 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.
  2. 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.
  3. 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.
  4. Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.
After you fill in the Workbook Item ID, the Worksheet ID or Name field appears. Choose the worksheet, or map its ID or name from a previous step such as Get Worksheets. The following field is added through Add Field:
  • 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. Microsoft Excel 365 — Sort Table action
  1. 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.
  2. 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.
  3. 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.
  4. Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.
After you fill in the Workbook Item ID, the Worksheet ID or Name field appears. Choose the worksheet, or map its ID or name from a previous step such as Get Worksheets. After you choose the worksheet, the Table ID or Name field appears. Choose the table, or map its ID or name from a previous step such as Get Tables. The following field is added through Add Field:
  • 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. Microsoft Excel 365 — Update Chart action
  1. 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.
  2. 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.
  3. 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.
  4. Name - The new name of the chart, for example Sales by Month.
  5. Height - The height of the chart, in points, for example 250.
  6. Width - The width of the chart, in points, for example 400.
  7. Left - The distance of the chart from the left edge of the worksheet, in points.
  8. Top - The distance of the chart from the top edge of the worksheet, in points.
After you fill in the Workbook Item ID, the Worksheet ID or Name field appears. Choose the worksheet, or map its ID or name from a previous step such as Get Worksheets. After you choose the worksheet, the Chart ID or Name field appears. Choose the chart, or map its ID or name from a previous step such as Get Charts.

Update Range

Writes values, formulas or number formats to a range of cells in a worksheet. Microsoft Excel 365 — Update Range action
  1. 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.
  2. 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.
  3. 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.
  4. Values - The values to write, as rows. Each row is a list of values, one per cell, for example [["A1","B1"]].
  5. Formulas - The formulas to write, as rows. Each row is a list of formulas, for example [["=SUM(A1:A2)"]].
  6. Number Format - The number formats to apply, as rows. Each row is a list of formats, for example [["General"]].
After you fill in the Workbook Item ID, the Worksheet ID or Name field appears. Choose the worksheet, or map its ID or name from a previous step such as Get Worksheets. After you choose the worksheet, the Range Address field appears. Enter the cells to write to in A1 notation, for example 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. Microsoft Excel 365 — Update Table action
  1. 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.
  2. 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.
  3. 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.
  4. Name - The new name of the table, for example SalesData.
  5. Show Headers - Whether the table shows its header row. Click the empty field to open the tooltip and choose True or False.
  6. Show Totals - Whether the table shows its total row. Click the empty field to open the tooltip and choose True or False.
  7. Style - The table style, for example TableStyleMedium4.
After you fill in the Workbook Item ID, the Table ID or Name field appears. Choose the table, or map its ID or name from a previous step such as Get Tables.

Update Worksheet

Updates the name, position or visibility of a worksheet. Microsoft Excel 365 — Update Worksheet action
  1. 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.
  2. 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.
  3. 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.
  4. Name - The new name of the worksheet, for example Q3 Report.
  5. Position - The position of the worksheet among the workbook’s tabs, counted from 0 for the first tab, for example 0 to make it the first tab.
  6. 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).
After you fill in the Workbook Item ID, the Worksheet ID or Name field appears. Choose the worksheet, or map its ID or name from a previous step such as Get Worksheets.

Initialize Object Array

Creates a new object array variable in your workflow to store structured Microsoft Excel 365 data for use in later steps. Microsoft Excel 365 - Initialize Object Array action
  1. 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.
  2. 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. Microsoft Excel 365 - Append to Object Array action
  1. Variable - Select the object array variable you want to append to. This must be an already initialized object array.
  2. 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. Microsoft Excel 365 - Map Object Array action
  1. Data List - Select or map the array or list of data you want to iterate over and transform.
  2. 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.
  3. 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. Microsoft Excel 365 — Send API Request action
  1. 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.
  2. 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.
  3. Method - Select the HTTP method (e.g., Get, Post, Put, Delete, Patch). The default is POST.
  4. 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-Type row in Add Headers with the media type you need (for example application/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 under headersnotsent.
    • 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.
  5. Body - Contains any data that is being sent to the server.
  6. 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.
  7. 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.
Engini adds your connection’s access token to every request as an Authorization header, so you don’t need to add it to the headers. For the full list of endpoints, see the Microsoft Graph Excel API reference.