rocketkind
Productivity

Microsoft Excel

Microsoft Excel here means Excel workbooks (.xlsx files) stored in OneDrive, read and written in place through the Microsoft Graph workbook API — no download, no re-upload.

Authentication

  • OAuth 2.0

Actions

Generic API request. Call any Microsoft Graph endpoint on this connection, for the case where no shipped action covers it yet — charts, formatting, sorting, workbook functions, or a workbook outside the signed-in user's own OneDrive. The connection supplies the base URL, the authentication and the egress route, so only the path, query…

  • Add table rowsAppend one or more rows to an Excel table — the standard way to log records into a spreadsheet, since the table grows to fit and nothing needs to know where it ends.
  • Add worksheetAdd a new, empty worksheet (tab) at the end of a workbook — for example a tab per month before writing that month's figures into it.
  • Clear rangeDestructiveEmpty a block of cells at a known A1 address — its values, its formatting, or both — without deleting the cells or shifting anything around them.
  • Create tableTurn a block of cells into an Excel table, so it can then be read and appended to row by row.
  • Get rangeRead a block of cells at a known A1 address on one worksheet.
  • Get used rangeRead everything on one worksheet without knowing its size: the used range is the smallest block that covers every cell holding a value or formatting.
  • List named itemsList the defined names of a workbook (Formulas > Name Manager) — labels such as TaxRate or SalesData that stand for a range, a constant or a formula.
  • List table columnsList the columns of one Excel table in order, with their header names.
  • List table rowsRead the data rows of one Excel table, header row excluded, in table order.
  • List tablesList the Excel tables (structured ranges with a header row, created with Insert > Table) across every worksheet of a workbook.
  • List workbooksFind Excel workbooks (.xlsx files) in the signed-in user's OneDrive, so a file name can be turned into the itemId every other Microsoft Excel action is keyed by.
  • List worksheetsList the worksheets (tabs) of one workbook in their tab order.
  • Update rangeDestructiveWrite cell values into a block at a known A1 address, overwriting what is there.

Product names, logos and brands are the property of their respective owners and are used here for identification only. Their use does not imply endorsement by, or affiliation with, those owners.