Sign up
All data sources

Excel

Your account

Microsoft Excel integration for workbook automation and spreadsheet operations

Set up this sourceGet the full contract and schemas as JSONConnect this source →

Sign in with your Excel account. Included on Free.

What you can ask

  • “What does Excel have for the area or asset I'm working on?”
  • “Pull the most recent Excel records and put them in a table.”
  • “What does Excel cover, and how fresh is the data?”

About this source

Microsoft Excel connector for workbook automation via Microsoft Graph. CRITICAL USAGE RULES: 1. Provide itemId (drive item ID for the workbook) for all calls. 2. Use siteId when working with SharePoint-hosted workbooks. 3. For long-running workflows, create a session and pass workbook-session-id on subsequent calls. 4. Range addresses should use Excel A1 notation (e.g., Sheet1!A1:B10).

Connector ID excel

Provenance

PublisherExcel
API basehttps://graph.microsoft.com/

Freshness & coverage

FreshnessFreshness not declared
GeographicNot declared
TemporalNot declared
AuthenticationCredentials required (OAuth)

› Methods (82)

Technical detail for developers: parameters, pagination, units, and freshness per method.

  • excel_get_workbook

    read

    Get the workbook resource for a OneDrive or SharePoint .xlsx item.

    Required paramsitemId
    Paginationnone

  • excel_create_session

    write

    Create a persistent or non-persistent workbook session.

    Required paramsitemId
    Paginationnone

  • excel_close_session

    write

    Close an active workbook session.

    Required paramsitemIdsessionId
    Paginationnone

  • excel_refresh_session

    write

    Refresh an active workbook session so it does not expire.

    Required paramsitemIdsessionId
    Paginationnone

  • excel_list_worksheets

    read

    List worksheets in a workbook.

    Required paramsitemId
    Paginationnone

  • excel_get_worksheet

    read

    Get one worksheet by ID or exact name.

    Required paramsitemIdworksheetIdOrName
    Paginationnone

  • excel_add_worksheet

    write

    Add a worksheet, optionally with a specific name.

    Required paramsitemId
    Paginationnone

  • excel_delete_worksheet

    write

    Delete a worksheet by ID or exact name.

    Required paramsitemIdworksheetId
    Paginationnone

  • excel_get_range

    read

    Read a worksheet range using A1 notation.

    Required paramsitemIdworksheetIdaddress
    Paginationnone

  • excel_get_used_range

    read

    Get the smallest worksheet range containing values or formatting.

    Required paramsitemIdworksheetId
    Paginationnone

  • excel_get_named_range

    read

    Resolve a workbook-scoped defined name to its range.

    Required paramsitemIdname
    Paginationnone

  • excel_update_range

    write

    Write values, formulas, or number formats to a worksheet range.

    Required paramsitemIdworksheetIdaddress
    Paginationnone

  • excel_clear_range

    write

    Clear contents, formats, or both from a worksheet range.

    Required paramsitemIdworksheetIdaddress
    Paginationnone

  • excel_insert_range

    write

    Insert cells at a worksheet range and shift existing cells.

    Required paramsitemIdworksheetIdaddress
    Paginationnone

  • excel_delete_range

    write

    Delete cells from a worksheet range and shift remaining cells.

    Required paramsitemIdworksheetIdaddress
    Paginationnone

  • excel_merge_range

    write

    Merge cells in a worksheet range.

    Required paramsitemIdworksheetIdaddress
    Paginationnone

  • excel_unmerge_range

    write

    Unmerge cells in a worksheet range.

    Required paramsitemIdworksheetIdaddress
    Paginationnone

  • excel_list_tables

    read

    List tables in a workbook.

    Required paramsitemId
    Paginationnone

  • excel_get_table

    read

    Get one table by ID or exact name.

    Required paramsitemIdtableIdOrName
    Paginationnone

  • excel_add_table

    write

    Create a table from a workbook or worksheet range.

    Required paramsitemIdaddress
    Paginationnone

  • excel_delete_table

    write

    Delete a table while preserving its underlying cell data.

    Required paramsitemIdtableId
    Paginationnone

  • excel_convert_table_to_range

    write

    Convert a table to a normal range while preserving data.

    Required paramsitemIdtableId
    Paginationnone

  • excel_list_table_rows

    read

    List rows in a table.

    Required paramsitemIdtableId
    Paginationnone

  • excel_add_table_rows

    write

    Add one or more rows to a table.

    Required paramsitemIdtableIdvalues
    Paginationnone

  • excel_delete_table_row

    write

    Delete a table row by its zero-based row index.

    Required paramsitemIdtableIdrowIndex
    Paginationnone

  • excel_list_table_columns

    read

    List columns in a table.

    Required paramsitemIdtableId
    Paginationnone

  • excel_add_table_column

    write

    Add a column to a table.

    Required paramsitemIdtableId
    Paginationnone

  • excel_delete_table_column

    write

    Delete a table column by ID or exact name.

    Required paramsitemIdtableIdcolumnId
    Paginationnone

  • excel_list_charts

    read

    List charts on a worksheet.

    Required paramsitemIdworksheetIdOrName
    Paginationnone

  • excel_get_chart

    read

    Get one chart by worksheet and chart name.

    Required paramsitemIdworksheetIdchartName
    Paginationnone

  • excel_add_chart

    write

    Create a chart from source data on a worksheet.

    Required paramsitemIdworksheetIdtypesourceData
    Paginationnone

  • excel_delete_chart

    write

    Delete a chart without deleting its source data.

    Required paramsitemIdworksheetIdchartName
    Paginationnone

  • excel_set_chart_position

    write

    Move and resize a chart between worksheet cells.

    Required paramsitemIdworksheetIdchartName
    Paginationnone

  • excel_list_pivot_tables

    read

    List PivotTables on a worksheet.

    Required paramsitemIdworksheetIdOrName
    Paginationnone

  • excel_get_pivot_table

    read

    Get one PivotTable by worksheet and name.

    Required paramsitemIdworksheetIdpivotName
    Paginationnone

  • excel_refresh_pivot_table

    write

    Refresh one PivotTable.

    Required paramsitemIdworksheetIdpivotName
    Paginationnone

  • excel_refresh_all_pivot_tables

    write

    Refresh all PivotTables on a worksheet.

    Required paramsitemIdworksheetIdOrName
    Paginationnone

  • excel_list_names

    read

    List workbook-scoped defined names.

    Required paramsitemId
    Paginationnone

  • excel_get_name

    read

    Get one workbook-scoped defined name.

    Required paramsitemIdname
    Paginationnone

  • excel_add_name

    write

    Add a workbook-scoped defined name.

    Required paramsitemIdnamereference
    Paginationnone

  • excel_delete_name

    write

    Delete a workbook-scoped defined name.

    Required paramsitemIdname
    Paginationnone

  • excel_call_function

    read

    Evaluate an Excel workbook function without modifying cells.

    Required paramsitemIdfunctionName
    Paginationnone

  • excel_list_comments

    read

    List comments in a workbook.

    Required paramsitemId
    Paginationnone

  • excel_get_comment

    read

    Get one workbook comment by ID.

    Required paramsitemIdcommentId
    Paginationnone

  • excel_protect_worksheet

    write

    Protect a worksheet with optional allowed-operation settings.

    Required paramsitemIdworksheetId
    Paginationnone

  • excel_unprotect_worksheet

    write

    Remove protection from a worksheet.

    Required paramsitemIdworksheetId
    Paginationnone

  • excel_get_worksheet_protection

    read

    Get worksheet protection state and allowed-operation settings.

    Required paramsitemIdworksheetIdOrName
    Paginationnone

  • excel_get_application

    read

    Get workbook calculation-mode information.

    Required paramsitemId
    Paginationnone

  • excel_calculate_application

    write

    Recalculate workbook formulas.

    Required paramsitemId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tablerowoperationresult

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tableRowOperationResult operation. This function is the last in a series of steps to create a workbookTableRow resource asynchronously. A best practice to create multiple table rows is to batch them in one create tableRow operation and carry out the operation asynchronously. An asynchronous request to create table rows involves the following steps: 1. Issue an async Create tableRow request and get the query URL returned in the Location response header. 2. Use the query URL returned from step 1 to issue the Get workbookOperation request and get the operation ID for step 3. Alternatively, for convenience, after you get a succeeded operationStatus result, you can get the query URL from the resourceLocation property of the workbookOperation returned in the response, and apply the query URL to step 3. 3. Use the query URL returned from step 2 as the GET request URL for this function tableRowOperationResult. A successful function call returns the new table rows in a workbookTableRow resource. This function doesn't do anything if called independently.

    Required paramsdriveIddriveItemIdkey
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_columns_itemat

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.columns.itemAt operation. Gets a column based on its position in the collection.

    Required paramsdriveIddriveItemIdworkbookTableIdindex
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_columns_workbooktablecolumn_databodyrange

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.columns.workbookTableColumn.dataBodyRange operation. Gets the range object associated with the data body of the column.

    Required paramsdriveIddriveItemIdworkbookTableIdworkbookTableColumnId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_columns_workbooktablecolumn_headerrowrange

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.columns.workbookTableColumn.headerRowRange operation. Gets the range object associated with the header row of the column.

    Required paramsdriveIddriveItemIdworkbookTableIdworkbookTableColumnId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_columns_workbooktablecolumn_range

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.columns.workbookTableColumn.range operation. Gets the range object associated with the entire column.

    Required paramsdriveIddriveItemIdworkbookTableIdworkbookTableColumnId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_columns_workbooktablecolumn_totalrowrange

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.columns.workbookTableColumn.totalRowRange operation. Gets the range object associated with the totals row of the column.

    Required paramsdriveIddriveItemIdworkbookTableIdworkbookTableColumnId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_databodyrange

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.dataBodyRange operation. Gets the range object associated with the data body of the table.

    Required paramsdriveIddriveItemIdworkbookTableId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_headerrowrange

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.headerRowRange operation. Gets the range object associated with header row of the table.

    Required paramsdriveIddriveItemIdworkbookTableId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_range

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.range operation. Get the range object associated with the entire table.

    Required paramsdriveIddriveItemIdworkbookTableId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_rows_itemat

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.rows.itemAt operation. Gets a row based on its position in the collection.

    Required paramsdriveIddriveItemIdworkbookTableIdindex
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_totalrowrange

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.totalRowRange operation. Gets the range object associated with totals row of the table.

    Required paramsdriveIddriveItemIdworkbookTableId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_cell

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.cell operation. Gets the range object containing the single cell based on row and column numbers. The cell can be outside the bounds of its parent range, so long as it's stays within the worksheet grid.

    Required paramsdriveIddriveItemIdworkbookWorksheetIdrowcolumn
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_charts_itemat

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.charts.itemAt operation. Gets a chart based on its position in the collection.

    Required paramsdriveIddriveItemIdworkbookWorksheetIdindex
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_charts_workbookchart_series_itemat

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.charts.workbookChart.series.itemAt operation. Retrieves a series based on its position in the collection

    Required paramsdriveIddriveItemIdworkbookWorksheetIdworkbookChartIdindex
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_charts_workbookchart_series_workbookchartseries_points_itemat

    read

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.charts.workbookChart.series.workbookChartSeries.points.itemAt operation. Retrieve a point based on its position within the series.

    Required paramsdriveIddriveItemIdworkbookWorksheetIdworkbookChartIdworkbookChartSeriesIdindex
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_clearfilters

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.clearFilters operation. Clears all the filters currently applied on the table.

    Required paramsdriveIddriveItemIdworkbookTableId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_columns_workbooktablecolumn_filter_apply

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.columns.workbookTableColumn.filter.apply operation. Apply the given filter criteria on the given column.

    Required paramsdriveIddriveItemIdworkbookTableIdworkbookTableColumnIdbody
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_columns_workbooktablecolumn_filter_clear

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.columns.workbookTableColumn.filter.clear operation. Clear the filter on the given column.

    Required paramsdriveIddriveItemIdworkbookTableIdworkbookTableColumnId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_reapplyfilters

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.reapplyFilters operation. Reapplies all the filters currently on the table.

    Required paramsdriveIddriveItemIdworkbookTableId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_sort_apply

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.sort.apply operation. Perform a sort operation.

    Required paramsdriveIddriveItemIdworkbookTableIdbody
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_sort_clear

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.sort.clear operation. Clears the sorting that is currently on the table. While this doesn't modify the table's ordering, it clears the state of the header buttons.

    Required paramsdriveIddriveItemIdworkbookTableId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_tables_workbooktable_sort_reapply

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.tables.workbookTable.sort.reapply operation. Reapplies the current sorting parameters to the table.

    Required paramsdriveIddriveItemIdworkbookTableId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_charts_workbookchart_axes_categoryaxis_format_line_clear

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.charts.workbookChart.axes.categoryAxis.format.line.clear operation. Clear the line format of a chart element.

    Required paramsdriveIddriveItemIdworkbookWorksheetIdworkbookChartId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_charts_workbookchart_axes_seriesaxis_format_line_clear

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.charts.workbookChart.axes.seriesAxis.format.line.clear operation. Clear the line format of a chart element.

    Required paramsdriveIddriveItemIdworkbookWorksheetIdworkbookChartId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_charts_workbookchart_axes_seriesaxis_majorgridlines_format_line_clear

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.charts.workbookChart.axes.seriesAxis.majorGridlines.format.line.clear operation. Clear the line format of a chart element.

    Required paramsdriveIddriveItemIdworkbookWorksheetIdworkbookChartId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_charts_workbookchart_format_fill_clear

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.charts.workbookChart.format.fill.clear operation. Clear the fill color of a chart element.

    Required paramsdriveIddriveItemIdworkbookWorksheetIdworkbookChartId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_charts_workbookchart_format_fill_setsolidcolor

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.charts.workbookChart.format.fill.setSolidColor operation. Sets the fill formatting of a chart element to a uniform color.

    Required paramsdriveIddriveItemIdworkbookWorksheetIdworkbookChartIdbody
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_charts_workbookchart_legend_format_fill_clear

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.charts.workbookChart.legend.format.fill.clear operation. Clear the fill color of a chart element.

    Required paramsdriveIddriveItemIdworkbookWorksheetIdworkbookChartId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_charts_workbookchart_legend_format_fill_setsolidcolor

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.charts.workbookChart.legend.format.fill.setSolidColor operation. Sets the fill formatting of a chart element to a uniform color.

    Required paramsdriveIddriveItemIdworkbookWorksheetIdworkbookChartIdbody
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_charts_workbookchart_setdata

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.charts.workbookChart.setData operation. Resets the source data for the chart.

    Required paramsdriveIddriveItemIdworkbookWorksheetIdworkbookChartIdbody
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_charts_workbookchart_title_format_fill_clear

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.charts.workbookChart.title.format.fill.clear operation. Clear the fill color of a chart element.

    Required paramsdriveIddriveItemIdworkbookWorksheetIdworkbookChartId
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_charts_workbookchart_title_format_fill_setsolidcolor

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.charts.workbookChart.title.format.fill.setSolidColor operation. Sets the fill formatting of a chart element to a uniform color.

    Required paramsdriveIddriveItemIdworkbookWorksheetIdworkbookChartIdbody
    Paginationnone

  • graph_drives_drive_items_driveitem_workbook_worksheets_workbookworksheet_names_add

    write

    Official Microsoft Graph drives.drive.items.driveItem.workbook.worksheets.workbookWorksheet.names.add operation. Adds a new name to the collection of the given scope using the user's locale for the formula.

    Required paramsdriveIddriveItemIdworkbookWorksheetIdbody
    Paginationnone