Reference

Add Table

Create a structured table in an Excel worksheet to organize and format your data for easier analysis and filtering. Tables make it simple to work with groups of related information and apply formulas across entire columns automatically.

Add Table Row

Adds a new row to an existing table in Excel, automatically populating it with data you specify. Use this to grow your data tables without manually entering each row.

Apply Table Filter

Apply filters to specific columns in your Excel tables to display only the data you need, making it easier to focus on relevant information and analyze subsets of your data.

Create Workbook

Generate a new Excel workbook file with your specified worksheets and data, then automatically save it to your OneDrive for easy access and sharing.

Export Workbook to PDF

Converts an Excel workbook into a PDF file format, making it easy to share, distribute, or archive spreadsheet data in a universally readable format.

List Drive Files

Retrieve a complete list of files and folders from your Excel drive or a specific folder path to organize and manage your spreadsheets. This helps you quickly find, audit, and keep track of all your data files in one place.

List Table Rows

Retrieves all rows from a specified table in an Excel workbook, allowing you to access and analyze tabular data stored in your spreadsheets.

Update Range

Modify data in multiple cells at once within an Excel worksheet, allowing you to efficiently update values, formulas, or formatting across a selected range. This helps you quickly make batch updates without having to edit cells individually.

Add Chart

Create visual charts and graphs in your Excel worksheets to transform raw data into easy-to-understand visualizations that tell a story about your business metrics.

Add SharePoint Worksheet

Create a new worksheet within an Excel workbook stored on SharePoint, allowing you to organize and expand your spreadsheet structure in the cloud. This enables you to keep related data separated and collaborate with team members on specific sections of your workbook.

Add Table Column

Adds a new column to an existing table in Excel, allowing you to expand your data structure with additional fields for tracking or analysis. This helps you organize related information together without restructuring your entire spreadsheet.

Add Workbook Permission

Grant access to an Excel workbook by sending invites to specific people with defined roles. Use this when you need to collaborate with team members or clients on shared spreadsheets while controlling their permission levels.

Add Worksheet

Creates a new worksheet in your Excel workbook, allowing you to organize data across multiple sheets and separate different types of information within a single file.

Apply Table Sort

Organize your spreadsheet data by sorting a table by specific columns in any order you need. This helps you quickly find, analyze, and present information without manually rearranging rows.

Clear Range

Removes values, formatting, or contents from a specified range of cells in your Excel worksheet, allowing you to reset cells before entering new data.

Clear Table Filter

Remove filters from your Excel table columns to display all data again without restrictions. This helps you see the complete dataset after you've finished analyzing a filtered subset.

Close Excel Session

Ends an active Excel workbook session and releases any locks on the file, allowing other users or processes to access it freely. Use this when you're done working with a spreadsheet to prevent conflicts and free up resources.

Convert Table To Range

Transforms a formatted Excel table back into a regular cell range, removing table features while preserving the data. This is useful when you need to eliminate automatic filtering, formulas, or style formatting that comes with structured tables.

Create Excel Session

Establishes a secure connection to your Excel workbook so you can read, modify, and manage spreadsheet data programmatically. This is the first step needed before performing any other operations on your Excel files.

Delete Table Column

Remove a specific column from an Excel table to clean up data structure or eliminate unnecessary fields. This helps you maintain organized spreadsheets by removing columns that are no longer needed.

Delete Table Row

Remove a specific row from an Excel table to keep your data clean and current. This helps maintain accurate records by deleting outdated or incorrect entries directly from structured tables.

Delete Worksheet

Removes a worksheet from your Excel workbook to keep your file organized and remove unnecessary sheets. Use this to clean up temporary work areas or consolidate data after completing analysis.

Get Chart Axis

Retrieves detailed properties of a chart axis, including scale settings, intervals, and formatting, allowing you to programmatically inspect or verify chart configuration details.

Get Chart Data Labels

Retrieve and inspect the label settings on your Excel charts, including their position, visibility, and formatting to ensure they display your data clearly.

Get Chart Legend

Retrieves the legend information from an Excel chart, including its visibility settings and formatting details. Use this to verify how your chart's legend appears and make adjustments to ensure clarity and readability.

Get Range

Retrieve specific data from a worksheet in Excel, allowing you to extract values, formulas, or formatting from defined cell ranges. This enables you to read structured data from your spreadsheets programmatically for analysis, reporting, or integration with other tools.

Get SharePoint Range

Retrieve specific data from a worksheet stored in SharePoint, allowing you to access and work with spreadsheet information from your team's shared documents.

Get SharePoint Worksheet

Retrieves a specific worksheet from an Excel workbook stored in SharePoint, allowing you to access and work with particular sheets within your business documents. This is useful when you need to pull data from or interact with individual worksheets in your shared Excel files.

Get table column

Retrieve all data and properties from a specific column within an Excel table, enabling you to work with column-specific information for analysis or automation.

Get workbook

Retrieve and inspect the structure, properties, and contents of an Excel workbook including worksheets, tables, named ranges, and comments. Use this to understand what data and elements exist in your spreadsheet before performing other operations.

Get Worksheet

Retrieve a specific worksheet from your Excel workbook by name or ID to access its data and structure. This lets you programmatically interact with individual sheets within your spreadsheet.

Get Worksheet Used Range

Retrieves all data from a worksheet without needing to know the exact range beforehand, automatically identifying which cells contain actual values. This is useful when working with dynamic spreadsheets where the data boundaries change frequently.

Insert Range

Insert a new cell range into your worksheet and automatically shift existing content down or right to make space for new data without losing information.

List Chart Series

Retrieve all data series contained within a chart to analyze and work with the underlying data structures. This helps you understand what data is visualized in your charts before making modifications or extracting information.

List Charts

Retrieve all charts from a specific worksheet to see visualizations you've created, helping you organize and manage your data presentations.

List Comments

Retrieve all comments from an Excel workbook to review feedback, suggestions, and notes that team members have added to your spreadsheet.

List Drive Item Children

Retrieve all files and folders contained within a specific folder in your Excel drive, making it easy to explore and organize your file structure. This helps you quickly find documents, understand folder hierarchy, and manage your cloud storage contents.

List Named Items

Retrieve all named ranges and defined names in your Excel workbook to see what references are available for formulas and reporting. This helps you organize and reference important data ranges by meaningful names instead of cell coordinates.

List SharePoint Tables

Retrieve all tables stored in your SharePoint worksheet to see what data structures and datasets you have available. This helps you identify and organize your business data sources across your team's shared workspace.

List SharePoint Worksheets

Retrieve all worksheets from an Excel workbook stored in SharePoint, allowing you to see what sheets are available in your shared workbook. This helps you organize and manage collaborative spreadsheets across your team.

List Table Columns

Retrieve all columns from a specific table in your Excel workbook to understand the data structure and available fields. This helps you organize, validate, and work with your spreadsheet data programmatically.

List Tables

Retrieve all tables within a specific Excel worksheet to see structured data ranges and their properties. This helps you understand and work with organized data in your spreadsheets programmatically.

List Workbook Permissions

View all users and shared links that have access to your Excel workbook, helping you manage who can view or edit your important spreadsheets.

List Worksheets

Retrieve all worksheets available in an Excel workbook to see what sheets exist and access their contents. This helps you understand the structure of your spreadsheet before reading or updating data.

Merge Cells

Combine multiple cells into a single cell in your Excel worksheet to create cleaner layouts for headers, titles, or grouped data sections. This is useful when you want to consolidate information visually or improve the readability of your spreadsheet formatting.

Protect Worksheet

Protect a worksheet to prevent unauthorized edits while still allowing approved users to view and interact with specific cells. This helps you safely share spreadsheets while maintaining data integrity and controlling what others can modify.

Search Drive Files

Find Excel files stored in your OneDrive by searching for file names or keywords, helping you locate the right workbook before opening or editing it.

Sort Range

Organizes data within a spreadsheet range in ascending or descending order by one or more columns, making it easier to analyze and find information quickly.

Update Chart

Modify an existing chart in your Excel spreadsheet to reflect new data, change the chart type, or update formatting without recreating it from scratch.

Update Chart Legend

Modify the appearance and placement of chart legends in your Excel worksheets to improve readability and presentation. Use this when you need to reposition, hide, or reformat legend elements to better suit your data visualization layout.

Update SharePoint Range

Update a range in a SharePoint worksheet using Microsoft Graph Sites API.

Update Table

Update a table in a workbook using Microsoft Graph API.

Update Worksheet

Update worksheet properties (name, position) in an Excel workbook using Microsoft Graph API.

Upload Workbook from URL

Tool to upload an external Excel file from a URL into OneDrive/SharePoint.