368 Excel Operations

INDEX Returns a value from a range by row and column index

INDIRECT Returns a reference specified by a text string

OFFSET Returns a reference offset from a starting cell

autoSum Automatically inserts SUM formula for detected data range

calculateWorkbook Triggers full recalculation of the entire workbook

consolidate Consolidates data from multiple ranges into one

count Counts the number of cells containing numbers

dateOccurring Filters dates occurring in a specific period

disableAutoCalculate Disables automatic formula recalculation

enableAutoCalculate Enables automatic formula recalculation

findAll Finds all occurrences of text in a range

findInRange Searches for a value within a specified range

findText Finds text within a range and returns its location

generateFormula Generates a formula based on described intent

getFormula Retrieves the formula from a specific cell

getValue Retrieves the displayed value from a cell

insertDynamicArray Inserts a dynamic array formula that spills results

insertFunction Inserts an Excel function into a range with arguments

max Returns the maximum value from a range

min Returns the minimum value from a range

replaceAll Replaces all occurrences of text in a range

replaceText Replaces specific text within a range

setFormula Sets a single formula in a specific cell

setFormulaArray Sets a formula across a range of cells

setFormulaR1C1 Sets a formula using R1C1 reference notation

setFormulas Sets multiple formulas in a target range with formula language support

sum Calculates the sum of a range of cells

textContains Checks if a cell contains specific text

transpose Transposes rows to columns or columns to rows

addAxisTitle Adds a title to a chart axis

addColorScale Adds color scale conditional formatting

addComment Adds a comment to a cell

addConditionalFormat Adds a simple conditional formatting rule

addConditionalFormatting Adds conditional formatting with criteria

addCustomConditionalFormat Adds a custom conditional formatting rule

addDataBar Adds data bar conditional formatting

addDataValidation Adds data validation rules to cells

addIconSet Adds icon set conditional formatting

addIconSetConditionalFormat Adds icon set with custom criteria

addPresetConditionalFormat Adds a preset conditional formatting rule

addRows Adds rows to a table or worksheet

addSlicer Adds a slicer for filtering

addTableColumn Adds a column to an existing table

addThreadedComment Adds a threaded (replyable) comment

addTop10ConditionalFormat Adds top/bottom N conditional formatting

applyAutoFilter Applies auto-filter dropdown to a range

applyCellStyle Applies a named cell style to a range

applyColorScale Applies a color scale conditional format

applyDataBars Applies data bar conditional formatting

applyDynamicFilter Applies a dynamic date filter

applyIconSet Applies icon set conditional formatting

applyStyle Applies a predefined style to a range

applyTableStyle Applies a table style to a table

applyTopBottomFilter Applies a top/bottom N filter

autoFill Auto-fills a range based on pattern detection

autoFitColumns Auto-fits column widths to content

autoFitRows Auto-fits row heights to content

clearAllTables Removes all tables from the worksheet

clearConditionalFormatting Removes conditional formatting from a range

clearFill Clears background fill from a range

clearFilter Clears all filters on a worksheet

clearFormat Clears formatting from a range while keeping values

clearRange Clears content and/or formatting from a range

clearSlicerFilter Clears a slicer filter selection

clearTableFilters Clears filters applied to a specific table

clearTableSort Clears sorting from a table

clearTableStyle Removes the style from a table

copyFormat Copies formatting from one range to another

copyRange Copies a range to a new location

copySpillToStatic Converts a spilled dynamic array to static values

createCustomCellStyle Creates a custom named cell style

createCustomTableStyle Creates a custom named table style

formatRange Applies comprehensive formatting to a cell range

formatTable Applies formatting to an entire table

mergeAcross Merges cells across rows

mergeCells Merges selected cells into one

mergeCellsAcross Merges cells across columns within a range

removeAutoFilter Removes the auto-filter dropdown from a range

removeBorder Removes borders from a range

removeConditionalFormatting Removes conditional formatting rules

removeDataValidation Removes data validation rules

removeDuplicates Removes duplicate rows from a range

removeTableAutoFilter Removes auto-filter from a table

removeTableColumns Removes specific columns from a table

rotateCellText Rotates text within cells

setAlignment Sets horizontal and vertical text alignment

setBorders Sets border style, color, and weight for a range

setCellStyle Applies a named cell style to a range

setColumnWidth Sets the width of one or more columns

setFill Sets the background fill color of a range

setFont Sets font name, size, color, and style for a range

setGradientFill Applies a gradient background fill to a range

setIndent Sets the text indent level in cells

setIndentation Sets text indentation with precise control

setNumberFormat Sets the number format (currency, date, percentage, etc.)

setPatternFill Applies a pattern background fill to a range

setProtection Sets protection settings for a range

setRowHeight Sets the height of one or more rows

setStrikethrough Applies strikethrough formatting to text

setSubscript Formats text as subscript

setSuperscript Formats text as superscript

setTableBandedColumns Enables or disables banded column formatting in a table

setTableBandedRows Enables or disables banded row formatting in a table

setTableColumn Configures a specific table column

setTableHeaders Sets header row formatting for a table

setTableHighlightFirstColumn Highlights the first column of a table

setTableHighlightLastColumn Highlights the last column of a table

setTextOrientation Sets text rotation angle in cells

setValues Sets raw values in a range of cells

shrinkToFit Shrinks text to fit within cell width

unmergeAcross Unmerges cells across rows

unmergeCells Unmerges previously merged cells

unwrapText Disables text wrapping in cells

wrapText Enables text wrapping in cells

advancedFilter Applies advanced filter with criteria range

autoFilter Toggles auto-filter on a range

calculateWorksheet Triggers recalculation of the active worksheet

cleanData Cleans and normalizes data in a range

convertToRange Converts a table back to a normal range

createTable Creates a new table from a data range with headers

createTableFromSpill Creates a table from a spilled dynamic array result

cutRange Cuts a range to clipboard

deleteAllComments Deletes all comments from the worksheet

deleteAllConditionalFormats Removes all conditional formatting

deleteAllDataValidations Removes all data validation rules

deleteAllTables Removes all tables from the worksheet

deleteColumns Deletes columns from a worksheet

deleteComment Deletes a comment from a cell

deleteRange Deletes a range and shifts surrounding cells

deleteRows Deletes rows from a worksheet

deleteSlicer Deletes a slicer from the worksheet

deleteTable Deletes a table (converts to range or removes)

deleteTableRows Deletes rows from a table

detectDataRange Detects the used data range in a worksheet

diagonaldown Applies diagonal-down border to cells

diagonalup Applies diagonal-up border to cells

editComment Edits an existing comment

editTable Modifies table properties

expandTable Expands a table to include more rows or columns

extractUniqueAndAggregate Extracts unique values and aggregates data

fillDown Fills values down from the top cell

fillRight Fills values right from the leftmost cell

filterAdvanced Applies advanced filter criteria

filterByCondition Filters by a specific condition

filterByValue Filters by specific values

filterSlicer Filters using a slicer selection

filterTable Applies a filter to a table

getComment Retrieves a comment from a cell

getSlicerItems Gets the items in a slicer

getTableColumnRange Gets a specific table column range

getTableDataRange Gets only the data range (excluding headers)

getTableHeaderRange Gets the header row range of a table

getTableInfo Retrieves table metadata (name, range, columns)

getTableRange Gets the full range of a table

getTableRowRange Gets a specific table row range

getTableTotalRange Gets the total row range of a table

getTotalRow Gets or sets the total row of a table

groupData Groups data rows or columns

hideFormulaErrors Hides formula error indicators

hideLegendEntry Hides a specific legend entry in a chart

insertColumns Inserts columns into a worksheet

insertRange Inserts a range and shifts surrounding cells

insertRows Inserts rows into a worksheet

insertTableColumns Inserts new columns into a table

insertTableRows Inserts new rows into a table

listComments Lists all comments in a worksheet

modifyTable Modifies table structure and properties

pasteSpecial Pastes with special options (values, formats, etc.)

readTableData Reads all data from a table

reapplyFilter Reapplies the current filter

reapplyTableFilters Reapplies filters on a table

refreshTable Refreshes external data in a table

renameTable Renames an existing table

renameTableColumn Renames a column in a table

replyToComment Replies to a threaded comment

resizeTable Resizes a table to a new range

resolveComment Marks a comment thread as resolved

showLegendEntry Shows a specific legend entry in a chart

sortAdvanced Performs advanced sort with custom criteria

sortByColumn Sorts data by a specific column

sortMultiple Performs multi-column sort

sortRange Sorts a range of cells

sortSlicerItems Sorts items in a slicer

sortTable Sorts a table by one column

sortTableMultiple Sorts a table by multiple columns

updateTable Updates table data or structure

updateTableRow Updates a specific row in a table

writeTableData Writes data to a table

activateWorksheet Activates (switches to) a specific worksheet

clearPrintArea Clears the defined print area

collapseGroup Collapses an outline group

configureHeaderFooter Configures headers and footers for printing

configurePageSetup Configures comprehensive page setup options

copyWorksheet Creates a copy of a worksheet

createWorksheet Creates a new worksheet in the workbook

deleteWorksheet Deletes a worksheet from the workbook

freezePanes Freezes panes at the current selection

groupColumns Groups selected columns for outlining

groupRows Groups selected rows for outlining

hideColumns Hides selected columns

hideRows Hides selected rows

hideWorksheet Hides a worksheet from view

listWorksheets Lists all worksheets in the workbook

moveWorksheet Moves a worksheet to a new position

renameWorksheet Renames an existing worksheet

setOutlineLevel Sets the outline level for rows or columns

setPageLayout Configures the page layout view

setPageMargins Sets page margins for printing

setPageOrientation Sets page orientation (portrait/landscape)

setPageSize Sets the paper size for printing

setPrintArea Defines the print area on a worksheet

setPrintGridlines Toggles printing of gridlines

setPrintHeaders Toggles printing of row/column headers

setPrintTitles Sets rows/columns to repeat on each printed page

showColumns Unhides selected columns

showGridlines Shows or hides worksheet gridlines

showHeadings Shows or hides row and column headings

showRows Unhides selected rows

showWorksheet Unhides a previously hidden worksheet

unfreezePane Unfreezes panes

unfreezePanes Unfreezes all frozen panes

ungroupColumns Ungroups previously grouped columns

ungroupRows Ungroups previously grouped rows

unhideColumns Unhides all columns

unhideRows Unhides all rows

zoomLevel Sets the zoom level of the worksheet

addChartDataTable Adds a data table below the chart

addChartErrorBars Adds error bars to a chart series

addChartSeries Adds a new data series to a chart

addChartTrendline Adds a trendline to a chart series

addSeriesDataLabel Adds data labels to a chart series

applyChartTheme Applies a theme to the chart

clearAllCharts Removes all charts from the worksheet

configure3DChart Configures 3D chart rotation and perspective

configureChartAxis Configures chart axis scale, labels, and formatting

configureChartDataLabels Configures data label position and format

configureChartDataTable Configures the chart data table display

configureChartGridlines Configures major and minor gridlines

configureChartLegend Configures legend position and formatting

configureChartPlotArea Configures the chart plot area

createChart Creates a new chart from a data range

deleteAllCharts Deletes all charts from the worksheet

deleteChart Deletes a chart from the worksheet

duplicateChart Creates a duplicate of a chart

exportChartAsImage Exports a chart as an image file

formatAxisLabels Formats axis label text

formatChart Applies formatting to the entire chart

formatChartBorder Formats the chart border

formatChartFill Sets the chart background fill

formatChartFont Sets the chart text font

formatChartLegend Formats the chart legend

formatChartPlotArea Formats the chart plot area

formatChartPoint Formats a specific data point in a series

formatChartTitle Formats the chart title text

formatDataLabel Formats a single data label

formatDataLabels Formats all data labels in a series

formatLegendAdvanced Applies advanced legend formatting

formatLegendEntry Formats a specific legend entry

formatSeriesAdvanced Applies advanced series formatting

formatTrendline Formats a trendline appearance

formatTrendlineLabel Formats the trendline label

getChartInfo Retrieves chart properties and metadata

getChartPoints Gets data points from a chart

highlightChartPoint Highlights a specific data point

line Creates or configures a line chart

moveChart Moves a chart to a new location or sheet

pie Creates or configures a pie chart

refreshChart Refreshes chart data and rendering

removeChartSeries Removes a data series from a chart

renameChart Renames an existing chart

resizeChart Resizes a chart

scatter Creates or configures a scatter chart

setChartAxis Configures chart axis properties

setChartAxisTitle Sets the title of a chart axis

setChartDataLabels Configures data labels on a chart

setChartDataRange Sets the data source range for a chart

setChartGridlines Configures chart gridlines

setChartLegend Configures the chart legend

setChartStyle Applies a predefined chart style

setChartTitle Sets the title of a chart

setChartType Sets the chart type (bar, line, pie, etc.)

showChartDataTable Shows or hides the chart data table

showSecondaryAxis Adds or configures a secondary axis

updateChart Updates chart properties

updateChartData Updates the data source of a chart

addArrow Adds an arrow shape

addCallout Adds a callout shape with text

addEmailLink Adds an email link

addFileLink Adds a link to a file

addGeometricShape Adds a geometric shape (rectangle, circle, etc.)

addHyperlink Adds a hyperlink to a cell or shape

clearAllElements Removes all visual elements

clearAllShapes Removes all shapes from the worksheet

deleteAllShapes Deletes all shapes from the worksheet

deleteAllSlicers Deletes all slicers from the worksheet

deleteShape Deletes a shape from the worksheet

formatShape Applies formatting to a shape

formatShapeText Formats text within a shape

formatSlicer Formats a slicer appearance

groupShapes Groups multiple shapes together

insertImage Inserts an image onto the worksheet

insertPageBreak Inserts a manual page break

insertShape Inserts a shape onto the worksheet

moveShape Moves a shape to a new position

removeHyperlink Removes a hyperlink

removePageBreak Removes a specific page break

removePageBreaks Removes all manual page breaks

resizeShape Resizes a shape

rotateShape Rotates a shape by a specified angle

setPageBreak Sets a page break at a specific location

setShapeStyle Sets the visual style of a shape

setShapeText Sets the text content of a shape

styleSlicer Applies a style to a slicer

ungroupShapes Ungroups a group of shapes

configureWorkbookProtection Configures workbook protection settings

configureWorksheetProtection Configures detailed worksheet protection options

getWorkbookProtectionStatus Checks if the workbook is protected

hideFormulas Hides formulas in cells when sheet is protected

lockCells Locks cells (requires sheet protection to take effect)

protectWorkbook Protects the workbook structure

protectWorksheet Protects a worksheet with optional password

protectWorksheetStructure Protects worksheet structure (cannot add/delete sheets)

unprotectWorkbook Removes workbook protection

unprotectWorksheet Removes worksheet protection

clearAllNamedRanges Removes all named ranges

createDynamicNamedRange Creates a dynamic named range with auto-expanding formula

createNamedRange Creates a named range referencing a specific range

createNamedRangeForSpill Creates a named range for a spilled array result

deleteAllNamedRanges Deletes all named ranges

deleteNamedRange Deletes a named range

expandNamedRange Expands a named range to include more cells

getNamedRangeValue Gets the value(s) from a named range

goToNamedRange Navigates to and selects a named range

listNamedRanges Lists all named ranges in the workbook

renameNamedRange Renames an existing named range

setNamedRangeValue Sets the value of a named range

updateNamedRange Updates the reference of a named range

addPivotColumnField Adds a field to the columns area

addPivotField Adds a field to the pivot table

addPivotFilterField Adds a field to the filters area

addPivotRowField Adds a field to the rows area

addPivotValueField Adds a field to the values area

applySubtotals Applies subtotals to a pivot field

clearAllPivotTables Removes all pivot tables from the worksheet

clearPivotFilter Clears a pivot field filter

clearPivotFilters Clears all pivot table filters

configurePivotField Configures a pivot field (summary function, layout)

configurePivotFilters Configures pivot table filters

configurePivotLayout Configures pivot table layout options

createPivotTable Creates a new pivot table from a data source

createSlicer Creates a slicer connected to a pivot table or table

deleteAllPivotTables Deletes all pivot tables

deletePivotTable Deletes a pivot table

deleteTableSlicer Deletes a slicer

filterPivotField Filters a specific pivot field

filterPivotTable Applies a filter to the pivot table

formatPivotField Formats a pivot field

formatPivotTable Formats a pivot table appearance

movePivotField Moves a pivot field between areas

pivotTableSort Sorts the entire pivot table

refreshPivotTable Refreshes the pivot table data

removePivotField Removes a field from the pivot table

removeSubtotals Removes subtotals from a pivot field

renamePivotTable Renames a pivot table

setPivotFilters Sets filter criteria for a pivot field

setPivotLayout Sets the layout style of a pivot table

sortPivotField Sorts items in a pivot field

updatePivotTable Updates pivot table data source or options