All integrations
Microsoft Excel
SpreadsheetsMicrosoft
Manage and edit Excel workbooks stored in OneDrive or SharePoint.
58 actions
Actions
Steps your workflow can run in 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.
Connect in a few clicks
Authenticate once and every action and trigger for the app is ready to drop into a workflow. No glue code, no maintenance.
Automate across your stack
Chain apps together with triggers, actions, and logic that move data between your tools automatically, so work happens without you.
Secure by default
Credentials are encrypted and scoped per workspace. Connect the tools your team already trusts with confidence.
Automate Microsoft Excel with Lodol.
Connect Microsoft Excel and build your first workflow in minutes. No credit card required.
Free plan available · No credit card required