Microsoft Excel

• List drivesList the OneDrive and SharePoint drives this account can reach. Every other Excel action needs one of these drive IDs.
• List sitesSearch the tenant's SharePoint sites. Use it to find the site whose document library holds a workbook.
• List site drivesList a SharePoint site's document libraries. Each one is a drive whose ID the other Excel actions take.
• List workbooksFind Excel workbooks in a OneDrive or SharePoint drive.
• Recalculate workbookForce Excel to recalculate the workbook's formulas.
• List commentsList the comments in a workbook. Excel's Graph API is read-only for comments, so they cannot be created or replied to.
• Run workbook functionEvaluate one of Excel's worksheet functions (VLOOKUP, SUM, PMT, ...) without writing it into a cell.
• List worksheetsList all worksheets in an Excel workbook.
• Get worksheetRead a worksheet's name, position and visibility.
• Add worksheetAdd a new worksheet to an Excel workbook.
• Rename worksheetRename an existing worksheet in an Excel workbook.
• Update worksheetMove a worksheet in the tab strip or change whether it is visible. Use 'Rename worksheet' to change its name.
• Delete worksheetDelete a worksheet from an Excel workbook.
• Protect worksheetProtect a worksheet against edits.
• Unprotect worksheetRemove protection from a worksheet.
• Get range valuesRead the values of a cell range.
• Get used rangeRead every populated cell on a worksheet without knowing its address.
• Update range valuesWrite literal values into a cell range.
• Set range formulasWrite formulas into a cell range.
• Set range number formatApply Excel number formats to a cell range.
• Clear rangeClear the contents, the formatting, or both, from a cell range.
• Insert cellsInsert blank cells into a range, shifting the existing cells out of the way.
• Delete cellsDelete a range of cells, pulling the remaining cells into the gap.
• Merge cellsMerge a range of cells into one.
• Unmerge cellsSplit previously merged cells back apart.
• Sort rangeSort a cell range on one or more columns.
• Format rangeSet a range's column width, row height, alignment and text wrapping.
• Auto-fit columnsResize every column in a range to fit its widest cell.
• List tablesList the tables in a workbook, or in a single worksheet.
• Get tableRead a table's name, style and header/total row settings.
• Create tableCreate a table over an existing cell range.
• Update tableRename a table or change its style, header row or totals row.
• Delete tableDelete a table. Its cells and their values stay on the worksheet.
• Get table rangeResolve a table to a range address and values, so the range actions can act on it.
• Convert table to rangeTurn a table back into ordinary cells, keeping the data.
• Sort tableSort a table on one or more of its columns.
• Clear table filtersClear every column filter on a table.
• Reapply table filtersRe-run a table's existing column filters against its current data.
• List table rowsRead the data rows of a table.
• Append table rowsAppend rows to the end of a table.
• Update table rowOverwrite one row of a table.
• Delete table rowDelete one row of a table. Rows below it shift up, so their indexes change.
• List table columnsList a table's columns and their positions.
• Add table columnAdd a column to a table.
• Delete table columnDelete a column from a table.
• List chartsList the charts on a worksheet.
• Add chartAdd a chart over a range of data.
• Update chartRename or resize a chart.
• Set chart dataRepoint an existing chart at a different range.
• Set chart positionAnchor a chart to a cell.
• Get chart imageRender a chart to a base64-encoded PNG.
• Delete chartDelete a chart from a worksheet.
• List named itemsList a workbook's named ranges and named formulas.
• Add named itemDefine a named range or named formula.
• Get named item rangeResolve a named item to its address and current values.
• List pivot tablesList the pivot tables on a worksheet.
• Refresh pivot tableRefresh one pivot table against its current source data.
• Refresh all pivot tablesRefresh every pivot table on a worksheet.

No actions match that.