Skip to main content
Excel logo
  • Category: spreadsheets
  • Auth: OAUTH2, S2S_OAUTH2
  • Composio-managed OAuth available? Yes
  • Tools: 125
  • Triggers: 0
  • Slug: EXCEL
  • Version: 20261103_00

Tools

Slug: EXCEL_ADD_CHARTAdd a chart to a worksheet using Microsoft Graph API.

Input Parameters

string
required
The type of chart to add (e.g., ‘ColumnClustered’).
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
Optional drive ID. If not provided, uses ‘me/drive’ (requires delegated auth). For application auth (s2s_oauth), provide the drive ID.
string
required
How the series are by (e.g., ‘Auto’).
string
required
The name or ID of the worksheet (must be URL-encoded if using ID).
string
Optional session ID for the workbook. If provided, will be sent in the headers.
string
required
The range of source data for the chart (e.g., ‘A1:C4’).

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_ADD_NAMED_ITEMAdd a workbook- or worksheet-scoped named item using an invariant reference or a local formula.

Input Parameters

string
required
The new named item’s name.
string
Optional comment associated with the name.
string
Locale-specific formula; required in local mode.
string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
Invariant formula or range reference; required in invariant mode.
string
Optional worksheet ID or name for worksheet scope.
string
Optional workbook session ID.
string ("invariant" | "local")
Select invariant to require reference, or local to require formula. The unused expression field must be omitted.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_ADD_SHAREPOINT_WORKSHEETAdd a new worksheet to an Excel workbook in a SharePoint site’s default drive using Microsoft Graph.

Input Parameters

string
required
The name of the new worksheet to add.
string
required
The ID of the Excel file (drive item) to add a worksheet to.
string
required
The ID of the SharePoint site containing the Excel file.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_ADD_TABLECreate a new table in a worksheet using the Microsoft Graph API.

Input Parameters

string
required
The range address for the table. If worksheet is specified, use a range like ‘A1:D4’. If worksheet is omitted, include the sheet name (e.g., ‘Sheet1!A1:D4’).
string
required
The ID of the Excel workbook (drive item) where the table will be created.
string
Optional drive ID. Required for application-level permissions (s2s_oauth). If not provided, uses /me/drive endpoint for delegated auth. Use EXCEL_LIST_FILES or ONE_DRIVE_GET_DRIVE_ROOT to get the drive ID.
string
Worksheet name or ID. When provided, the table is created on this worksheet and the address should be a range like ‘A1:D4’. When omitted, the table is created at the workbook level and the address must include the sheet name prefix (e.g., ‘Sheet1!A1:D4’).
boolean
required
Whether the first row of the range contains column headers (True) or not (False).
string
Workbook session ID controlling persistence.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_ADD_TABLE_COLUMNAdd a column to a table using Microsoft Graph API.

Input Parameters

integer
required
The index at which to insert the column.
array
required
The values for the new column. MUST include exactly one value for each row in the table, including the header row. Use list table rows to get the correct number of values needed.
string
required
The ID of the Excel file (drive item) containing the table.
string
The ID of the drive containing the Excel file. If not provided, defaults to ‘me’ for delegated auth or must be provided for application-only auth.
string
required
The ID of the table to add a column to.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_ADD_TABLE_ROWAdd a row to a table using Microsoft Graph API.

Input Parameters

integer
The 0-based index at which to insert the row. Use null or omit to append to the end (recommended).
array
required
A 2D array of values for the new row(s). Each inner array represents one row and MUST have the same number of elements as the table has columns. Use List Table Columns action to verify the table structure first.
string
required
The ID of the Excel file (drive item) containing the table.
string
The ID of the drive containing the Excel file. Use ‘me’ for the user’s default OneDrive (delegated auth), or provide a specific drive ID for SharePoint sites or when using application permissions.
string
required
The ID of the table to add a row to.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_ADD_WORKBOOK_PERMISSIONTool to grant access to a workbook via invite. Use when you need to share a specific workbook file with designated recipients and roles.

Input Parameters

array
required
Roles to grant: read or write.
string
required
The ID of the drive item (Excel file) to share.
string
Plain-text message included in the invitation (max 2000 characters).
string
The ID of the SharePoint site containing the Excel file. Required for application-level auth when the file is not in the root site.
string
The ID of the document library (drive) containing the Excel file. If not provided, the site’s default drive is used.
string
Password for the invite (OneDrive Personal only).
array
required
Collection of recipients to grant access and send the invitation.
boolean
If true, recipients must sign in to view the shared item.
boolean
If true, sends an email invitation; otherwise grants permission silently.
string
DateTime when the granted permission will expire (ISO 8601).
boolean
If true, existing inherited permissions remain; if false, existing permissions are removed on first share.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_ADD_WORKSHEETAdd a new worksheet to an Excel workbook using Microsoft Graph API.

Input Parameters

string
required
The name of the new worksheet to add.
string
required
The ID of the Excel file (drive item) to add a worksheet to.
string
The ID of the drive containing the Excel file. If not provided, will attempt to use ‘me’ for delegated permissions.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_APPLY_TABLE_FILTERApply a filter to a table column using Microsoft Graph API.

Input Parameters

string
required
The ID of the Excel file (drive item) containing the worksheet.
object
required
The filter criteria as a dictionary.
string
The ID of the drive containing the Excel file. Use ‘me’ for the user’s default OneDrive, or provide a specific drive ID for SharePoint sites or app-only auth.
string
required
The ID of the table.
string
required
The ID of the column to filter.
string
required
The name or ID of the worksheet (must be URL-encoded if using ID).
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_APPLY_TABLE_SORTApply a sort to a table using Microsoft Graph API.

Input Parameters

array
required
List of sort fields (e.g., [{ ‘key’: 0, ‘ascending’: true }]).
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
Optional drive ID. Required when using application permissions (not /me). Use the drive ID where the Excel file is located.
string
required
The ID of the table to sort.
string
required
The name or ID of the worksheet (must be URL-encoded if using ID).
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_AUTOFIT_RANGEAutofit columns or rows intersecting a workbook range.

Input Parameters

string
required
The range whose dimensions to fit.
string
required
The Excel workbook drive-item ID.
string
The explicit drive ID; omit for /me/drive.
string ("columns" | "rows")
required
Whether to autofit column widths or row heights.
string
An optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_CALCULATE_FUNCTIONRun one allowlisted Microsoft Graph v1.0 workbook function.

Input Parameters

string
required
The ID of the Excel workbook drive item.
string
Optional drive ID. Omit to use the connected user’s default drive.
object
Arguments keyed by the exact documented Microsoft Graph parameter names for function_name. Values may be any recursively nested JSON value, but numbers must be finite. Unknown keys are rejected. Leave this empty for a zero-argument function; for other functions, only the selected function’s documented keys are sent.
string
Optional workbook session ID to use for this calculation.
string ("abs" | "accrInt" | "accrIntM" | "acos" | "acosh" | "acot" | "acoth" | "amorDegrc" | "amorLinc" | "and" | "arabic" | "areas" | "asc" | "asin" | "asinh" | "atan" | "atan2" | "atanh" | "aveDev" | "average" | "averageA" | "averageIf" | "averageIfs" | "bahtText" | "base" | "besselI" | "besselJ" | "besselK" | "besselY" | "beta_Dist" | "beta_Inv" | "bin2Dec" | "bin2Hex" | "bin2Oct" | "binom_Dist" | "binom_Dist_Range" | "binom_Inv" | "bitand" | "bitlshift" | "bitor" | "bitrshift" | "bitxor" | "ceiling_Math" | "ceiling_Precise" | "char" | "chiSq_Dist" | "chiSq_Dist_RT" | "chiSq_Inv" | "chiSq_Inv_RT" | "choose" | "clean" | "code" | "columns" | "combin" | "combina" | "complex" | "concatenate" | "confidence_Norm" | "confidence_T" | "convert" | "cos" | "cosh" | "cot" | "coth" | "count" | "countA" | "countBlank" | "countIf" | "countIfs" | "coupDayBs" | "coupDays" | "coupDaysNc" | "coupNcd" | "coupNum" | "coupPcd" | "csc" | "csch" | "cumIPmt" | "cumPrinc" | "date" | "datevalue" | "daverage" | "day" | "days" | "days360" | "db" | "dbcs" | "dcount" | "dcountA" | "ddb" | "dec2Bin" | "dec2Hex" | "dec2Oct" | "decimal" | "degrees" | "delta" | "devSq" | "dget" | "disc" | "dmax" | "dmin" | "dollar" | "dollarDe" | "dollarFr" | "dproduct" | "dstDev" | "dstDevP" | "dsum" | "duration" | "dvar" | "dvarP" | "ecma_Ceiling" | "edate" | "effect" | "eoMonth" | "erf" | "erf_Precise" | "erfC" | "erfC_Precise" | "error_Type" | "even" | "exact" | "exp" | "expon_Dist" | "f_Dist" | "f_Dist_RT" | "f_Inv" | "f_Inv_RT" | "fact" | "factDouble" | "false" | "find" | "findB" | "fisher" | "fisherInv" | "fixed" | "floor_Math" | "floor_Precise" | "fv" | "fvschedule" | "gamma" | "gamma_Dist" | "gamma_Inv" | "gammaLn" | "gammaLn_Precise" | "gauss" | "gcd" | "geoMean" | "geStep" | "harMean" | "hex2Bin" | "hex2Dec" | "hex2Oct" | "hlookup" | "hour" | "hyperlink" | "hypGeom_Dist" | "if" | "imAbs" | "imaginary" | "imArgument" | "imConjugate" | "imCos" | "imCosh" | "imCot" | "imCsc" | "imCsch" | "imDiv" | "imExp" | "imLn" | "imLog10" | "imLog2" | "imPower" | "imProduct" | "imReal" | "imSec" | "imSech" | "imSin" | "imSinh" | "imSqrt" | "imSub" | "imSum" | "imTan" | "int" | "intRate" | "ipmt" | "irr" | "isErr" | "isError" | "isEven" | "isFormula" | "isLogical" | "isNA" | "isNonText" | "isNumber" | "iso_Ceiling" | "isOdd" | "isoWeekNum" | "ispmt" | "isref" | "isText" | "kurt" | "large" | "lcm" | "left" | "leftb" | "len" | "lenb" | "ln" | "log" | "log10" | "logNorm_Dist" | "logNorm_Inv" | "lookup" | "lower" | "match" | "max" | "maxA" | "mduration" | "median" | "mid" | "midb" | "min" | "minA" | "minute" | "mirr" | "mod" | "month" | "mround" | "multiNomial" | "n" | "na" | "negBinom_Dist" | "networkDays" | "networkDays_Intl" | "nominal" | "norm_Dist" | "norm_Inv" | "norm_S_Dist" | "norm_S_Inv" | "not" | "now" | "nper" | "npv" | "numberValue" | "oct2Bin" | "oct2Dec" | "oct2Hex" | "odd" | "oddFPrice" | "oddFYield" | "oddLPrice" | "oddLYield" | "or" | "pduration" | "percentile_Exc" | "percentile_Inc" | "percentRank_Exc" | "percentRank_Inc" | "permut" | "permutationa" | "phi" | "pi" | "pmt" | "poisson_Dist" | "power" | "ppmt" | "price" | "priceDisc" | "priceMat" | "product" | "proper" | "pv" | "quartile_Exc" | "quartile_Inc" | "quotient" | "radians" | "rand" | "randBetween" | "rank_Avg" | "rank_Eq" | "rate" | "received" | "replace" | "replaceB" | "rept" | "right" | "rightb" | "roman" | "round" | "roundDown" | "roundUp" | "rows" | "rri" | "sec" | "sech" | "second" | "seriesSum" | "sheet" | "sheets" | "sign" | "sin" | "sinh" | "skew" | "skew_p" | "sln" | "small" | "sqrt" | "sqrtPi" | "standardize" | "stDev_P" | "stDev_S" | "stDevA" | "stDevPA" | "substitute" | "subtotal" | "sum" | "sumIf" | "sumIfs" | "sumSq" | "syd" | "t" | "t_Dist" | "t_Dist_2T" | "t_Dist_RT" | "t_Inv" | "t_Inv_2T" | "tan" | "tanh" | "tbillEq" | "tbillPrice" | "tbillYield" | "text" | "time" | "timevalue" | "today" | "trim" | "trimMean" | "true" | "trunc" | "type" | "unichar" | "unicode" | "upper" | "usdollar" | "value" | "var_P" | "var_S" | "varA" | "varPA" | "vdb" | "vlookup" | "weekday" | "weekNum" | "weibull_Dist" | "workDay" | "workDay_Intl" | "xirr" | "xnpv" | "xor" | "year" | "yearFrac" | "yield" | "yieldDisc" | "yieldMat" | "z_Test")
required
Exact Microsoft Graph v1.0 workbook function name. Only names in the published allowlist are accepted; names are case-sensitive.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_CALCULATE_WORKBOOKCalculate Excel Workbook

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string ("Recalculate" | "Full" | "FullRebuild")
required
The calculation operation to perform.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_CLEAR_RANGETool to clear values, formats, or contents in a specified worksheet range. Use when you need to reset cells before adding new data.

Input Parameters

string
required
The A1-style address of the range to clear (e.g., ‘A1:B2’).
string ("All" | "Formats" | "Contents")
Optional. The type of clear action. Possible values: All, Formats, Contents.
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
Optional. The SharePoint site ID (format: hostname,site-collection-id,site-id). Required when using application permissions (s2s_oauth) with SharePoint files. Not needed for OneDrive files with delegated permissions.
string
Optional drive ID. Required for application-level permissions (s2s_oauth) with OneDrive files. If not provided, falls back to site_id or /me/drive endpoint. Use EXCEL_LIST_FILES or ONE_DRIVE_GET_DRIVE_ROOT to get the drive ID.
string
Optional. The workbook session ID for persistent changes. Must be obtained from EXCEL_GET_SESSION (createSession API) - do not construct manually. Format starts with ‘cluster=’ followed by session data. Invalid or expired sessions will cause API errors.
string
required
The name or ID of the worksheet (URL-encoded if necessary).

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_CLEAR_TABLE_FILTERClear a filter from a table column using Microsoft Graph API.

Input Parameters

string
required
The ID of the Excel file (drive item) containing the worksheet.
string
The ID of the drive containing the Excel file. Use ‘me’ for the user’s default OneDrive, or provide a specific drive ID for SharePoint sites or app-only auth.
string
required
The ID of the table.
string
required
The ID of the column to clear filter from.
string
required
The name or ID of the worksheet (must be URL-encoded if using ID).
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_CLEAR_TABLE_FILTERSClear All Table Filters

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The table ID or exact name.
string
Optional worksheet ID or name.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_CLEAR_TABLE_SORTClear Table Sort

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The table ID or exact name.
string
Optional worksheet ID or name.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_CLOSE_SESSIONTool to close an existing Excel workbook session. Use when you need to explicitly end a persistent session to release workbook locks. Note: The Microsoft Graph closeSession API is idempotent - it returns 204 for both active and already-closed sessions. This action validates the session first and returns an error for invalid or already-closed sessions to provide clearer user feedback. The validation uses refreshSession which is the only API endpoint that can detect closed sessions.

Input Parameters

string
required
The ID of the Excel file (drive item) to close the session for.
string
Optional drive ID. Required for application-level permissions (s2s_oauth). If not provided, uses /me/drive endpoint for delegated auth.
string
required
The workbook session ID to close. Must be a valid session ID format obtained from EXCEL_GET_SESSION.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_CONVERT_TABLE_TO_RANGEConvert a table to a range using Microsoft Graph API.

Input Parameters

string
required
The ID of the Excel file (drive item) containing the table.
string
Optional drive ID. Required for application-level permissions (s2s_oauth). If not provided, uses /me/drive endpoint for delegated auth. Use EXCEL_LIST_FILES or ONE_DRIVE_GET_DRIVE_ROOT to get the drive ID.
string
required
The ID of the table to convert to a range.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_COPY_DRIVE_ITEMCreate a non-destructive asynchronous copy of a file or folder. Metadata and permissions are not copied; the new item inherits destination-folder permissions. Version history is copied only when explicitly requested.

Input Parameters

string
New name for the copied item. Omit when children_only is true.
string
required
Source driveItem ID.
string
required
Drive containing the source item.
boolean
Whether to copy only a folder’s children.
string ("fail" | "rename")
Non-destructive behavior when a destination item has the same name.
string
Destination drive ID. Defaults to the source drive.
string
Destination parent folder ID. Omit to retain the current parent.
boolean
Whether to preserve all available file versions.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_CREATE_COMMENTCreate a plain-text Excel cell comment through Microsoft Graph beta. This beta operation requires a delegated work or school account. Microsoft does not support beta APIs for production applications.

Input Parameters

string
required
The plain-text comment content.
string
required
The ID of the Excel workbook drive item.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
required
The A1-style cell address, including the worksheet, such as Sheet1!A1.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_CREATE_FOLDERCreate a folder under a parent Microsoft Graph drive item.

Input Parameters

string
required
Name of the new folder.
string
required
ID of the drive containing the parent folder.
string
required
Graph API drive item ID of the parent folder.
string ("fail" | "rename")
Non-destructive behavior when an item with the same name exists: fail or rename.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_CREATE_UPLOAD_SESSIONCreate a resumable upload session at a drive-root path.

Input Parameters

string
required
Destination OneDrive or SharePoint drive ID.
string
required
Destination path under the drive root, including the file name.
boolean
Whether the completed upload requires an explicit commit request.
string ("fail" | "replace" | "rename")
Behavior when an item already exists at the destination path.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_CREATE_WORKBOOKTool to create a new Excel workbook file at a specified drive path. Generates a new .xlsx file with specified worksheets and data, then uploads it to OneDrive.

Input Parameters

string
required
Path including folder structure and file name, ending with .xlsx, e.g., ‘Documents/newWorkbook.xlsx’
string
ID of the drive (use ‘me’ for the user’s default drive)
object
Data to populate worksheets. Dict mapping worksheet names to lists of rows (each row is a list of cell values). Example: {‘Sheet1’: [[‘Name’, ‘Points’], [‘LeBron’, 40000], [‘Jordan’, 32292]]}
array
List of worksheet names to create in the workbook. If not provided, a single worksheet named ‘Sheet1’ will be created.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_DELETE_DRIVE_ITEMMove a OneDrive or SharePoint drive item to the recycle bin by item ID.

Input Parameters

array
Optional Microsoft Graph delete preferences. Multiple values are sent as one comma-separated Prefer header.
string
required
Exact Microsoft Graph ID of the drive item to move to the recycle bin.
string
ID of the drive containing the item. Use ‘me’ for the user’s default drive.
string
ETag precondition. The deletion fails if this value does not match the item’s current ETag.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_DELETE_NAMED_ITEMPermanently delete a workbook-scoped named item; this cannot be undone.

Input Parameters

string
required
The exact workbook-scoped named item name to delete.
string
required
The ID of the Excel workbook file (drive item).
string
The explicit drive ID containing the workbook. Omit to use the connected user’s drive.
string
An optional workbook session ID to use for this deletion.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_DELETE_RANGEDelete worksheet cells and shift the remaining cells up or left.

Input Parameters

string ("Up" | "Left")
required
The direction to shift remaining cells after deletion: ‘Up’ or ‘Left’.
string
required
The A1-style address of the range to delete, such as ‘A1:B2’.
string
required
The ID of the Excel workbook file (drive item).
string
The explicit drive ID containing the workbook. Omit to use the connected user’s drive.
string
An optional workbook session ID to use for this deletion.
string
required
The ID or name of the worksheet containing the range.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_DELETE_TABLEPermanently delete an Excel table by its ID or name.

Input Parameters

string
required
The ID of the Excel workbook file (drive item).
string
The explicit drive ID containing the workbook. Omit to use the connected user’s drive.
string
required
The ID or name of the table to delete.
string
An optional workbook session ID to use for this deletion.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_DELETE_TABLE_COLUMNDelete a column from a table using Microsoft Graph API.

Input Parameters

string
required
The ID of the Excel file (drive item) containing the table.
string
The ID of the drive containing the Excel file. If not provided, defaults to ‘me’ for delegated auth or must be provided for application-only auth.
string
required
The ID of the table to delete a column from.
string
required
The ID of the column to delete.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_DELETE_TABLE_ROWDelete a row from a table using Microsoft Graph API.

Input Parameters

string
required
The ID of the Excel file (drive item) containing the table.
string
The ID of the drive containing the Excel file. Use ‘me’ for the user’s default OneDrive, or provide a specific drive ID for SharePoint sites.
string
required
The ID of the table to delete a row from.
integer
required
The index of the row to delete.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_DELETE_WORKSHEETTool 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.”

Input Parameters

string
required
The ID of the Excel file (drive item) containing the worksheet.
string
The ID of the drive containing the Excel file. If not provided, defaults to ‘me’ for delegated auth or must be provided for application-only auth.
string
required
The name or ID of the worksheet to delete. If using ID, it must be URL-encoded.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_DOWNLOAD_WORKBOOKDownload an Excel workbook in its original file format.

Input Parameters

string
required
Graph API item ID of the workbook DriveItem.
string
Optional ID of the drive containing the workbook. If omitted, uses the user’s default drive.
string
Optional ETag or cTag for a conditional download. A matching tag returns not_modified=true without a file.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_EXPORT_WORKBOOK_TO_PDFExport an Excel workbook to PDF using Microsoft Graph format conversion, returning a download URL. Optionally save the converted PDF to a path in the selected drive.

Input Parameters

string
required
ID of the Excel file (DriveItem) to convert to PDF.
string
Required when drive_scope is ‘drives’ or ‘sites’. The drive ID or site ID.
string ("me" | "drives" | "sites")
The drive scope type: ‘me’ for user’s OneDrive, ‘drives’ for specific drive ID, ‘sites’ for SharePoint site.
string
Optional path where the converted PDF should be uploaded back to Drive (e.g., ‘Documents/invoice.pdf’). If provided, the tool downloads the PDF and uploads it to this location.
boolean
If true, only return the preauthenticated download URL. If false, fetch additional metadata about the source item.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_APPLICATIONGet Excel Application

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_CHARTGet chart

Input Parameters

array
Related chart resources to include.
string
required
The ID of the Excel workbook drive item.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
required
The exact worksheet ID or name.
string
The exact chart ID or name. Provide exactly one of chart_name or chart_index.
string
Optional workbook session ID for this request.
integer
The zero-based chart position. Provide exactly one of chart_name or chart_index.
array
Chart properties to return.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_CHART_AXISTool to retrieve a specific axis from a chart. Use when you need properties like min, max, interval, and formatting of the chart axis.

Input Parameters

string
OData $expand query option to expand related entities (format).
string
OData $select query option to specify which properties to return.
string
required
The ID of the Excel file (drive item) containing the workbook.
string
Optional drive ID. If provided, uses /drives/{drive_id}/items/{item_id} endpoint (required for application permissions). If not provided, uses /me/drive/items/{item_id} endpoint (for delegated permissions).
string ("valueAxis" | "seriesAxis" | "categoryAxis")
required
The type of axis to retrieve. Allowed values: ‘valueAxis’, ‘seriesAxis’, ‘categoryAxis’.
string
required
The name or ID of the worksheet (must be URL-encoded if using ID).
string
required
The name or ID of the chart (must be URL-encoded).
string
Optional workbook session ID. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_CHART_COMPONENTRetrieve one Excel chart component: chart title, axis title, supported gridlines, axis font, or supported line format.

Input Parameters

string
required
The ID of the Excel workbook drive item.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
required
The chart component and its component-specific selector settings.
string
required
The exact worksheet ID or name.
string
required
The exact chart ID or name.
string
Optional workbook session ID for this request.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_CHART_DATA_LABELSTool 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.

Input Parameters

string
required
The ID of the Excel file (drive item) containing the workbook.
string
required
The ID or name of the chart (must be URL-encoded if using special characters).
string
Optional drive ID. If not provided, defaults to ‘me’ (user’s default drive).
string
Optional workbook session ID. If provided, will be sent in the headers to maintain session state.
string
required
The ID or name of the worksheet (must be URL-encoded if using special characters).

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_CHART_IMAGERender an Excel chart as a base64-encoded image.

Input Parameters

integer
Desired image width in pixels.
integer
Desired image height in pixels.
string
required
The ID of the Excel workbook drive item.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
required
The exact worksheet ID or name.
string
required
The exact chart ID or name.
string
Optional workbook session ID for this request.
string ("Fit" | "FitAndCenter" | "Fill")
How to fit the chart when both dimensions are provided.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_CHART_LEGENDTool to retrieve the legend object of a chart. Use after creating or updating a chart when you need to inspect legend visibility and formatting.

Input Parameters

string
OData $expand query option to expand related entities, such as format.
string
OData $select query option to specify which properties to return (comma-separated).
string
required
The ID of the Excel file (drive item) containing the workbook.
string
Optional drive ID. Required for application-level permissions (s2s_oauth). If not provided, uses /me/drive endpoint for delegated auth. Use EXCEL_LIST_FILES or ONE_DRIVE_GET_DRIVE_ROOT to get the drive ID.
string
required
The name or ID of the chart (URL-encoded if necessary).
string
Optional workbook session ID. If provided, will be sent in the headers to maintain session state.
string
required
The ID or name of the worksheet (URL-encoded if necessary).

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_CHART_POINTGet chart point

Input Parameters

array
Related point resources to include.
string
required
The ID of the Excel workbook drive item.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
The exact chart point ID. Provide exactly one of point_id or point_index.
string
The exact series ID. Provide exactly one of series_id or series_index.
string
required
The exact worksheet ID or name.
string
required
The exact chart ID or name.
string
Optional workbook session ID for this request.
integer
The zero-based point position. Provide exactly one of point_id or point_index.
integer
The zero-based series position. Provide exactly one of series_id or series_index.
array
Point properties to return.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_CHART_SERIESGet chart series

Input Parameters

array
Related series resources to include.
string
required
The ID of the Excel workbook drive item.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
The exact chart series ID. Provide exactly one of series_id or series_index.
string
required
The exact worksheet ID or name.
string
required
The exact chart ID or name.
string
Optional workbook session ID for this request.
integer
The zero-based series position. Provide exactly one of series_id or series_index.
array
Series properties to return.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_COMMENTRetrieve one workbook comment by its exact ID.

Input Parameters

array
Related comment entities to include through the OData $expand query option.
array
Comment properties to return through the OData $select query option.
string
required
The ID of the Excel workbook drive item.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
required
The exact ID of the workbook comment to retrieve.
string
Optional workbook session ID to use for this request.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_COMMENT_REPLYRetrieve one reply to a workbook comment by its exact ID.

Input Parameters

array
Related reply entities to include through the OData $expand query option.
array
Reply properties to return through the OData $select query option.
string
required
The ID of the Excel workbook drive item.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
required
The exact ID of the comment reply to retrieve.
string
required
The exact ID of the parent workbook comment.
string
Optional workbook session ID to use for this request.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_DERIVED_RANGEReturn a range derived from another range by navigation or geometry.

Input Parameters

integer
Optional signed count for columns_after, columns_before, rows_above, or rows_below. Defaults to 1.
string
required
The source range.
string
required
The Excel workbook drive-item ID.
string
The drive containing the workbook. Omit for the connected user’s default drive.
string ("bounding_rectangle" | "cell" | "column" | "columns_after" | "columns_before" | "entire_column" | "entire_row" | "intersection" | "last_cell" | "last_column" | "last_row" | "offset" | "resize" | "row" | "rows_above" | "rows_below" | "used_range")
required
The range navigation or derivation operation to perform.
integer
The zero-based row index for cell or row.
integer
The signed row-size change for resize.
integer
The signed row offset for offset.
string
An optional workbook session ID.
boolean
For used_range, whether to ignore cells used only by formatting.
integer
The zero-based column index for cell or column.
string
The other range address for bounding_rectangle or intersection.
integer
The signed column offset for offset.
integer
The signed column-size change for resize.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_DRIVE_ITEMRetrieve OneDrive or SharePoint drive item metadata by exact ID or path.

Input Parameters

string
Path relative to the drive root. Provide either path or item_id, but not both.
array
Drive item relationships to include. Values are comma-joined into the $expand query parameter.
array
Drive item fields to return. Values are comma-joined into the $select query parameter.
string
Exact Microsoft Graph drive item ID. Provide either item_id or path, but not both.
string
ID of the drive containing the item. Use ‘me’ for the user’s default drive.
string
ETag or cTag to send in the If-None-Match header. A matching tag returns not_modified=true.
boolean
Whether to return deleted items. Valid only with item_id addressing and supported only by OneDrive Personal.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_NAMED_ITEMRetrieve a workbook-scoped named item by exact name.

Input Parameters

string
required
The exact workbook-scoped name of the named item to retrieve.
string
required
The ID of the Excel file (drive item) containing the named item.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
Optional workbook session ID to use for this request.
array
Named-item properties to return. Omit to return Microsoft Graph’s default properties.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_NAMED_ITEM_RANGERetrieve the Excel range of a range-valued workbook-scoped named item.

Input Parameters

string
required
The exact workbook-scoped named-item name.
string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_OPERATION_STATUSGet the status of an asynchronous Excel workbook operation by its operation ID.

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
Optional workbook session ID.
string
required
The operation ID returned by an asynchronous Excel request.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_PIVOT_TABLEGet Pivot Table

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The worksheet ID or exact name.
string
Optional workbook session ID.
string
required
The pivot table ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_PROJECTED_WORKSHEET_SUBRESOURCERead selected properties from a worksheet range, its used range, or worksheet protection.

Input Parameters

string
required
Workbook drive-item ID.
string
Drive ID; omit for the connected user’s default drive.
string
Optional workbook session ID.
string
required
A constrained range, used-range, or protection selector.
string
required
Worksheet ID or exact name.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_RANGEGet a range from a worksheet using Microsoft Graph API.

Input Parameters

string
required
Valid Excel range address or named range. Cell ranges: A1, A1:B2, A:A, Sheet1!A1:B2. Named ranges: must start with letter/underscore, no spaces (use underscores: Sales_Tax not Sales Tax).
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
Optional drive ID. If provided, uses /drives/{drive_id}/items/{item_id} endpoint (required for application permissions). If not provided, uses /me/drive/items/{item_id} endpoint (for delegated permissions).
string
Optional session ID for the workbook. If provided, will be sent in the headers.
string
required
The ID or name of the worksheet (required, cannot be empty). Provide the sheet name (e.g., ‘Sheet1’) or its unique ID. Use the list worksheets action if you need to find available worksheet names or IDs.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_RANGE_FORMATRead one formatting component from a workbook range.

Input Parameters

string
required
The range whose formatting to read.
string
required
The Excel workbook drive-item ID.
string
The explicit drive ID; omit for /me/drive.
string ("format" | "fill" | "font" | "borders" | "border" | "protection")
required
The formatting component to retrieve.
string
An optional workbook session ID.
string ("EdgeTop" | "EdgeBottom" | "EdgeLeft" | "EdgeRight" | "InsideVertical" | "InsideHorizontal" | "DiagonalDown" | "DiagonalUp")
The border side, required for border.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_SESSIONCreate a session for an Excel workbook using Microsoft Graph API.

Input Parameters

string
required
The OneDrive drive item ID of the Excel file (.xlsx). Drive-item IDs are opaque, immutable identifiers (Microsoft Graph does not document a fixed format). Get a valid item ID from the EXCEL_LIST_FILES action.
string
Optional drive ID. Required for application-level permissions (s2s_oauth). If not provided, uses /me/drive endpoint for delegated auth.
boolean
Whether changes should be persisted after the session. If false, a nonpersistent session is created.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_SHAREPOINT_RANGEGet a range from a worksheet in SharePoint using Microsoft Graph Sites API.

Input Parameters

string
required
The address of the range (e.g., ‘A1:B2’).
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
required
The ID of the SharePoint site containing the Excel file.
string
Optional session ID for the workbook. If provided, will be sent in the headers.
string
required
The ID of the worksheet.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_SHAREPOINT_WORKSHEETGet a worksheet by name or ID from an Excel workbook in a SharePoint site’s default drive using Microsoft Graph.

Input Parameters

string
required
The ID of the Excel file (drive item) to get the worksheet from.
string
required
The ID of the SharePoint site containing the Excel file.
string
required
The name or ID of the worksheet to retrieve. If using ID, it must be URL-encoded.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_TABLERetrieve one workbook- or worksheet-addressed table by ID or exact name.

Input Parameters

array
Related table resources to include in the response.
string
required
The ID of the Excel workbook drive item containing the table.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
required
The ID or exact name of the workbook table to retrieve.
string
Optional worksheet ID or exact name for the worksheet-scoped route.
string
Optional workbook session ID to use for this request.
array
Table properties to return. The action always includes id and name.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_TABLE_COLUMNTool to retrieve a specific column from a workbook table. Use when you need to fetch column properties and data by its ID or name.

Input Parameters

string
required
The ID of the Excel file (drive item) containing the table.
string
Optional SharePoint site ID. Required when using application permissions (s2s_oauth). Format: ‘hostname,spSiteId,spWebId’
string
Optional drive ID. Required for application-level permissions (s2s_oauth) with OneDrive files. If not provided, falls back to site_id or /me/drive endpoint. Use EXCEL_LIST_FILES or ONE_DRIVE_GET_DRIVE_ROOT to get the drive ID.
string
required
The ID or name of the table containing the column.
string
required
The ID or name of the column to retrieve.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_TABLE_COLUMN_CELLRead one cell by row within a selected table column’s data body.

Input Parameters

integer
required
Zero-based row offset within the selected column’s data body.
integer
Column offset within the selected column’s data body; always zero because the data body is a single column.
string
required
The ID of the Excel file (drive item) containing the table.
string
Optional drive ID. When omitted, the connected user’s default drive is used.
string
required
The ID or name of the table containing the column.
string
required
The ID or name of the table column whose data-body range contains the cell.
string
Optional workbook session ID used to keep workbook operations consistent.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_TABLE_COLUMN_RANGEGet Table Column Range

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The table ID or exact name.
string
required
The column ID or exact name.
string
Optional worksheet ID or name.
string ("all" | "data_body" | "header" | "totals")
The part of the column whose range to return.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_TABLE_RANGEGet Table Range

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The table ID or exact name.
string
Optional worksheet ID or name.
string ("all" | "data_body" | "header" | "totals")
The part of the table whose range to return.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_TABLE_ROWGet Table Row

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The table ID or exact name.
integer
required
Zero-based row index.
string
Optional worksheet ID or name.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_TABLE_ROW_RANGEGet Table Row Range

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The table ID or exact name.
integer
required
Zero-based row index.
string
Optional worksheet ID or name.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_TABLE_SORTGet Table Sort

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The table ID or exact name.
string
Optional worksheet ID or name.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_VISIBLE_RANGERead cells visible after worksheet filtering.

Input Parameters

string ("view" | "rows" | "row" | "range")
required
The visible-view result granularity.
string
required
The A1-style source range address.
string
required
The Excel workbook drive-item ID.
string
The explicit drive ID; omit for /me/drive.
integer
The zero-based visible row index, required when result is row.
string
An optional workbook session ID.
string
required
The worksheet ID or name.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_WORKBOOKRetrieve a workbook’s relationships, including comments, named items, operations, tables, and worksheets, with optional relationship expansion.

Input Parameters

array
OData relationships to expand in the response.
string
required
Graph API item ID (e.g., ‘01RWIO2VKO5Q4ECCKUL5BYFHITS5UOQPBH’) or file path (e.g., ‘Budget.xlsx’ or ‘Documents/Budget.xlsx’). Item IDs are opaque alphanumeric strings obtained from list/search operations. If a path is provided (containing .xlsx or /), path-based addressing will be used.
string
required
ID of the drive (use ‘me’ for the user’s default drive).
string
Optional workbook session ID. If provided, will be sent in headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_WORKSHEETGet a worksheet by name or ID from an Excel workbook using Microsoft Graph API.

Input Parameters

string
required
The ID of the Excel file (drive item) to get the worksheet from.
string
The ID of the drive containing the Excel file. Required for SharePoint files or when using app-only authentication. Use ‘me’ for delegated auth with user’s OneDrive, or provide the specific drive ID for SharePoint sites.
string
required
The name or ID of the worksheet to retrieve. If using ID, it must be URL-encoded.
string
Optional workbook session ID. Must be a valid session ID obtained from the EXCEL_GET_SESSION (createSession) action. Do NOT pass arbitrary strings - only use session IDs returned by createSession. If you don’t have a valid session ID, leave this empty.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_WORKSHEET_PROTECTIONGet Worksheet Protection

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The worksheet ID or exact name.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_WORKSHEET_ROW_RANGERead a zero-based worksheet row across the column bounds of the worksheet’s values-only used range.

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
integer
required
Zero-based worksheet row index (0 through 1,048,575).
string
required
The worksheet ID or exact name.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_GET_WORKSHEET_USED_RANGETool to retrieve a worksheet’s used range (active data region) without specifying a fixed range address. Use when you need to read all data from a sheet but don’t know the exact range. The valuesOnly option helps filter out formatting-only cells.

Input Parameters

string
required
The ID of the Excel file (drive item) containing the worksheet.
string
required
The ID of the drive (e.g., ‘me’ for the user’s default OneDrive, or a specific drive ID for SharePoint).
string
Optional workbook session ID. If provided, will be sent in the workbook-session-id header. Must be a valid session ID obtained from the createSession action.
boolean
If true, only returns cells with values (ignores formatting-only cells). Maps to valuesOnly parameter in the API.
string
required
The ID or name of the worksheet. Can be the worksheet name (e.g., ‘Sheet1’) or its unique ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_INSERT_RANGETool 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.

Input Parameters

string ("Down" | "Right")
required
Direction to shift cells to make space: ‘Down’ or ‘Right’.
string
required
The address of the range (e.g., ‘A1:B2’).
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
The ID of the drive containing the Excel file. If not provided, defaults to ‘me’ for delegated auth or must be provided for application-only auth.
string
Optional workbook session ID. If provided, changes persist in that session.
string
required
The ID or name of the worksheet.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_CHART_POINTSList chart points

Input Parameters

integer
Maximum points to return.
integer
Points to skip before returning results.
array
Related point resources to include.
string
required
The ID of the Excel workbook drive item.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
The exact series ID. Provide exactly one of series_id or series_index.
string
required
The exact worksheet ID or name.
string
required
The exact chart ID or name.
string
Optional workbook session ID for this request.
integer
The zero-based series position. Provide exactly one of series_id or series_index.
array
Point properties to return.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_CHARTSList charts in a worksheet using Microsoft Graph API.

Input Parameters

integer
Maximum number of items to return per page (OData $top).
integer
Number of items to skip for pagination (OData $skip).
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
Optional drive ID. Required for application-level permissions (s2s_oauth). If not provided, uses /me/drive endpoint for delegated auth. Use EXCEL_LIST_FILES or ONE_DRIVE_GET_DRIVE_ROOT to get the drive ID.
string
required
The name or ID of the worksheet. Do not include surrounding quotes - provide the plain worksheet name (e.g., ‘Sheet1’ not “‘Sheet1’”).
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_CHART_SERIESList a page of data series names in a chart, with a next-page link when more results are available.

Input Parameters

integer
Maximum number of items to return per page (OData $top).
integer
Number of items to skip for pagination (OData $skip).
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
Optional drive ID. Required for application-level permissions (s2s_oauth). If not provided, uses /me/drive endpoint for delegated auth. Use EXCEL_LIST_FILES or ONE_DRIVE_GET_DRIVE_ROOT to get the drive ID.
string
required
The name or ID of the worksheet (must be URL-encoded if using ID).
string
required
The name or ID of the chart (must be URL-encoded).
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_COMMENT_REPLIESList replies to one workbook comment.

Input Parameters

integer
Maximum number of replies to return in this page.
integer
Number of replies to skip before returning this page.
boolean
Whether Microsoft Graph should include the total reply count.
array
Related reply entities to include through the OData $expand query option.
string
OData $filter expression for reply property values.
Search phrase passed through the OData $search query option.
array
Reply properties to return through the OData $select query option.
string
required
The ID of the Excel workbook drive item.
array
Reply property expressions for the OData $orderby query option.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
required
The exact ID of the workbook comment whose replies to list.
string
Optional workbook session ID to use for this request.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_COMMENTSList a page of comments in an Excel workbook using Microsoft Graph. Returns a next-page link when one is provided.

Input Parameters

integer
Maximum number of items to return per page (OData $top).
integer
Number of items to skip for pagination (OData $skip).
string
required
The ID of the Excel file (drive item) to list comments for.
string
The ID of the drive containing the Excel file. If not provided, will attempt to use ‘me’ for delegated permissions.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_DRIVE_ITEM_CHILDRENTool to list immediate children (files/folders) of a folder DriveItem using driveId and itemId. Returns an array of child DriveItems with stable identifiers and pagination support.

Input Parameters

integer
Maximum number of children to return per page (maps to $top OData query parameter).
string
required
Graph API item ID of the folder DriveItem whose children to enumerate. Must be an opaque alphanumeric identifier obtained from list/search operations or shares resolution.
string
required
ID of the drive containing the folder (use ‘me’ for the user’s default drive).
string
Opaque pagination token from a previous response’s odata_next_link URL ($skiptoken value). Pass this to fetch the next page of results.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_DRIVE_ITEM_VERSIONSList retained versions of a OneDrive or SharePoint workbook file.

Input Parameters

integer
Maximum number of versions to return in one page (maps to $top). Microsoft Graph defines $top as the OData page-size query option: https://learn.microsoft.com/en-us/graph/query-parameters#odata-system-query-options
string
required
Exact Microsoft Graph drive item ID whose retained versions to list.
string
ID of the drive containing the item. Use ‘me’ for the user’s default drive.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_FILESList files and folders in a drive root or specified path.

Input Parameters

integer
Maximum number of items to return per page (maps to $top OData query parameter).
string
Optional folder path under root to list. E.g., ‘Documents’. Must be a folder path, not a file path.
string
ID of the drive (use ‘me’ for the user’s default drive)
string
Opaque pagination token from a previous response’s next_link ($skiptoken value). Pass this to fetch the next page of results.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_NAMED_ITEMSList named items in a workbook using Microsoft Graph. If no session is supplied, the tool creates a nonpersistent workbook session before listing.

Input Parameters

integer
Maximum number of items to return per page (OData $top).
integer
Number of items to skip for pagination (OData $skip).
string
required
The ID of the Excel file (drive item) containing the workbook.
string
Optional drive ID. Required for application-level permissions (s2s_oauth). If not provided, uses /me/drive endpoint for delegated auth. Use EXCEL_LIST_FILES or ONE_DRIVE_GET_DRIVE_ROOT to get the drive ID.
string
Optional session ID for the workbook. If not provided, a new session will be created automatically.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_PIVOT_TABLESList Pivot Tables

Input Parameters

integer
Maximum pivot tables to return.
integer
Number of pivot tables to skip.
string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The worksheet ID or exact name.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_SHAREPOINT_TABLESList tables in a worksheet of an Excel workbook stored in a SharePoint site’s default drive using Microsoft Graph.

Input Parameters

integer
Maximum number of items to return per page (OData $top).
integer
Number of items to skip for pagination (OData $skip).
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
required
The ID of the SharePoint site containing the Excel file.
string
required
The name or ID of the worksheet (must be URL-encoded if using ID).
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_SHAREPOINT_WORKSHEETSList worksheets in an Excel workbook stored in SharePoint using Microsoft Graph Sites API.

Input Parameters

integer
Maximum number of items to return per page (OData $top).
integer
Number of items to skip for pagination (OData $skip).
string
required
The ID of the Excel file (drive item) to list worksheets for.
string
required
The ID of the SharePoint site containing the Excel file.
string
The ID of the document library (drive) containing the Excel file. Required if the file is not in the site’s default document library. If not provided, the site’s default drive is used.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_SITE_LISTSList SharePoint lists in a known Microsoft Graph site. Use site search first when the site ID is unknown. The action exposes projection and page controls but does not automatically follow the returned next link.

Input Parameters

integer
Maximum number of lists to return on this page (maps to the $top query parameter).
string
required
Microsoft Graph site ID whose SharePoint lists should be returned. Use ‘root’ for the tenant root site or an ID returned by site search.
string
Opaque $skiptoken value from a previous response’s odata_next_link URL. Pass it unchanged to retrieve the next page.
array
List properties to return. Omit to use Microsoft Graph’s default projection.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_TABLE_COLUMNSList columns in a table using Microsoft Graph API.

Input Parameters

integer
Maximum number of items to return per page (OData $top).
integer
Number of items to skip for pagination (OData $skip).
string
required
The ID of the Excel file (drive item) containing the table.
string
The ID of the drive containing the item. If not provided, will attempt to use ‘me’ for delegated auth.
string
required
The ID of the table to list columns from.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_TABLE_ROWSList rows in a table using Microsoft Graph API.

Input Parameters

integer
Maximum number of rows to return per page (maps to $top OData query parameter). Microsoft recommends using $top and $skip for large tables.
integer
Number of rows to skip before returning results (maps to $skip OData query parameter). Use with ‘top’ for offset-based pagination.
string
required
The ID of the Excel file (drive item) containing the table.
string
The ID of the drive containing the Excel file. If not provided, will attempt to use ‘me’ for delegated permissions.
string
required
The name or ID of the table (e.g., ‘Table1’, ‘MyTable’). Note: this must be a valid Excel table name/ID, not a worksheet name.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_TABLESList tables in a specified Excel worksheet using Microsoft Graph API. Returns one page of table information and a continuation link when provided; an optional workbook session can be used.

Input Parameters

integer
Maximum number of items to return per page (OData $top).
integer
Number of items to skip for pagination (OData $skip).
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
Optional drive ID. Required for application-level permissions (s2s_oauth). If not provided, uses /me/drive endpoint for delegated auth.
string
required
The name or ID of the worksheet (e.g., ‘Sheet1’, ‘工作表’, or ‘{00000000-0001-0000-0000-000000000000}’). URL encoding is handled automatically.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_WORKBOOK_PERMISSIONSTool 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’.”

Input Parameters

integer
Maximum number of permission objects to return.
integer
Number of permission objects to skip.
string
Comma-separated list of related entities to expand.
string
Comma-separated list of permission properties to include in the response.
string
required
The ID of the DriveItem representing the workbook.
string
required
The ID of the drive containing the workbook file. Use ‘me’ for the current user’s default OneDrive.
string
Opaque pagination token from a previous response’s next_link URL ($skiptoken value). Pass this to fetch the next page of permissions.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_WORKBOOK_TABLESList tables across a workbook without requiring a worksheet identifier.

Input Parameters

integer
Maximum number of tables to return in this page.
integer
Number of tables to skip before this page.
boolean
Whether to include the total table count in the response.
array
Related table resources to include in each result.
string
OData filter expression used to restrict the returned tables.
string
OData search expression used to match workbook tables.
string
required
The drive item ID of the Excel workbook.
string
Optional drive ID. Omit to use the connected user’s default drive.
array
OData expressions used to order tables, such as ‘name asc’.
string
Optional workbook session ID to use for this request.
array
Documented workbook table properties to return.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_LIST_WORKSHEETSList worksheets in an Excel workbook using Microsoft Graph API.

Input Parameters

integer
Maximum number of items to return per page (OData $top).
integer
Number of items to skip for pagination (OData $skip).
string
required
The ID of the Excel file (drive item) to list worksheets for.
string
The ID of the drive containing the Excel file. If not provided, will attempt to use ‘me’ for delegated permissions.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_MERGE_CELLSMerge cells in a worksheet range using Microsoft Graph API.

Input Parameters

string
required
The A1-style address of the range to merge (e.g., ‘A1:B2’).
boolean
Optional. Set true to merge cells in each row of the specified range as separate merged cells. The default value is false.
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
Optional drive ID. If not provided, will use ‘me’ for delegated permissions. Required for application permissions.
string
required
The name or ID of the worksheet containing the range to merge.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_PROTECT_WORKSHEETTool 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.”

Input Parameters

string
required
The ID of the Excel file (drive item) containing the worksheet.
object
Sheet protection options. If omitted, default protection is applied.
string
The ID of the drive containing the Excel file. If not provided, will attempt to use ‘me’ for delegated permissions.
string
required
The name or ID of the worksheet to protect. If using ID, it must be URL-encoded.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_REAPPLY_TABLE_FILTERSReapply All Table Filters

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The table ID or exact name.
string
Optional worksheet ID or name.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_REAPPLY_TABLE_SORTReapply Table Sort

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The table ID or exact name.
string
Optional worksheet ID or name.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_REFRESH_PIVOT_TABLESRefresh Pivot Tables

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The worksheet ID or exact name.
string
Optional workbook session ID.
string
Pivot table ID; omit to refresh every pivot table in the worksheet.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_REFRESH_SESSIONRefresh Excel Session

Input Parameters

string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The workbook session ID to refresh.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_RESOLVE_SHARED_WORKBOOKResolve a Microsoft Graph share token, shareId, or raw sharing URL to DriveItem metadata.

Input Parameters

string
required
A shareId or ‘u!’ sharing token returned by Microsoft Graph, or the complete raw HTTP(S) sharing URL to encode for Graph shares addressing.
array
DriveItem properties and facets to return via Microsoft Graph $select.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_REVOKE_WORKBOOK_PERMISSIONRemove a non-inherited sharing permission from a workbook.

Input Parameters

string
required
The ID of the DriveItem representing the workbook.
string
The ID of the drive containing the workbook. If omitted or set to ‘me’, the current user’s default OneDrive is used.
string
Optional eTag precondition sent as If-Match. The permission is removed only if the current workbook version matches this value.
string
required
The ID of the non-inherited sharing permission to remove. Inherited permissions cannot be deleted.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_RUN_GRAPH_MUTATION_BATCHCreate, update, or delete drive or workbook resources in up to 20 requests; inspect every subresponse status because individual mutations can fail.

Input Parameters

array
required
One to 20 POST, PATCH, PUT, or DELETE requests for Microsoft Graph drive or workbook resources.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_RUN_GRAPH_READ_BATCHRead drive or workbook data in up to 20 GET requests; inspect every subresponse status because individual requests can fail.

Input Parameters

array
required
One to 20 GET requests for Microsoft Graph drive or workbook data.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_SEARCH_FILESSearch OneDrive drive items by query and return files, optionally filtered by extension, to discover Excel workbook IDs. Extension filtering is applied to each returned page.

Input Parameters

integer
Maximum number of items to return. Uses $top query parameter if supported.
string
required
Search query text to find items (e.g., filename like ‘roster.xlsx’ or partial name). Matches across filename, metadata, and file content.
string ("drive" | "root")
Search scope: ‘drive’ searches entire drive including items shared with current user; ‘root’ searches within user’s drive hierarchy only.
string
ID of the drive to search (use ‘me’ for the user’s default drive in delegated auth, or a specific drive ID).
string
Opaque pagination token from a previous response’s next_link URL ($skiptoken value). Pass this to fetch the next page of search results.
array
Optional list of file extensions to filter results (e.g., [‘.xlsx’, ‘.xlsm’]). Applied as client-side filter to results.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_SEARCH_MICROSOFT_365_CONTENTSearch OneDrive and SharePoint content using Microsoft Search.

Input Parameters

integer
Number of search results to return, from 1 through 500.
string
required
Microsoft Search query string, including supported KQL when needed.
array
Fields to return on each matching resource.
string
Microsoft 365 data location code, such as ‘NAM’ or ‘EUR’. Required for application permissions and must be omitted for delegated permissions.
integer
Zero-based result offset. Increase this by size to request the next page.
array
OneDrive and SharePoint entity types to search: driveItem, listItem, list, site, or drive.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_SEARCH_SITESSearch SharePoint sites by free-text query for workbook discovery.

Input Parameters

integer
Maximum number of matching sites to return on this page.
string
required
Free-text query used to search SharePoint sites by keyword.
string
Opaque $skiptoken value from a previous response’s @odata.nextLink URL.
array
Site properties to return. Omit to use Microsoft Graph’s default projection.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_SET_CHART_DATAReplace an Excel chart’s source range and optionally choose whether rows or columns define its series.

Input Parameters

string
required
The ID of the Excel workbook drive item.
string
Optional drive ID. Omit to use the connected user’s default drive.
string ("Auto" | "Columns" | "Rows")
Whether rows or columns define chart series.
string
required
The exact worksheet ID or name.
string
required
The exact chart ID or name.
string
Optional workbook session ID for this request.
string
required
The range object or address containing the chart source data.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_SET_CHART_POSITIONSet chart position

Input Parameters

string
required
The ID of the Excel workbook drive item.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
Optional ending cell that determines chart width and height.
string
required
The exact worksheet ID or name.
string
required
The exact chart ID or name.
string
Optional workbook session ID for this request.
string
required
The cell where the chart’s leading corner should be placed.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_SORT_RANGESort a range in a worksheet using Microsoft Graph API.

Input Parameters

array
required
List of sort fields (e.g., [{ ‘key’: 0, ‘ascending’: true }]).
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
Optional SharePoint site ID. Required for application-level authentication (s2s_oauth). Format: ‘hostname,spSiteId,spWebId’.
string
Optional drive ID. Required for application-level permissions (s2s_oauth) with OneDrive files. If not provided, falls back to site_id or /me/drive endpoint. Use EXCEL_LIST_FILES or ONE_DRIVE_GET_DRIVE_ROOT to get the drive ID.
string
required
The name or ID of the worksheet (must be URL-encoded if using ID).
string
required
The type of range to sort (e.g., ‘usedRange’).
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UNMERGE_RANGESplit a merged worksheet range back into separate cells.

Input Parameters

string
required
The A1-style address of the merged range to unmerge.
string
required
The ID of the Excel workbook file (drive item).
string
The explicit drive ID containing the workbook. Omit to use the connected user’s drive.
string
required
The name or ID of the worksheet containing the range to unmerge.
string
An optional workbook session ID to use for this operation.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UNPROTECT_WORKSHEETRemove protection from a worksheet so it can be edited again.

Input Parameters

string
required
The ID of the Excel file (drive item) containing the worksheet.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
required
The exact name or ID of the worksheet to unprotect.
string
Optional workbook session ID to use for this request.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPDATE_CHARTUpdate a chart in a worksheet using Microsoft Graph API.

Input Parameters

number
The new top position for the chart.
number
The new left position for the chart.
string
The new name for the chart.
number
The new width for the chart.
number
The new height for the chart.
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
required
The ID of the chart (must be URL-encoded).
string
The ID of the drive containing the Excel file. Optional for delegated auth, required for application auth (s2s_oauth).
string
required
The name or ID of the worksheet (must be URL-encoded if using ID).
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPDATE_CHART_COMPONENTUpdate one Excel chart component: an axis, data labels, chart title, axis title, supported gridlines, axis font, fill, or supported line format.

Input Parameters

string
required
The ID of the Excel workbook drive item.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
required
The chart component and its component-specific update settings.
string
required
The exact worksheet ID or name.
string
required
The exact chart ID or name.
string
Optional workbook session ID for this request.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPDATE_CHART_LEGENDUpdate a chart legend’s visibility, position, or overlay setting.

Input Parameters

string
required
The ID of the Excel file (drive item) containing the workbook.
boolean
Set to true to make the legend overlap the chart body, or false otherwise.
boolean
Set to true to show the chart legend, or false to hide it.
string
required
The name or ID of the chart (must be URL-encoded).
string
Optional drive ID. If not provided, will attempt to use /me/drive (requires delegated auth) or auto-detect from item.
string ("Top" | "Bottom" | "Left" | "Right" | "Corner" | "Custom")
The position of the legend on the chart. Possible values: Top, Bottom, Left, Right, Corner, Custom.
string
required
The name or ID of the worksheet (must be URL-encoded if using ID).
string
Optional workbook session ID. If provided, will be sent in the ‘workbook-session-id’ header.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPDATE_CHART_SERIESRename one Excel chart series by ID or zero-based collection position.

Input Parameters

string
required
The new series name.
string
required
The ID of the Excel workbook drive item.
string
Optional drive ID. Omit to use the connected user’s default drive.
string
The exact series ID. Provide exactly one of series_id or series_index.
string
required
The exact worksheet ID or name.
string
required
The exact chart ID or name.
string
Optional workbook session ID for this request.
integer
The zero-based series position. Provide exactly one of series_id or series_index.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPDATE_DRIVE_ITEMRename, move within the same drive, or update client timestamps for a DriveItem by stable ID.

Input Parameters

string
New file or folder name, including the extension for a file.
string
required
Stable Graph DriveItem ID of the file or folder to update.
string
ID of the drive containing the item. Use ‘me’ for the user’s default drive.
string
ETag or cTag used for a conditional update. Graph returns 412 if it is stale.
string
Destination folder’s DriveItem ID in the same drive. Microsoft Graph does not support cross-drive moves with this action.
object
Client-side creation or modification timestamps to preserve.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPDATE_NAMED_ITEMUpdate a workbook named item’s visibility or comment.

Input Parameters

string
required
The exact workbook-scoped named-item name.
string
New comment for the named item. Provide comment, visible, or both; use an empty string to clear it.
string
required
The Excel workbook drive-item ID.
boolean
Whether the named item is visible. Provide visible, comment, or both.
string
Optional drive ID.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPDATE_RANGEUpdate cell values in a specified worksheet range using Microsoft Graph API.

Input Parameters

array
required
The values to update in the range.
string
required
The address of the range (e.g., ‘A1:B2’).
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
Optional drive ID. If provided, uses /drives/{drive_id}/items/{item_id} endpoint (required for application permissions). If not provided, uses /me/drive/items/{item_id} endpoint (for delegated permissions).
string
Optional session ID for the workbook, obtained from the createSession API (GET_SESSION action). Must be a valid, active session ID. Leave blank if not using sessions.
string
required
The ID of the worksheet.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPDATE_RANGE_FORMATUpdate exactly one formatting component on a workbook range.

Input Parameters

object
Background fill set or clear operation.
object
Font settings.
object
One semantic border side and its line settings.
object
Dimensions, alignment, and wrapping settings.
string
required
The range whose formatting to update.
string
required
The Excel workbook drive-item ID.
string
The explicit drive ID; omit for /me/drive.
string ("format" | "fill" | "font" | "border" | "protection")
required
The one formatting component this call updates. Supply only the matching settings object.
object
Cell locking and formula-visibility settings.
string
An optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPDATE_SHAREPOINT_RANGEUpdate values in a worksheet range in an Excel workbook stored in a SharePoint site’s default drive using Microsoft Graph.

Input Parameters

array
required
The values to update in the range.
string
required
The address of the range (e.g., ‘A1:B2’).
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
required
The ID of the SharePoint site containing the Excel file.
string
Optional session ID for the workbook. If provided, will be sent in the headers.
string
required
The ID of the worksheet.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPDATE_TABLEUpdate an Excel workbook table’s name, header visibility, totals visibility, or style using Microsoft Graph.

Input Parameters

string
The new name for the table.
string
The style of the table.
string
required
The ID of the Excel file (drive item) containing the table.
string
Optional drive ID. Required for application-level permissions (s2s_oauth). If not provided, uses /me/drive endpoint for delegated auth.
string
required
The ID of the table to update.
string
Optional session ID for the workbook. If provided, will be sent in the headers.
boolean
Whether the table shows totals.
boolean
Whether the table shows headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPDATE_TABLE_COLUMNUpdate the name or values of an Excel table column.

Input Parameters

string
New column name. Provide name, values, or both.
array
Two-dimensional replacement column values. Provide values, name, or both.
string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The table ID or exact name.
string
required
The column ID or exact name.
string
Optional worksheet ID or name.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPDATE_TABLE_COLUMN_RANGEUpdate raw values in a table column’s data-body cells by zero-based index.

Input Parameters

array
required
Data-body values as [[row1_value], [row2_value]], with exactly one cell in each inner row.
string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The table ID or exact name.
string
Optional worksheet ID or name.
string
Optional workbook session ID.
integer
required
Zero-based table-column index (0 through 16,383).

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPDATE_TABLE_ROWUpdate Table Row

Input Parameters

array
required
Two-dimensional array of replacement row values.
string
required
The Excel workbook drive-item ID.
string
Optional drive ID.
string
required
The table ID or exact name.
integer
required
Zero-based row index.
string
Optional worksheet ID or name.
string
Optional workbook session ID.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPDATE_WORKSHEETUpdate worksheet properties (name, position) in an Excel workbook using Microsoft Graph API.

Input Parameters

string
The new name for the worksheet.
string
required
The ID of the Excel file (drive item) containing the worksheet.
string
The ID of the SharePoint site containing the Excel file. Required when using application permissions (s2s_oauth). Not needed for delegated authentication.
string
Optional drive ID. Required for application-level permissions (s2s_oauth) with OneDrive files. If not provided, falls back to site_id or /me/drive endpoint. Use EXCEL_LIST_FILES or ONE_DRIVE_GET_DRIVE_ROOT to get the drive ID.
integer
The new position for the worksheet.
string
required
The name or ID of the worksheet to update. If using ID, it must be URL-encoded.
string
Optional session ID for the workbook. If provided, will be sent in the headers.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_UPLOAD_WORKBOOKTool to upload an external Excel file from a URL into OneDrive/SharePoint. Downloads the file server-side and uploads it to the specified drive location, returning the driveItem metadata for subsequent Excel operations.

Input Parameters

string
ID of the target drive. Use ‘me’ for the user’s default OneDrive.
string
required
URL of the Excel file to download and upload. Must be a publicly accessible URL or authenticated URL.
string
Full path including folder and filename where the file should be uploaded in OneDrive/SharePoint, e.g., ‘Documents/report.xlsx’. If not provided, file will be uploaded to /Uploads/{timestamp}-{filename}.
string ("rename" | "replace" | "fail")
What to do if a file already exists at the destination path. ‘rename’ creates a new file with a number suffix, ‘replace’ overwrites the existing file, ‘fail’ returns an error.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not
Slug: EXCEL_WHO_AM_IReturn the identity (email, name) of the connected Excel (Microsoft) account.

Output

string
required
Data from the action execution
string
Error if any occurred during the execution of the action
boolean
required
Whether or not the action execution was successful or not