- Search for Excel (.xlsx) files in the user's OneDrive or across all accessible drives
- Get metadata for a specific Excel workbook DriveItem by ID
- Create a persistent or non-persistent workbook session
- Retrieve the list of worksheets in an Excel workbook
- Retrieve a specific worksheet by ID or name
- Create a new worksheet in an Excel workbook
- Update properties of a worksheet (name, position, visibility)
- Delete a worksheet from an Excel workbook
- Retrieve the protection properties of a worksheet
- Protect a worksheet with optional protection options
- Unprotect a protected worksheet
- Retrieve the list of tables in an Excel workbook
- Retrieve a specific table by ID or name
- Create a new table in an Excel workbook
- Update properties of a table (name, headers, totals, style)
- Delete a table from an Excel workbook
- Convert a table to a normal range of cells
- Retrieve the rows of a table in an Excel workbook
- Add a new row to a table in an Excel workbook
- Delete a row from a table by its zero-based index
- Retrieve the columns of a table in an Excel workbook
- Add a new column to a table in an Excel workbook
- Delete a column from a table by its ID
- Retrieve the range associated with the data body of a table
- Retrieve the range associated with the header row of a table
- Retrieve the range associated with the entire table
- Retrieve the range associated with the totals row of a table
- Clear all filters currently applied on a table
- Retrieve the sort configuration of a table
- Apply a sort operation on a table
- Clear the current sort state of a table
- Reapply the current sort parameters to a table
- Apply filter criteria to a specific column in a table
- Clear the filter on a specific column in a table
- Retrieve the icon used in a table sort field
- Update the icon used in a table sort field
- Retrieve the properties and relationships of a cell range
- Retrieve the used range of a worksheet
- Retrieve a single cell based on row and column numbers within a range
- Retrieve a column contained in a range
- Get a certain number of columns to the right of a given range
- Get a certain number of columns to the left of a given range
- Get the entire column of a range
- Get the entire row of a range
- Get the rectangular intersection of two ranges
- Get the last cell within a range
- Get the last column within a range
- Get the last row within a range
- Get a range offset from the specified range by a number of rows and columns
- Get a range expanded or contracted from the current range
- Get a row contained in a range
- Get a certain number of rows above a given range
- Get a certain number of rows below a given range
- Merge the range cells into one region in the worksheet
- Unmerge the range cells into separate cells
- Retrieve the named items (named ranges and constants) in an Excel workbook
- Add a new named item (named range or constant) to an Excel workbook
- Retrieve the properties and relationships of a named item in an Excel workbook
- Update the properties of a named item in an Excel workbook
- Retrieve the range object associated with a named item
- Delete a named item from an Excel workbook
- Retrieve the list of charts in a worksheet
- Retrieve a specific chart by ID or name
- Create a new chart in a worksheet
- Update properties of a chart (name, dimensions, position)
- Position a chart relative to cells on the worksheet
- Reset the source data for a chart
- Delete a chart from a worksheet
- Get a chart based on its zero-based position in the worksheet
- Render a chart as a base64-encoded image
- Add a new series to a chart
- Retrieve the list of series in a chart
- Retrieve a specific series from a chart by its zero-based index
- Update the name of a chart series by its zero-based index
- Retrieve the properties of a chart axis
- Update properties of a chart axis (min, max, units)
- Retrieve the title of a chart axis
- Update the title of a chart axis
- Retrieve the data labels configuration of a chart
- Update the data labels configuration of a chart
- Clear the fill color of a chart, title, or legend element
- Set the fill of a chart, title, or legend element to a solid color
- Retrieve the font properties of a chart axis
- Update the font properties of a chart axis
- Retrieve the gridlines configuration of a chart axis
- Update the visibility of chart axis gridlines
- Retrieve the legend properties of a chart
- Update the legend properties of a chart
- Retrieve the line format properties of a chart axis or gridlines
- Update the line color of a chart axis or gridlines
- Clear the line format of a chart axis or gridlines
- Retrieve the list of data points in a chart series
- Retrieve a specific data point in a chart series by ID
- Retrieve a data point by its zero-based index within a chart series
- Retrieve the title properties of a chart
- Update the title properties of a chart
- Retrieve the list of comments in an Excel workbook
- Retrieve a specific comment in an Excel workbook by ID
- Retrieve the list of replies for a workbook comment
- Create a new reply to a workbook comment
- Retrieve a specific reply to a workbook comment by ID
No matching actions