Microsoft Excel 365
Authentication Type: OAuth
Description: Manage Excel workbooks, tables, and sheets with data operations and table management capabilities.
Beta Notice
This tool is currently in beta testing and not yet available for general use.
To get the Microsoft Excel 365 tool added to your Cotera workspace, please contact our support team at support.cotera.co.
Table Operations
Manage Excel tables with data manipulation and structure operations.
Append Rows to Table
Add rows to the end of the table to insert new data while maintaining table structure and formatting.
Operation Type: Mutation (Write)
Create Table
Add a table based on a range to convert a range of cells into a structured Excel table with headers and formatting.
Operation Type: Mutation (Write)
Convert Table to Range
Convert a table to a range to remove table formatting while preserving cell data and values.
Operation Type: Mutation (Write)
Get Table Columns
Retrieve a list of table columns to access column names, properties, and metadata from Excel tables.
Operation Type: Query (Read)
Get Table Rows
Retrieve a list of table rows to read data and values from all rows in an Excel table.
Operation Type: Query (Read)
Lookup in Table
Look for rows that match a given value in a column to search and filter table data based on specific criteria.
Operation Type: Query (Read)
Sheet Operations
Manage Excel sheets and their data.
Get Sheets
Get a list of sheets to retrieve all worksheets in an Excel workbook with their names and properties.
Operation Type: Query (Read)
Get Sheet Rows
Retrieve a list of sheet rows to read data from specific rows in an Excel worksheet.
Operation Type: Query (Read)
Append Data to Sheet
Append data to sheet to add new rows to the end of a worksheet without affecting existing data.
Operation Type: Mutation (Write)