Excel
excelMicrosoft Excel is a powerful spreadsheet application for data analysis, calculations, and visualization, enabling users to organize and process data with formulas, charts, and pivot tables
Acciones disponibles (49)
Cada acción es una operación que el agente puede ejecutar contra este conector. Haz clic en una acción para ver sus parámetros.
Add ChartEXCEL_ADD_CHARTAcciónAdd a chart to a worksheet using microsoft graph api.
EXCEL_ADD_CHARTAcciónAdd a chart to a worksheet using microsoft graph api.
Parámetros de entrada
typestringObligatorioThe type of chart to add (e.g., 'ColumnClustered').
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
seriesbystringObligatorioHow the series are by (e.g., 'Auto').
worksheetstringObligatorioThe name or ID of the worksheet (must be URL-encoded if using ID).
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
sourcedatastringObligatorioThe range of source data for the chart (e.g., 'A1:C4').
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Add SharePoint WorksheetEXCEL_ADD_SHAREPOINT_WORKSHEETAcciónAdd a new worksheet to a sharepoint excel workbook using microsoft graph sites api.
EXCEL_ADD_SHAREPOINT_WORKSHEETAcciónAdd a new worksheet to a sharepoint excel workbook using microsoft graph sites api.
Parámetros de entrada
namestringObligatorioThe name of the new worksheet to add.
item_idstringObligatorioThe ID of the Excel file (drive item) to add a worksheet to.
site_idstringObligatorioThe ID of the SharePoint site containing the Excel file.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Add TableEXCEL_ADD_TABLEAcciónCreate a table in a workbook using microsoft graph api.
EXCEL_ADD_TABLEAcciónCreate a table in a workbook using microsoft graph api.
Parámetros de entrada
namestringObligatorioThe name of the new table.
stylestringObligatorioThe style of the table.
item_idstringObligatorioThe ID of the Excel file (drive item) containing the table.
table_idstringObligatorioThe ID of the table to add to.
hasHeadersbooleanObligatorioWhether the table has headers.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
showTotalsbooleanObligatorioWhether the table shows totals.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Add Table ColumnEXCEL_ADD_TABLE_COLUMNAcciónAdd a column to a table using microsoft graph api.
EXCEL_ADD_TABLE_COLUMNAcciónAdd a column to a table using microsoft graph api.
Parámetros de entrada
indexintegerObligatorioThe index at which to insert the column.
valuesarray[]ObligatorioThe values for the new column.
item_idstringObligatorioThe ID of the Excel file (drive item) containing the table.
table_idstringObligatorioThe ID of the table to add a column to.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Add Table RowEXCEL_ADD_TABLE_ROWAcciónAdd a row to a table using microsoft graph api.
EXCEL_ADD_TABLE_ROWAcciónAdd a row to a table using microsoft graph api.
Parámetros de entrada
indexintegerThe index at which to insert the row. Null to append.
valuesarray[]ObligatorioThe values for the new row.
item_idstringObligatorioThe ID of the Excel file (drive item) containing the table.
table_idstringObligatorioThe ID of the table to add a row to.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Add Workbook PermissionEXCEL_ADD_WORKBOOK_PERMISSIONAcciónTool to grant access to a workbook via invite. use when you need to share a specific workbook file with designated recipients and roles.
EXCEL_ADD_WORKBOOK_PERMISSIONAcciónTool to grant access to a workbook via invite. use when you need to share a specific workbook file with designated recipients and roles.
Parámetros de entrada
rolesstring[]ObligatorioRoles to grant: read or write.
item_idstringObligatorioThe ID of the drive item (Excel file) to share.
messagestringPlain-text message included in the invitation (max 2000 characters).
passwordstringPassword for the invite (OneDrive Personal only).
recipientsobject[]ObligatorioCollection of recipients to grant access and send the invitation.
requireSignInbooleanIf true, recipients must sign in to view the shared item.
sendInvitationbooleanIf true, sends an email invitation; otherwise grants permission silently.
expirationDateTimestringdate-timeDateTime when the granted permission will expire (ISO 8601).
retainInheritedPermissionsbooleanIf true, existing inherited permissions remain; if false, existing permissions are removed on first share.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Add WorksheetEXCEL_ADD_WORKSHEETAcciónAdd a new worksheet to an excel workbook using microsoft graph api.
EXCEL_ADD_WORKSHEETAcciónAdd a new worksheet to an excel workbook using microsoft graph api.
Parámetros de entrada
namestringObligatorioThe name of the new worksheet to add.
item_idstringObligatorioThe ID of the Excel file (drive item) to add a worksheet to.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Apply Table FilterEXCEL_APPLY_TABLE_FILTERAcciónApply a filter to a table column using microsoft graph api.
EXCEL_APPLY_TABLE_FILTERAcciónApply a filter to a table column using microsoft graph api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
criteriaobjectObligatorioThe filter criteria as a dictionary.
table_idstringObligatorioThe ID of the table.
column_idstringObligatorioThe ID of the column to filter.
worksheetstringObligatorioThe name or ID of the worksheet (must be URL-encoded if using ID).
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Apply Table SortEXCEL_APPLY_TABLE_SORTAcciónApply a sort to a table using microsoft graph api.
EXCEL_APPLY_TABLE_SORTAcciónApply a sort to a table using microsoft graph api.
Parámetros de entrada
fieldsobject[]ObligatorioList of sort fields (e.g., [{ 'key': 0, 'ascending': true }]).
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
table_idstringObligatorioThe ID of the table to sort.
worksheetstringObligatorioThe name or ID of the worksheet (must be URL-encoded if using ID).
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Clear RangeEXCEL_CLEAR_RANGEAcciónTool to clear values, formats, or contents in a specified worksheet range. use when you need to reset cells before adding new data.
EXCEL_CLEAR_RANGEAcciónTool to clear values, formats, or contents in a specified worksheet range. use when you need to reset cells before adding new data.
Parámetros de entrada
addressstringObligatorioThe A1-style address of the range to clear (e.g., 'A1:B2').
applyTostringenumOptional. The type of clear action. Possible values: All, Formats, Contents.
AllFormatsContentsitem_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
session_idstringOptional. The workbook session ID for persistent changes.
worksheet_idstringObligatorioThe name or ID of the worksheet (URL-encoded if necessary).
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Clear Table FilterEXCEL_CLEAR_TABLE_FILTERAcciónClear a filter from a table column using microsoft graph api.
EXCEL_CLEAR_TABLE_FILTERAcciónClear a filter from a table column using microsoft graph api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
table_idstringObligatorioThe ID of the table.
column_idstringObligatorioThe ID of the column to clear filter from.
worksheetstringObligatorioThe name or ID of the worksheet (must be URL-encoded if using ID).
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Close Excel SessionEXCEL_CLOSE_SESSIONAcciónTool to close an existing excel workbook session. use when you need to explicitly end a persistent session to release workbook locks.
EXCEL_CLOSE_SESSIONAcciónTool to close an existing excel workbook session. use when you need to explicitly end a persistent session to release workbook locks.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) to close the session for.
session_idstringObligatorioThe workbook session ID to close.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Convert Table To RangeEXCEL_CONVERT_TABLE_TO_RANGEAcciónConvert a table to a range using microsoft graph api.
EXCEL_CONVERT_TABLE_TO_RANGEAcciónConvert a table to a range using microsoft graph api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the table.
table_idstringObligatorioThe ID of the table to convert to a range.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Create WorkbookEXCEL_CREATE_WORKBOOKAcciónTool to create a new workbook file at a specified drive path. use when uploading a new .xlsx file to onedrive.
EXCEL_CREATE_WORKBOOKAcciónTool to create a new workbook file at a specified drive path. use when uploading a new .xlsx file to onedrive.
Parámetros de entrada
pathstringObligatorioPath including folder structure and file name, ending with .xlsx, e.g., 'Documents/newWorkbook.xlsx'
contentstringObligatoriobinaryBinary contents of the .xlsx file to upload.
drive_idstringID of the drive (use 'me' for the user's default drive)
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Delete Table ColumnEXCEL_DELETE_TABLE_COLUMNAcciónDelete a column from a table using microsoft graph api.
EXCEL_DELETE_TABLE_COLUMNAcciónDelete a column from a table using microsoft graph api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the table.
table_idstringObligatorioThe ID of the table to delete a column from.
column_idstringObligatorioThe ID of the column to delete.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Delete Table RowEXCEL_DELETE_TABLE_ROWAcciónDelete a row from a table using microsoft graph api.
EXCEL_DELETE_TABLE_ROWAcciónDelete a row from a table using microsoft graph api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the table.
table_idstringObligatorioThe ID of the table to delete a row from.
row_indexintegerObligatorioThe index of the row to delete.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Delete WorksheetEXCEL_DELETE_WORKSHEETAcciónTool to delete a worksheet from the workbook. use when cleaning up unused or temporary sheets after verifying no dependencies exist. example: "delete 'sheet2' after review."
EXCEL_DELETE_WORKSHEETAcciónTool to delete a worksheet from the workbook. use when cleaning up unused or temporary sheets after verifying no dependencies exist. example: "delete 'sheet2' after review."
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
worksheetstringObligatorioThe name or ID of the worksheet to delete. If using ID, it must be URL-encoded.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get Chart AxisEXCEL_GET_CHART_AXISAcciónTool to retrieve a specific axis from a chart. use when you need properties like min, max, interval, and formatting of the chart axis.
EXCEL_GET_CHART_AXISAcciónTool to retrieve a specific axis from a chart. use when you need properties like min, max, interval, and formatting of the chart axis.
Parámetros de entrada
expandstringOData $expand query option to expand related entities (format).
selectstringOData $select query option to specify which properties to return.
item_idstringObligatorioThe ID of the Excel file (drive item) containing the workbook.
axis_typestringObligatorioenumThe type of axis to retrieve. Allowed values: 'valueAxis', 'seriesAxis', 'categoryAxis'.
valueAxisseriesAxiscategoryAxisworksheetstringObligatorioThe name or ID of the worksheet (must be URL-encoded if using ID).
chart_namestringObligatorioThe name or ID of the chart (must be URL-encoded).
session_idstringOptional workbook session ID. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get Chart Data LabelsEXCEL_GET_CHART_DATA_LABELSAcciónTool to retrieve the data labels object of a chart. use when you need to inspect label settings like position, separator, and visibility flags after creating or updating a chart.
EXCEL_GET_CHART_DATA_LABELSAcciónTool to retrieve the data labels object of a chart. use when you need to inspect label settings like position, separator, and visibility flags after creating or updating a chart.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the workbook.
chart_idstringObligatorioThe ID or name of the chart (must be URL-encoded if using special characters).
session_idstringOptional workbook session ID. If provided, will be sent in the headers to maintain session state.
worksheet_idstringObligatorioThe ID or name of the worksheet (must be URL-encoded if using special characters).
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get Chart LegendEXCEL_GET_CHART_LEGENDAcciónTool to retrieve the legend object of a chart. use after creating or updating a chart when you need to inspect legend visibility and formatting.
EXCEL_GET_CHART_LEGENDAcciónTool to retrieve the legend object of a chart. use after creating or updating a chart when you need to inspect legend visibility and formatting.
Parámetros de entrada
expandstringOData $expand query option to expand related entities, such as format.
selectstringOData $select query option to specify which properties to return (comma-separated).
item_idstringObligatorioThe ID of the Excel file (drive item) containing the workbook.
chart_namestringObligatorioThe name or ID of the chart (URL-encoded if necessary).
session_idstringOptional workbook session ID. If provided, will be sent in the headers to maintain session state.
worksheet_idstringObligatorioThe ID or name of the worksheet (URL-encoded if necessary).
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get RangeEXCEL_GET_RANGEAcciónGet a range from a worksheet using microsoft graph api.
EXCEL_GET_RANGEAcciónGet a range from a worksheet using microsoft graph api.
Parámetros de entrada
addressstringObligatorioThe address of the range (e.g., 'A1:B2').
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
worksheet_idstringObligatorioThe ID of the worksheet.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Create Excel SessionEXCEL_GET_SESSIONAcciónCreate a session for an excel workbook using microsoft graph api.
EXCEL_GET_SESSIONAcciónCreate a session for an excel workbook using microsoft graph api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) to create a session for.
persist_changesbooleanWhether changes should be persisted after the session. If false, a nonpersistent session is created.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get SharePoint RangeEXCEL_GET_SHAREPOINT_RANGEAcciónGet a range from a worksheet in sharepoint using microsoft graph sites api.
EXCEL_GET_SHAREPOINT_RANGEAcciónGet a range from a worksheet in sharepoint using microsoft graph sites api.
Parámetros de entrada
addressstringObligatorioThe address of the range (e.g., 'A1:B2').
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
site_idstringObligatorioThe ID of the SharePoint site containing the Excel file.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
worksheet_idstringObligatorioThe ID of the worksheet.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get SharePoint WorksheetEXCEL_GET_SHAREPOINT_WORKSHEETAcciónGet a worksheet by name or id from a sharepoint excel workbook using microsoft graph sites api.
EXCEL_GET_SHAREPOINT_WORKSHEETAcciónGet a worksheet by name or id from a sharepoint excel workbook using microsoft graph sites api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) to get the worksheet from.
site_idstringObligatorioThe ID of the SharePoint site containing the Excel file.
worksheetstringObligatorioThe name or ID of the worksheet to retrieve. If using ID, it must be URL-encoded.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get Table ColumnEXCEL_GET_TABLE_COLUMNAcciónTool to retrieve a specific column from a workbook table. use when you need to fetch column properties and data by its id or name.
EXCEL_GET_TABLE_COLUMNAcciónTool to retrieve a specific column from a workbook table. use when you need to fetch column properties and data by its id or name.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the table.
table_idstringObligatorioThe ID or name of the table containing the column.
column_idstringObligatorioThe ID or name of the column to retrieve.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get workbookEXCEL_GET_WORKBOOKAcciónTool to retrieve the properties and relationships of a workbook. use when you need to inspect comments, names, tables, or worksheets.
EXCEL_GET_WORKBOOKAcciónTool to retrieve the properties and relationships of a workbook. use when you need to inspect comments, names, tables, or worksheets.
Parámetros de entrada
expandstring[]OData relationships to expand in the response.
item_idstringObligatorioID of the drive item (Excel file) to retrieve.
drive_idstringObligatorioID of the drive (use 'me' for the user's default drive).
session_idstringOptional workbook session ID. If provided, will be sent in headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get WorksheetEXCEL_GET_WORKSHEETAcciónGet a worksheet by name or id from an excel workbook using microsoft graph api.
EXCEL_GET_WORKSHEETAcciónGet a worksheet by name or id from an excel workbook using microsoft graph api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) to get the worksheet from.
worksheetstringObligatorioThe name or ID of the worksheet to retrieve. If using ID, it must be URL-encoded.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Insert RangeEXCEL_INSERT_RANGEAcciónTool to insert a new cell range into a worksheet, shifting existing cells down or right. use when you need to create space for new content without overwriting.
EXCEL_INSERT_RANGEAcciónTool to insert a new cell range into a worksheet, shifting existing cells down or right. use when you need to create space for new content without overwriting.
Parámetros de entrada
shiftstringObligatorioenumDirection to shift cells to make space: 'Down' or 'Right'.
DownRightaddressstringObligatorioThe address of the range (e.g., 'A1:B2').
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
session_idstringOptional workbook session ID. If provided, changes persist in that session.
worksheet_idstringObligatorioThe ID or name of the worksheet.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
List ChartsEXCEL_LIST_CHARTSAcciónList charts in a worksheet using microsoft graph api.
EXCEL_LIST_CHARTSAcciónList charts in a worksheet using microsoft graph api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
worksheetstringObligatorioThe name or ID of the worksheet (must be URL-encoded if using ID).
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
List Chart SeriesEXCEL_LIST_CHART_SERIESAcciónTool to list all data series in a chart. use when you need to enumerate chart series for further analysis.
EXCEL_LIST_CHART_SERIESAcciónTool to list all data series in a chart. use when you need to enumerate chart series for further analysis.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
worksheetstringObligatorioThe name or ID of the worksheet (must be URL-encoded if using ID).
chart_namestringObligatorioThe name or ID of the chart (must be URL-encoded).
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
List CommentsEXCEL_LIST_COMMENTSAcciónTool to list comments in an excel workbook. use when you need to retrieve all workbook comments via microsoft graph api.
EXCEL_LIST_COMMENTSAcciónTool to list comments in an excel workbook. use when you need to retrieve all workbook comments via microsoft graph api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) to list comments for.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
List Drive FilesEXCEL_LIST_FILESAcciónList files and folders in a drive root or specified path.
EXCEL_LIST_FILESAcciónList files and folders in a drive root or specified path.
Parámetros de entrada
pathstringOptional folder path under root to list. E.g., 'Documents'
drive_idstringID of the drive (use 'me' for the user's default drive)
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
List Named ItemsEXCEL_LIST_NAMED_ITEMSAcciónList named items in a workbook using microsoft graph api.
EXCEL_LIST_NAMED_ITEMSAcciónList named items in a workbook using microsoft graph api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the workbook.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
List SharePoint TablesEXCEL_LIST_SHAREPOINT_TABLESAcciónList tables in a sharepoint worksheet using microsoft graph sites api.
EXCEL_LIST_SHAREPOINT_TABLESAcciónList tables in a sharepoint worksheet using microsoft graph sites api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
site_idstringObligatorioThe ID of the SharePoint site containing the Excel file.
worksheetstringObligatorioThe name or ID of the worksheet (must be URL-encoded if using ID).
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
List SharePoint WorksheetsEXCEL_LIST_SHAREPOINT_WORKSHEETSAcciónList worksheets in an excel workbook stored in sharepoint using microsoft graph sites api.
EXCEL_LIST_SHAREPOINT_WORKSHEETSAcciónList worksheets in an excel workbook stored in sharepoint using microsoft graph sites api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) to list worksheets for.
site_idstringObligatorioThe ID of the SharePoint site containing the Excel file.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
List Table ColumnsEXCEL_LIST_TABLE_COLUMNSAcciónList columns in a table using microsoft graph api.
EXCEL_LIST_TABLE_COLUMNSAcciónList columns in a table using microsoft graph api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the table.
table_idstringObligatorioThe ID of the table to list columns from.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
List Table RowsEXCEL_LIST_TABLE_ROWSAcciónList rows in a table using microsoft graph api.
EXCEL_LIST_TABLE_ROWSAcciónList rows in a table using microsoft graph api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the table.
table_idstringObligatorioThe ID of the table to list rows from.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
List TablesEXCEL_LIST_TABLESAcciónList tables in a worksheet using microsoft graph api.
EXCEL_LIST_TABLESAcciónList tables in a worksheet using microsoft graph api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
worksheetstringObligatorioThe name or ID of the worksheet (must be URL-encoded if using ID).
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
List Workbook PermissionsEXCEL_LIST_WORKBOOK_PERMISSIONSAcciónTool to list permissions set on the workbook file. use when you need to see which users or links have access to a specific excel file by supplying its drive and item ids. example: "list permissions for workbook with drive id 'b!abc123' and item id '0123456789abcdef'."
EXCEL_LIST_WORKBOOK_PERMISSIONSAcciónTool to list permissions set on the workbook file. use when you need to see which users or links have access to a specific excel file by supplying its drive and item ids. example: "list permissions for workbook with drive id 'b!abc123' and item id '0123456789abcdef'."
Parámetros de entrada
$topintegerMaximum number of permission objects to return.
$skipintegerNumber of permission objects to skip.
$expandstringComma-separated list of related entities to expand.
$selectstringComma-separated list of permission properties to include in the response.
item_idstringObligatorioThe ID of the DriveItem representing the workbook.
drive_idstringObligatorioThe ID of the drive containing the workbook file.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
List WorksheetsEXCEL_LIST_WORKSHEETSAcciónList worksheets in an excel workbook using microsoft graph api.
EXCEL_LIST_WORKSHEETSAcciónList worksheets in an excel workbook using microsoft graph api.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) to list worksheets for.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Merge CellsEXCEL_MERGE_CELLSAcciónMerge cells in a worksheet range using microsoft graph api.
EXCEL_MERGE_CELLSAcciónMerge cells in a worksheet range using microsoft graph api.
Parámetros de entrada
rangestringObligatorioThe A1-style address of the range to merge (e.g., 'A1:B2').
acrossbooleanOptional. Set true to merge cells in each row of the specified range as separate merged cells. The default value is false.
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
worksheetstringObligatorioThe name or ID of the worksheet containing the range to merge.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Protect WorksheetEXCEL_PROTECT_WORKSHEETAcciónTool to protect a worksheet using optional protection options. use when you need to prevent editing certain parts of a sheet before sharing. example: "protect 'sheet1' to lock formatting and sorting."
EXCEL_PROTECT_WORKSHEETAcciónTool to protect a worksheet using optional protection options. use when you need to prevent editing certain parts of a sheet before sharing. example: "protect 'sheet1' to lock formatting and sorting."
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
optionsobjectSheet protection options. If omitted, default protection is applied.
worksheetstringObligatorioThe name or ID of the worksheet to protect. If using ID, it must be URL-encoded.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Sort RangeEXCEL_SORT_RANGEAcciónSort a range in a worksheet using microsoft graph api.
EXCEL_SORT_RANGEAcciónSort a range in a worksheet using microsoft graph api.
Parámetros de entrada
fieldsobject[]ObligatorioList of sort fields (e.g., [{ 'key': 0, 'ascending': true }]).
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
worksheetstringObligatorioThe name or ID of the worksheet (must be URL-encoded if using ID).
range_typestringObligatorioThe type of range to sort (e.g., 'usedRange').
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Update ChartEXCEL_UPDATE_CHARTAcciónUpdate a chart in a worksheet using microsoft graph api.
EXCEL_UPDATE_CHARTAcciónUpdate a chart in a worksheet using microsoft graph api.
Parámetros de entrada
topnumberThe new top position for the chart.
leftnumberThe new left position for the chart.
namestringThe new name for the chart.
widthnumberThe new width for the chart.
heightnumberThe new height for the chart.
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
chart_idstringObligatorioThe ID of the chart (must be URL-encoded).
worksheetstringObligatorioThe name or ID of the worksheet (must be URL-encoded if using ID).
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Update Chart LegendEXCEL_UPDATE_CHART_LEGENDAcciónTool to update formatting or position of a chart legend. use when adjusting legend settings after confirming chart and worksheet exist.
EXCEL_UPDATE_CHART_LEGENDAcciónTool to update formatting or position of a chart legend. use when adjusting legend settings after confirming chart and worksheet exist.
Parámetros de entrada
item_idstringObligatorioThe ID of the Excel file (drive item) containing the workbook.
overlaybooleanSet to true to make the legend overlap the chart body, or false otherwise.
visiblebooleanSet to true to show the chart legend, or false to hide it.
chart_idstringObligatorioThe name or ID of the chart (must be URL-encoded).
positionstringenumThe position of the legend on the chart. Possible values: Top, Bottom, Left, Right, Corner, Custom.
TopBottomLeftRightCornerCustomworksheetstringObligatorioThe name or ID of the worksheet (must be URL-encoded if using ID).
session_idstringOptional workbook session ID. If provided, will be sent in the 'workbook-session-id' header.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Update RangeEXCEL_UPDATE_RANGEAcciónUpdate a range in a worksheet using microsoft graph api.
EXCEL_UPDATE_RANGEAcciónUpdate a range in a worksheet using microsoft graph api.
Parámetros de entrada
valuesarray[]ObligatorioThe values to update in the range.
addressstringObligatorioThe address of the range (e.g., 'A1:B2').
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
worksheet_idstringObligatorioThe ID of the worksheet.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Update SharePoint RangeEXCEL_UPDATE_SHAREPOINT_RANGEAcciónUpdate a range in a sharepoint worksheet using microsoft graph sites api.
EXCEL_UPDATE_SHAREPOINT_RANGEAcciónUpdate a range in a sharepoint worksheet using microsoft graph sites api.
Parámetros de entrada
valuesarray[]ObligatorioThe values to update in the range.
addressstringObligatorioThe address of the range (e.g., 'A1:B2').
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
site_idstringObligatorioThe ID of the SharePoint site containing the Excel file.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
worksheet_idstringObligatorioThe ID of the worksheet.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Update TableEXCEL_UPDATE_TABLEAcciónUpdate a table in a workbook using microsoft graph api.
EXCEL_UPDATE_TABLEAcciónUpdate a table in a workbook using microsoft graph api.
Parámetros de entrada
namestringThe new name for the table.
stylestringThe style of the table.
item_idstringObligatorioThe ID of the Excel file (drive item) containing the table.
table_idstringObligatorioThe ID of the table to update.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
showTotalsbooleanWhether the table shows totals.
showHeadersbooleanWhether the table shows headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Update WorksheetEXCEL_UPDATE_WORKSHEETAcciónUpdate worksheet properties (name, position) in an excel workbook using microsoft graph api.
EXCEL_UPDATE_WORKSHEETAcciónUpdate worksheet properties (name, position) in an excel workbook using microsoft graph api.
Parámetros de entrada
namestringThe new name for the worksheet.
item_idstringObligatorioThe ID of the Excel file (drive item) containing the worksheet.
positionintegerThe new position for the worksheet.
worksheetstringObligatorioThe name or ID of the worksheet to update. If using ID, it must be URL-encoded.
session_idstringOptional session ID for the workbook. If provided, will be sent in the headers.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not