Excel

Tools

• Create Workbook

  Create a new Excel workbook in OneDrive or SharePoint

• List Worksheets

  List all worksheets in an Excel workbook

• Add Worksheet

  Add a new worksheet to an Excel workbook

• Read Worksheet

  Read data from a worksheet

• Update Cells

  Update cell values in a worksheet

• Search Data

  Get data from a specific range in Excel worksheet (e.g., A1:D10)

• Add Row

  Add a row to the end of a worksheet

• Add Table

  Create a new table in a worksheet

• Add Table Row

  Add a row to a table

• Find Row

  Find a row by column value

• Find Or Create Row

  Find a row by column value or create it if not found

• Update Row

  Update a specific row in a worksheet

• Delete Worksheet Row

  Delete a row from a worksheet

• List Tables

  List all tables in an Excel workbook

• Get Table

  Get table metadata

• List Table Rows

  List rows in a table

• Add Table Column

  Add a column to a table

• Update Table Column

  Update data in a table column

• Delete Table

  Delete a table (data remains, only deletes the table object)

• Download Workbook

  Get a download URL for the workbook

• Search Workbooks

  Search for workbooks in OneDrive and SharePoint