Team
Shared credential for production and unattended runs.
Connect Excel with Hookshot™ and your stack
Microsoft Excel is a powerful spreadsheet application for data analysis, calculations, and visualization, enabling users to organize and process data with formulas, charts, and pivot tables
Tools and triggers
What Agents can do in Excel
Available tools and events after Excel is connected.
-
Add Chart
This action allows you to add a chart to a specified worksheet within an Excel file. You need to provide details such as the chart type and the range of source data for the chart.
-
Add SharePoint Worksheet
This action creates a new worksheet in an existing SharePoint Excel workbook. It requires the site's ID and the specific item's ID where the worksheet will be added, as well as the name for the new worksheet.
-
Add Table
Create a new table in a specified worksheet (or at the workbook level) in an Excel workbook. Provide the drive item ID, the range address, and whether the range has headers. When 'worksheet' is provided, the table is…
-
Add Table Column
This action adds a new column to a specified table within an Excel file. It requires the table's ID, the values for the new column, and the index for where the column should be inserted.
-
Add Table Row
This action allows the user to add a new row to a specified table in an Excel file stored on OneDrive. It provides options for positioning the new row and includes handling for workbook sessions.
-
Add Workbook Permission
Grants access to a workbook by sending invitations to specified recipients with defined roles. This action enables sharing of an Excel file with necessary permissions.
-
Add Worksheet
This action adds a new worksheet to an existing Excel workbook. It requires the ID of the file and the desired name for the new worksheet.
-
Apply Table Filter
This action applies a filter to a specified column within a table contained in an Excel worksheet using the Microsoft Graph API.
-
Apply Table Sort
This action applies a sort order to a specified table within an Excel worksheet. It utilizes the Microsoft Graph API to modify the table's sorting parameters as defined in the request.
-
Clear Range
This action clears the specified range in a worksheet, removing values, formats, or contents based on the user's choice. It's useful for preparing a range for new data entry.
-
Clear Table Filter
This action clears any existing filters on a specified column in a table. It requires the identification of the item, worksheet, and column for which the filter should be cleared.
-
Close Excel Session
Closes an active Excel workbook session. This action is necessary to ensure that the session ends and any locks on the workbook are released, allowing other operations to proceed safely.
-
Convert Table to Range
This action takes a table from an Excel file and converts it to a standard range format. This allows the data to be manipulated as a normal range in Excel after the conversion.
-
Create Excel Session
This action creates a session for an Excel workbook, allowing real-time collaboration. It utilizes the Microsoft Graph API to manage the session and persist any changes as needed.
-
Create Workbook
This action creates a new Excel workbook with the specified worksheets and data, then saves it to OneDrive. The workbook is generated from scratch and can include multiple worksheet tabs with custom names and populated…
-
Delete Table Column
This action deletes a specified column from a table in an Excel file. It uses the Microsoft Graph API to perform the deletion based on the provided identifiers.
-
Delete Table Row
This action deletes a specified row from a table in an Excel file. It uses the Microsoft Graph API to perform the deletion based on provided identifiers.
-
Delete Worksheet
This action deletes a specified worksheet from an Excel file in OneDrive. It requires the file ID and the worksheet name or ID, and may optionally include a session ID for the workbook.
-
Export Workbook to PDF
Tool to export an Excel workbook to PDF via Microsoft Graph's format conversion. Use when you need a PDF version of an Excel file for sending, storing, or attaching.
-
Get Chart Axis
This action retrieves information about a specific axis of a chart in a workbook. You can obtain properties such as the minimum and maximum values, as well as formatting options for the axis.
-
Get Chart Data Labels
Retrieve the data labels for a specified chart from an Excel workbook. This action allows inspection of various label settings, including visibility and formatting options.
-
Get Chart Legend
This action retrieves the legend object of a specified chart. It allows users to inspect visibility and formatting of the legend after chart creation or updates.
-
Get Range
This action retrieves a specified range of cells from a worksheet in an Excel file. It requires the ID of the worksheet and the specific range address to return the corresponding data.
-
Get SharePoint Range
Retrieves a specified range of cells from an Excel worksheet stored in SharePoint. The action accesses the workbook using Microsoft Graph API to fetch the requested data.
-
Get SharePoint Worksheet
Retrieves a specific worksheet from an Excel file stored in SharePoint. You can provide either the name or the ID of the worksheet to access its details.
-
Get Table Column
This action retrieves a specified column from a table in an Excel workbook. You can use the column's ID or name to fetch its properties and data.
-
Get Workbook
This action retrieves the workbook's properties and relationships. It can fetch comments, named items, tables, and worksheets for further inspection.
-
Get Worksheet
Retrieves details of a specified worksheet from a given Excel file. The worksheet can be identified by its name or ID, which must be URL-encoded if using ID.
-
Get Worksheet Used Range
Tool to retrieve a worksheet's used range (active data region) without specifying a fixed range address. Use when you need to read all data from a sheet but don't know the exact range. The valuesOnly option helps…
-
Insert Range
Inserts a new cell range into a specified worksheet. This action shifts existing cells down or right to create space for new data without overwriting what’s already there.
-
List Chart Series
This action retrieves all data series from a specified chart in an Excel worksheet. It allows users to analyze chart series for reporting or further processing.
-
List Charts
This action retrieves a list of charts present in a specified worksheet of an Excel file. It uses the Microsoft Graph API to fetch the charts based on the provided Excel file ID and worksheet name or ID.
-
List Comments
This action retrieves all comments for a specified Excel file in the workbook. It's useful for obtaining feedback or notes associated with the document.
-
List Drive Files
This action retrieves files and folders from a specified drive. It can list items under the user's default drive or a specified folder path.
-
List Drive Item Children
Tool to list immediate children (files/folders) of a folder DriveItem using driveId and itemId. Returns an array of child DriveItems with stable identifiers and pagination support.
-
List Named Items
This action retrieves all named items from a specified workbook. It allows users to interact with and manage named items within their Excel files.
-
List SharePoint Tables
This action retrieves a list of tables from a specified worksheet in a SharePoint Excel file. Users can specify the site and the item to target the correct file and worksheet.
-
List SharePoint Worksheets
This action retrieves a list of worksheets from a specific Excel workbook stored in SharePoint. It allows users to access detailed information about each worksheet within the workbook.
-
List Table Columns
This action retrieves a list of columns from a specified table in an Excel file stored on OneDrive or SharePoint. It allows users to easily access column information such as IDs, names, and values.
-
List Table Rows
This action retrieves all rows from a specified table within an Excel file. It requires the Excel file ID and the table ID to fetch the data from Microsoft Graph API.
-
List Tables
List tables in a worksheet using Microsoft Graph API. This action retrieves information about all tables present in a specified worksheet of an Excel file. It requires the file ID and worksheet name or ID, and can…
-
List Workbook Permissions
Lists the permissions on a specified workbook file. This action shows which users or links have access based on the provided drive and item IDs.
-
List Worksheets
This action retrieves a list of worksheets from a specified Excel workbook. It allows users to access metadata about each worksheet, such as its ID and name.
-
Merge Cells
This action merges a specified range of cells in a worksheet within an Excel file. It interacts with the Microsoft Graph API to facilitate merging operations, allowing for customization of how cells are merged across…
-
Protect Worksheet
This action protects a specified worksheet in an Excel file. You can customize the protection options to restrict various editing features like formatting and inserting rows or columns.
-
Search Drive Files
This action searches OneDrive for files and folders matching a query string. It's commonly used to find Excel workbooks by filename before creating sessions or performing operations on them.
-
Sort Range
This action sorts a specified range in a worksheet. It utilizes the Microsoft Graph API to apply sorting based on the provided fields and parameters.
-
Update Chart
This action updates the properties of a chart in a specified worksheet using the Microsoft Graph API. You can change various parameters such as name, height, width, left position, and top position of the chart.
-
Update Chart Legend
This action updates the legend properties of a specified chart within a workbook. You can set the visibility, position, and overlay status of the legend.
-
Update Range
This action updates a specified range in an Excel worksheet. It modifies the cell values within the given address based on the provided inputs.
-
Update SharePoint Range
This action updates a specified range within a SharePoint worksheet by providing new values. It utilizes the Microsoft Graph API to interact with the Excel file in the SharePoint site.
-
Update Table
This action allows you to update an existing table within a specified Excel workbook. You can modify the table's name, headers visibility, totals visibility, and style.
-
Update Worksheet
This action updates the properties of a specified worksheet in an Excel workbook. You can change the worksheet's name or its position within the workbook.
-
Upload Workbook From URL
This action downloads an Excel file from a given URL and uploads it to the connected OneDrive or SharePoint drive. It returns the driveItem metadata (driveId, itemId, webUrl) needed for subsequent Excel Graph API…
Setup
Connect Excel in Hookshot™
Pick a scope, then confirm what can start a Protege and what it can do.
Trigger Access
What can start a Protege from this app.
Tool Access
What a Protege can do after it starts.
Connection scope
Prefer team for production.
Personal
Tied to one user—only when the workflow needs their account.
Chat
Team-scoped for supported chat surfaces.
Build with us
See Hookshot™ in your stack.
Request early access or book a live walkthrough with the team.
