Microsoft Excel 365

Append Row to Worksheet

Append row of values to a worksheet

Append Multiple Rows

Appends multiple row of values to a worksheet.

Get Worksheets

Retrieve worksheets from a workbook

Get Worksheet Rows

Retrieve rows from a worksheet

Update Worksheet Rows

Update a row in a worksheet

Clear Worksheet

Clear a worksheet

Delete Worksheet

Delete a worksheet in a workbook

Get Workbooks

Retrieve a list of workbooks

Get Worksheet Columns

List columns of a worksheet.

Delete Workbook

Delete a workbook

Add a Worksheet to a Workbook

Add a worksheet to a workbook

Get Table Rows

List rows of a table in a worksheet

Get Table Columns

List columns of a table in a worksheet

Create Table

Create a table in a worksheet

Delete Table

Delete a table from a worksheet

Lookup Table Column

Lookup a value in a table column in a worksheet

Append Rows to a Table

Append rows to a table

Convert to Range

Converts a table to a range

Create Workbook

Create a new workbook at the specified location

Clear Column by Index

Clear contents/formatting of a column by its index.

Clear Cells by Range

Clear a block of cells (range) content or formatting.

Clear Row by ID

Clear contents/formatting of an entire row by its ID.

Delete Row

Delete an entire row from a worksheet by its row number.

Create Worksheet

Add a new worksheet (tab) to an existing workbook with optional default headers.

Find Row

Locate a row by specifying a lookup column and value (e.g. find a row where “ID” = 123).

Find Workbook

Finds an existing workbook by name.

Find Worksheet

Finds an existing worksheet by name.

Get Cells in Range

Retrieve the values in a given cell range (e.g., “A1:C10”).

Get Row by ID

 Retrieve the entire content of a row by its row ID.

Get Worksheet by ID

Retrieve metadata of a worksheet by its ID.

Rename Worksheet

Change the name of an existing worksheet.

Custom API Call

Make a custom API call to a specific endpoint