NAiOS IconNAiOS Logo
Contacto
Volver al catálogo

Excel

excel

Microsoft 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

SpreadsheetsWeb del proveedor
Acciones
49
Triggers
0
Autenticación
—
OAuth gestionado
Sí
Información técnica: el detalle de parámetros, schemas y triggers de esta página está pensado para equipos de integración. Si solo necesitas saber si tu herramienta favorita está disponible, basta con ver la lista de acciones.

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ón

Add a chart to a worksheet using microsoft graph api.

Parámetros de entrada

  • typestringObligatorio

    The type of chart to add (e.g., 'ColumnClustered').

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • seriesbystringObligatorio

    How the series are by (e.g., 'Auto').

  • worksheetstringObligatorio

    The name or ID of the worksheet (must be URL-encoded if using ID).

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

  • sourcedatastringObligatorio

    The range of source data for the chart (e.g., 'A1:C4').

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Add SharePoint WorksheetEXCEL_ADD_SHAREPOINT_WORKSHEETAcción

Add a new worksheet to a sharepoint excel workbook using microsoft graph sites api.

Parámetros de entrada

  • namestringObligatorio

    The name of the new worksheet to add.

  • item_idstringObligatorio

    The ID of the Excel file (drive item) to add a worksheet to.

  • site_idstringObligatorio

    The ID of the SharePoint site containing the Excel file.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Add TableEXCEL_ADD_TABLEAcción

Create a table in a workbook using microsoft graph api.

Parámetros de entrada

  • namestringObligatorio

    The name of the new table.

  • stylestringObligatorio

    The style of the table.

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the table.

  • table_idstringObligatorio

    The ID of the table to add to.

  • hasHeadersbooleanObligatorio

    Whether the table has headers.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

  • showTotalsbooleanObligatorio

    Whether the table shows totals.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Add Table ColumnEXCEL_ADD_TABLE_COLUMNAcción

Add a column to a table using microsoft graph api.

Parámetros de entrada

  • indexintegerObligatorio

    The index at which to insert the column.

  • valuesarray[]Obligatorio

    The values for the new column.

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the table.

  • table_idstringObligatorio

    The ID of the table to add a column to.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Add Table RowEXCEL_ADD_TABLE_ROWAcción

Add a row to a table using microsoft graph api.

Parámetros de entrada

  • indexinteger

    The index at which to insert the row. Null to append.

  • valuesarray[]Obligatorio

    The values for the new row.

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the table.

  • table_idstringObligatorio

    The ID of the table to add a row to.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Add Workbook PermissionEXCEL_ADD_WORKBOOK_PERMISSIONAcción

Tool 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[]Obligatorio

    Roles to grant: read or write.

  • item_idstringObligatorio

    The ID of the drive item (Excel file) to share.

  • messagestring

    Plain-text message included in the invitation (max 2000 characters).

  • passwordstring

    Password for the invite (OneDrive Personal only).

  • recipientsobject[]Obligatorio

    Collection of recipients to grant access and send the invitation.

  • requireSignInboolean

    If true, recipients must sign in to view the shared item.

  • sendInvitationboolean

    If true, sends an email invitation; otherwise grants permission silently.

  • expirationDateTimestringdate-time

    DateTime when the granted permission will expire (ISO 8601).

  • retainInheritedPermissionsboolean

    If true, existing inherited permissions remain; if false, existing permissions are removed on first share.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Add WorksheetEXCEL_ADD_WORKSHEETAcción

Add a new worksheet to an excel workbook using microsoft graph api.

Parámetros de entrada

  • namestringObligatorio

    The name of the new worksheet to add.

  • item_idstringObligatorio

    The ID of the Excel file (drive item) to add a worksheet to.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Apply Table FilterEXCEL_APPLY_TABLE_FILTERAcción

Apply a filter to a table column using microsoft graph api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • criteriaobjectObligatorio

    The filter criteria as a dictionary.

  • table_idstringObligatorio

    The ID of the table.

  • column_idstringObligatorio

    The ID of the column to filter.

  • worksheetstringObligatorio

    The name or ID of the worksheet (must be URL-encoded if using ID).

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Apply Table SortEXCEL_APPLY_TABLE_SORTAcción

Apply a sort to a table using microsoft graph api.

Parámetros de entrada

  • fieldsobject[]Obligatorio

    List of sort fields (e.g., [{ 'key': 0, 'ascending': true }]).

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • table_idstringObligatorio

    The ID of the table to sort.

  • worksheetstringObligatorio

    The name or ID of the worksheet (must be URL-encoded if using ID).

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Clear RangeEXCEL_CLEAR_RANGEAcción

Tool 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

  • addressstringObligatorio

    The A1-style address of the range to clear (e.g., 'A1:B2').

  • applyTostringenum

    Optional. The type of clear action. Possible values: All, Formats, Contents.

    AllFormatsContents
  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • session_idstring

    Optional. The workbook session ID for persistent changes.

  • worksheet_idstringObligatorio

    The name or ID of the worksheet (URL-encoded if necessary).

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Clear Table FilterEXCEL_CLEAR_TABLE_FILTERAcción

Clear a filter from a table column using microsoft graph api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • table_idstringObligatorio

    The ID of the table.

  • column_idstringObligatorio

    The ID of the column to clear filter from.

  • worksheetstringObligatorio

    The name or ID of the worksheet (must be URL-encoded if using ID).

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Close Excel SessionEXCEL_CLOSE_SESSIONAcción

Tool 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_idstringObligatorio

    The ID of the Excel file (drive item) to close the session for.

  • session_idstringObligatorio

    The workbook session ID to close.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Convert Table To RangeEXCEL_CONVERT_TABLE_TO_RANGEAcción

Convert a table to a range using microsoft graph api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the table.

  • table_idstringObligatorio

    The ID of the table to convert to a range.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Create WorkbookEXCEL_CREATE_WORKBOOKAcción

Tool to create a new workbook file at a specified drive path. use when uploading a new .xlsx file to onedrive.

Parámetros de entrada

  • pathstringObligatorio

    Path including folder structure and file name, ending with .xlsx, e.g., 'Documents/newWorkbook.xlsx'

  • contentstringObligatoriobinary

    Binary contents of the .xlsx file to upload.

  • drive_idstring

    ID of the drive (use 'me' for the user's default drive)

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Delete Table ColumnEXCEL_DELETE_TABLE_COLUMNAcción

Delete a column from a table using microsoft graph api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the table.

  • table_idstringObligatorio

    The ID of the table to delete a column from.

  • column_idstringObligatorio

    The ID of the column to delete.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Delete Table RowEXCEL_DELETE_TABLE_ROWAcción

Delete a row from a table using microsoft graph api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the table.

  • table_idstringObligatorio

    The ID of the table to delete a row from.

  • row_indexintegerObligatorio

    The index of the row to delete.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Delete WorksheetEXCEL_DELETE_WORKSHEETAcción

Tool 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_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • worksheetstringObligatorio

    The name or ID of the worksheet to delete. If using ID, it must be URL-encoded.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Chart AxisEXCEL_GET_CHART_AXISAcción

Tool 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

  • expandstring

    OData $expand query option to expand related entities (format).

  • selectstring

    OData $select query option to specify which properties to return.

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the workbook.

  • axis_typestringObligatorioenum

    The type of axis to retrieve. Allowed values: 'valueAxis', 'seriesAxis', 'categoryAxis'.

    valueAxisseriesAxiscategoryAxis
  • worksheetstringObligatorio

    The name or ID of the worksheet (must be URL-encoded if using ID).

  • chart_namestringObligatorio

    The name or ID of the chart (must be URL-encoded).

  • session_idstring

    Optional workbook session ID. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Chart Data LabelsEXCEL_GET_CHART_DATA_LABELSAcción

Tool 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_idstringObligatorio

    The ID of the Excel file (drive item) containing the workbook.

  • chart_idstringObligatorio

    The ID or name of the chart (must be URL-encoded if using special characters).

  • session_idstring

    Optional workbook session ID. If provided, will be sent in the headers to maintain session state.

  • worksheet_idstringObligatorio

    The ID or name of the worksheet (must be URL-encoded if using special characters).

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Chart LegendEXCEL_GET_CHART_LEGENDAcción

Tool 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

  • expandstring

    OData $expand query option to expand related entities, such as format.

  • selectstring

    OData $select query option to specify which properties to return (comma-separated).

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the workbook.

  • chart_namestringObligatorio

    The name or ID of the chart (URL-encoded if necessary).

  • session_idstring

    Optional workbook session ID. If provided, will be sent in the headers to maintain session state.

  • worksheet_idstringObligatorio

    The ID or name of the worksheet (URL-encoded if necessary).

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get RangeEXCEL_GET_RANGEAcción

Get a range from a worksheet using microsoft graph api.

Parámetros de entrada

  • addressstringObligatorio

    The address of the range (e.g., 'A1:B2').

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

  • worksheet_idstringObligatorio

    The ID of the worksheet.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Create Excel SessionEXCEL_GET_SESSIONAcción

Create a session for an excel workbook using microsoft graph api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) to create a session for.

  • persist_changesboolean

    Whether changes should be persisted after the session. If false, a nonpersistent session is created.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get SharePoint RangeEXCEL_GET_SHAREPOINT_RANGEAcción

Get a range from a worksheet in sharepoint using microsoft graph sites api.

Parámetros de entrada

  • addressstringObligatorio

    The address of the range (e.g., 'A1:B2').

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • site_idstringObligatorio

    The ID of the SharePoint site containing the Excel file.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

  • worksheet_idstringObligatorio

    The ID of the worksheet.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get SharePoint WorksheetEXCEL_GET_SHAREPOINT_WORKSHEETAcción

Get a worksheet by name or id from a sharepoint excel workbook using microsoft graph sites api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) to get the worksheet from.

  • site_idstringObligatorio

    The ID of the SharePoint site containing the Excel file.

  • worksheetstringObligatorio

    The name or ID of the worksheet to retrieve. If using ID, it must be URL-encoded.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Table ColumnEXCEL_GET_TABLE_COLUMNAcción

Tool 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_idstringObligatorio

    The ID of the Excel file (drive item) containing the table.

  • table_idstringObligatorio

    The ID or name of the table containing the column.

  • column_idstringObligatorio

    The ID or name of the column to retrieve.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get workbookEXCEL_GET_WORKBOOKAcción

Tool 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_idstringObligatorio

    ID of the drive item (Excel file) to retrieve.

  • drive_idstringObligatorio

    ID of the drive (use 'me' for the user's default drive).

  • session_idstring

    Optional workbook session ID. If provided, will be sent in headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get WorksheetEXCEL_GET_WORKSHEETAcción

Get a worksheet by name or id from an excel workbook using microsoft graph api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) to get the worksheet from.

  • worksheetstringObligatorio

    The name or ID of the worksheet to retrieve. If using ID, it must be URL-encoded.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Insert RangeEXCEL_INSERT_RANGEAcción

Tool 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

  • shiftstringObligatorioenum

    Direction to shift cells to make space: 'Down' or 'Right'.

    DownRight
  • addressstringObligatorio

    The address of the range (e.g., 'A1:B2').

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • session_idstring

    Optional workbook session ID. If provided, changes persist in that session.

  • worksheet_idstringObligatorio

    The ID or name of the worksheet.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List ChartsEXCEL_LIST_CHARTSAcción

List charts in a worksheet using microsoft graph api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • worksheetstringObligatorio

    The name or ID of the worksheet (must be URL-encoded if using ID).

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List Chart SeriesEXCEL_LIST_CHART_SERIESAcción

Tool to list all data series in a chart. use when you need to enumerate chart series for further analysis.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • worksheetstringObligatorio

    The name or ID of the worksheet (must be URL-encoded if using ID).

  • chart_namestringObligatorio

    The name or ID of the chart (must be URL-encoded).

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List CommentsEXCEL_LIST_COMMENTSAcción

Tool 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_idstringObligatorio

    The ID of the Excel file (drive item) to list comments for.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List Drive FilesEXCEL_LIST_FILESAcción

List files and folders in a drive root or specified path.

Parámetros de entrada

  • pathstring

    Optional folder path under root to list. E.g., 'Documents'

  • drive_idstring

    ID of the drive (use 'me' for the user's default drive)

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List Named ItemsEXCEL_LIST_NAMED_ITEMSAcción

List named items in a workbook using microsoft graph api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the workbook.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List SharePoint TablesEXCEL_LIST_SHAREPOINT_TABLESAcción

List tables in a sharepoint worksheet using microsoft graph sites api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • site_idstringObligatorio

    The ID of the SharePoint site containing the Excel file.

  • worksheetstringObligatorio

    The name or ID of the worksheet (must be URL-encoded if using ID).

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List SharePoint WorksheetsEXCEL_LIST_SHAREPOINT_WORKSHEETSAcción

List worksheets in an excel workbook stored in sharepoint using microsoft graph sites api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) to list worksheets for.

  • site_idstringObligatorio

    The ID of the SharePoint site containing the Excel file.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List Table ColumnsEXCEL_LIST_TABLE_COLUMNSAcción

List columns in a table using microsoft graph api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the table.

  • table_idstringObligatorio

    The ID of the table to list columns from.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List Table RowsEXCEL_LIST_TABLE_ROWSAcción

List rows in a table using microsoft graph api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the table.

  • table_idstringObligatorio

    The ID of the table to list rows from.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List TablesEXCEL_LIST_TABLESAcción

List tables in a worksheet using microsoft graph api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • worksheetstringObligatorio

    The name or ID of the worksheet (must be URL-encoded if using ID).

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List Workbook PermissionsEXCEL_LIST_WORKBOOK_PERMISSIONSAcción

Tool 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

  • $topinteger

    Maximum number of permission objects to return.

  • $skipinteger

    Number of permission objects to skip.

  • $expandstring

    Comma-separated list of related entities to expand.

  • $selectstring

    Comma-separated list of permission properties to include in the response.

  • item_idstringObligatorio

    The ID of the DriveItem representing the workbook.

  • drive_idstringObligatorio

    The ID of the drive containing the workbook file.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

List WorksheetsEXCEL_LIST_WORKSHEETSAcción

List worksheets in an excel workbook using microsoft graph api.

Parámetros de entrada

  • item_idstringObligatorio

    The ID of the Excel file (drive item) to list worksheets for.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Merge CellsEXCEL_MERGE_CELLSAcción

Merge cells in a worksheet range using microsoft graph api.

Parámetros de entrada

  • rangestringObligatorio

    The A1-style address of the range to merge (e.g., 'A1:B2').

  • acrossboolean

    Optional. Set true to merge cells in each row of the specified range as separate merged cells. The default value is false.

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • worksheetstringObligatorio

    The name or ID of the worksheet containing the range to merge.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Protect WorksheetEXCEL_PROTECT_WORKSHEETAcción

Tool 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_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • optionsobject

    Sheet protection options. If omitted, default protection is applied.

  • worksheetstringObligatorio

    The name or ID of the worksheet to protect. If using ID, it must be URL-encoded.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Sort RangeEXCEL_SORT_RANGEAcción

Sort a range in a worksheet using microsoft graph api.

Parámetros de entrada

  • fieldsobject[]Obligatorio

    List of sort fields (e.g., [{ 'key': 0, 'ascending': true }]).

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • worksheetstringObligatorio

    The name or ID of the worksheet (must be URL-encoded if using ID).

  • range_typestringObligatorio

    The type of range to sort (e.g., 'usedRange').

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Update ChartEXCEL_UPDATE_CHARTAcción

Update a chart in a worksheet using microsoft graph api.

Parámetros de entrada

  • topnumber

    The new top position for the chart.

  • leftnumber

    The new left position for the chart.

  • namestring

    The new name for the chart.

  • widthnumber

    The new width for the chart.

  • heightnumber

    The new height for the chart.

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • chart_idstringObligatorio

    The ID of the chart (must be URL-encoded).

  • worksheetstringObligatorio

    The name or ID of the worksheet (must be URL-encoded if using ID).

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Update Chart LegendEXCEL_UPDATE_CHART_LEGENDAcción

Tool 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_idstringObligatorio

    The ID of the Excel file (drive item) containing the workbook.

  • overlayboolean

    Set to true to make the legend overlap the chart body, or false otherwise.

  • visibleboolean

    Set to true to show the chart legend, or false to hide it.

  • chart_idstringObligatorio

    The name or ID of the chart (must be URL-encoded).

  • positionstringenum

    The position of the legend on the chart. Possible values: Top, Bottom, Left, Right, Corner, Custom.

    TopBottomLeftRightCornerCustom
  • worksheetstringObligatorio

    The name or ID of the worksheet (must be URL-encoded if using ID).

  • session_idstring

    Optional workbook session ID. If provided, will be sent in the 'workbook-session-id' header.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Update RangeEXCEL_UPDATE_RANGEAcción

Update a range in a worksheet using microsoft graph api.

Parámetros de entrada

  • valuesarray[]Obligatorio

    The values to update in the range.

  • addressstringObligatorio

    The address of the range (e.g., 'A1:B2').

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

  • worksheet_idstringObligatorio

    The ID of the worksheet.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Update SharePoint RangeEXCEL_UPDATE_SHAREPOINT_RANGEAcción

Update a range in a sharepoint worksheet using microsoft graph sites api.

Parámetros de entrada

  • valuesarray[]Obligatorio

    The values to update in the range.

  • addressstringObligatorio

    The address of the range (e.g., 'A1:B2').

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • site_idstringObligatorio

    The ID of the SharePoint site containing the Excel file.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

  • worksheet_idstringObligatorio

    The ID of the worksheet.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Update TableEXCEL_UPDATE_TABLEAcción

Update a table in a workbook using microsoft graph api.

Parámetros de entrada

  • namestring

    The new name for the table.

  • stylestring

    The style of the table.

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the table.

  • table_idstringObligatorio

    The ID of the table to update.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

  • showTotalsboolean

    Whether the table shows totals.

  • showHeadersboolean

    Whether the table shows headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Update WorksheetEXCEL_UPDATE_WORKSHEETAcción

Update worksheet properties (name, position) in an excel workbook using microsoft graph api.

Parámetros de entrada

  • namestring

    The new name for the worksheet.

  • item_idstringObligatorio

    The ID of the Excel file (drive item) containing the worksheet.

  • positioninteger

    The new position for the worksheet.

  • worksheetstringObligatorio

    The name or ID of the worksheet to update. If using ID, it must be URL-encoded.

  • session_idstring

    Optional session ID for the workbook. If provided, will be sent in the headers.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not