Clear Cell Range | Clear range values such as format, fill, and border. |
Delete Cell Range | Deletes the cells associated with the range. |
Get Cell Range | Retrieve the properties and relationships of range object. |
Get Cell | Retrieves a cell from a worksheet. |
Update Cell Range | Update the properties of range object. |
List Columns | Retrieve a list of colums from a worksheet table. |
Get Column | Retrieves a column object from a worksheet table. |
Update Column | Updates a column object from a worksheet table. |
Create Column | Creates a Column object inside a worksheet table. |
Delete Column | Deletes a column object from a worksheet table. |
Create Multiple Rows | Adds rows to the end of a table. |
Create Row | Creates a row object inside a worksheet table. |
List Rows | Retrieve a list of rows from a worksheet table. |
List Tables | Retrieve a list of tables from a worksheet. |
Get Table | Retrieves a table object from a worksheet. |
Update Table | Updates a table object from a worksheet. |
Create Table | Creates a table object inside a worksheet. |
Delete Table | Deletes a table object from a worksheet. |
List Workbooks | Return a collection of Workbooks from either a OneDrive or SharePoint site. |
List Worksheets | Retrieve a list of worksheet objects. |
Get Worksheet | Retrieves a worksheet object from a workbook. |
Update Worksheet | Updates a worksheet object from a workbook. |
Create Worksheet | Creates a worksheet object inside a workbook. |
Delete Worksheet | Deletes a worksheet from a workbook. |
Build Spreadsheet | Creates a buffer containing a spreadsheet made from a 2D JavaScript array, |
Build Spreadsheet with Multiple Sheets | Creates a buffer containing multiple spreadsheets made from a 3D JavaScript array. |
Read From URL | Parse an xlsx file from a URL endpoint, outputs an array of worksheets |
Read From Buffer | Parse an xlsx file from a Buffer, outputs an array of worksheets |
Raw Request | Send raw HTTP request to Microsoft Excel API. |