# OpType ## Content # Enumeration: OpType Defines the Operational type ## Table of contents ### Enumeration members - [addAutoMerge](OpType#addautomerge) - [addCellState](OpType#addcellstate) - [addColumns](OpType#addcolumns) - [addComment](OpType#addcomment) - [addCustomDocProp](OpType#addcustomdocprop) - [addCustomTheme](OpType#addcustomtheme) - [addDataValidator](OpType#adddatavalidator) - [addExternalReference](OpType#addexternalreference) - [addNamedStyle](OpType#addnamedstyle) - [addPivotCache](OpType#addpivotcache) - [addPivotField](OpType#addpivotfield) - [addPivotSlicerCache](OpType#addpivotslicercache) - [addPivotTable](OpType#addpivottable) - [addRows](OpType#addrows) - [addRule](OpType#addrule) - [addShape](OpType#addshape) - [addSheet](OpType#addsheet) - [addSheetNamedStyle](OpType#addsheetnamedstyle) - [addSheetTabStyle](OpType#addsheettabstyle) - [addSpan](OpType#addspan) - [addSparklineEx](OpType#addsparklineex) - [addSparklineForGroup](OpType#addsparklineforgroup) - [addSparklineGroup](OpType#addsparklinegroup) - [addTable](OpType#addtable) - [addTableColumn](OpType#addtablecolumn) - [addTableItemSlicerCache](OpType#addtableitemslicercache) - [addTableRow](OpType#addtablerow) - [addThreadedComment](OpType#addthreadedcomment) - [addThreadedCommentReply](OpType#addthreadedcommentreply) - [clearCustomDocProp](OpType#clearcustomdocprop) - [clearCustomFunction](OpType#clearcustomfunction) - [clearCustomName](OpType#clearcustomname) - [clearFormatStringName](OpType#clearformatstringname) - [clearRange](OpType#clearrange) - [clearRule](OpType#clearrule) - [clearSheetScopeCustomFunction](OpType#clearsheetscopecustomfunction) - [clearSheetScopeCustomName](OpType#clearsheetscopecustomname) - [clearSheetTabStyle](OpType#clearsheettabstyle) - [clearSheets](OpType#clearsheets) - [clearSparklineForGroup](OpType#clearsparklineforgroup) - [deleteColumns](OpType#deletecolumns) - [deleteGroupItem](OpType#deletegroupitem) - [deleteRows](OpType#deleterows) - [groupSparkline](OpType#groupsparkline) - [insertGroupItem](OpType#insertgroupitem) - [preserveUnsupportedChart](OpType#preserveunsupportedchart) - [removeAutoMerge](OpType#removeautomerge) - [removeCellState](OpType#removecellstate) - [removeComment](OpType#removecomment) - [removeCustomDocProp](OpType#removecustomdocprop) - [removeCustomTheme](OpType#removecustomtheme) - [removeDataValidator](OpType#removedatavalidator) - [removeNamedStyle](OpType#removenamedstyle) - [removePivotCache](OpType#removepivotcache) - [removePivotField](OpType#removepivotfield) - [removePivotSlicerCache](OpType#removepivotslicercache) - [removePivotTable](OpType#removepivottable) - [removeRule](OpType#removerule) - [removeShape](OpType#removeshape) - [removeSheet](OpType#removesheet) - [removeSheetNamedStyle](OpType#removesheetnamedstyle) - [removeSheetTabStyle](OpType#removesheettabstyle) - [removeSpan](OpType#removespan) - [removeSparklineEx](OpType#removesparklineex) - [removeSparklineForGroup](OpType#removesparklineforgroup) - [removeSparklineGroup](OpType#removesparklinegroup) - [removeTable](OpType#removetable) - [removeTableColumn](OpType#removetablecolumn) - [removeTableItemSlicerCache](OpType#removetableitemslicercache) - [removeTableRow](OpType#removetablerow) - [removeThreadedComment](OpType#removethreadedcomment) - [removeThreadedCommentReply](OpType#removethreadedcommentreply) - [reorderChildShape](OpType#reorderchildshape) - [reorderShape](OpType#reordershape) - [reorderSheet](OpType#reordersheet) - [setActiveSheetId](OpType#setactivesheetid) - [setAxisOptions](OpType#setaxisoptions) - [setAxisSize](OpType#setaxissize) - [setCellState](OpType#setcellstate) - [setColumnCount](OpType#setcolumncount) - [setCurrentTheme](OpType#setcurrenttheme) - [setCustomDocProps](OpType#setcustomdocprops) - [setCustomFunction](OpType#setcustomfunction) - [setCustomName](OpType#setcustomname) - [setDataValidatorRange](OpType#setdatavalidatorrange) - [setDirection](OpType#setdirection) - [setFileInfo](OpType#setfileinfo) - [setFilter](OpType#setfilter) - [setFormatStringName](OpType#setformatstringname) - [setFrozen](OpType#setfrozen) - [setGroupItems](OpType#setgroupitems) - [setGroupSparklines](OpType#setgroupsparklines) - [setOutlineColumnOptions](OpType#setoutlinecolumnoptions) - [setOutlineColumnProperty](OpType#setoutlinecolumnproperty) - [setPrintInfo](OpType#setprintinfo) - [setPrintInfoOption](OpType#setprintinfooption) - [setRange](OpType#setrange) - [setRowCount](OpType#setrowcount) - [setSelectionPolicyAndUnit](OpType#setselectionpolicyandunit) - [setSheetAreaAutoMerge](OpType#setsheetareaautomerge) - [setSheetBackgroundImage](OpType#setsheetbackgroundimage) - [setSheetName](OpType#setsheetname) - [setSheetScopeCustomFunction](OpType#setsheetscopecustomfunction) - [setSheetScopeCustomName](OpType#setsheetscopecustomname) - [setSheetVisible](OpType#setsheetvisible) - [setStartSheetIndex](OpType#setstartsheetindex) - [setTabSelected](OpType#settabselected) - [setTableColumnProperty](OpType#settablecolumnproperty) - [setTableLayoutStyle](OpType#settablelayoutstyle) - [setTableProperty](OpType#settableproperty) - [setWorkbookOptions](OpType#setworkbookoptions) - [setWorkbookProperty](OpType#setworkbookproperty) - [setWorksheetOptions](OpType#setworksheetoptions) - [showFooter](OpType#showfooter) - [showHeader](OpType#showheader) - [showOutline](OpType#showoutline) - [sortSwap](OpType#sortswap) - [switchPivotCache](OpType#switchpivotcache) - [updateCellState](OpType#updatecellstate) - [updateChart](OpType#updatechart) - [updateChartSeries](OpType#updatechartseries) - [updateComment](OpType#updatecomment) - [updateCustomDocProp](OpType#updatecustomdocprop) - [updateCustomTheme](OpType#updatecustomtheme) - [updateDataValidator](OpType#updatedatavalidator) - [updateDocProp](OpType#updatedocprop) - [updateDocPropForApp](OpType#updatedocpropforapp) - [updateDocPropForCore](OpType#updatedocpropforcore) - [updateExternalReference](OpType#updateexternalreference) - [updateFieldsModel](OpType#updatefieldsmodel) - [updateFilterButtonVisibleInfo](OpType#updatefilterbuttonvisibleinfo) - [updateFilterData](OpType#updatefilterdata) - [updateFilterRange](OpType#updatefilterrange) - [updateFilterSortInfo](OpType#updatefiltersortinfo) - [updatePivotCache](OpType#updatepivotcache) - [updatePivotCacheField](OpType#updatepivotcachefield) - [updatePivotSlicerCacheProperty](OpType#updatepivotslicercacheproperty) - [updatePivotTableLayout](OpType#updatepivottablelayout) - [updatePivotTableOptions](OpType#updatepivottableoptions) - [updateRule](OpType#updaterule) - [updateShapeFormula](OpType#updateshapeformula) - [updateShapeProp](OpType#updateshapeprop) - [updateShapeTransform](OpType#updateshapetransform) - [updateSheetDefaultsOptions](OpType#updatesheetdefaultsoptions) - [updateSlicerProperty](OpType#updateslicerproperty) - [updateSortState](OpType#updatesortstate) - [updateSpan](OpType#updatespan) - [updateSparkline](OpType#updatesparkline) - [updateSparklineGroup](OpType#updatesparklinegroup) - [updateTableItemSlicerCacheProperty](OpType#updatetableitemslicercacheproperty) - [updateTablePosition](OpType#updatetableposition) - [updateThreadedComment](OpType#updatethreadedcomment) - [updateThreadedCommentReply](OpType#updatethreadedcommentreply) - [updateTopLeftPosition](OpType#updatetopleftposition) - [updateZoom](OpType#updatezoom) ## Enumeration members ### addAutoMerge • **addAutoMerge** = `311` addAutoMerge ___ ### addCellState • **addCellState** = `351` addCellState ___ ### addColumns • **addColumns** = `39` addColumns ___ ### addComment • **addComment** = `161` addComment ___ ### addCustomDocProp • **addCustomDocProp** = `21` addCustomDocProp ___ ### addCustomTheme • **addCustomTheme** = `12` addCustomTheme ___ ### addDataValidator • **addDataValidator** = `361` addDataValidator ___ ### addExternalReference • **addExternalReference** = `101` addExternalReference ___ ### addNamedStyle • **addNamedStyle** = `8` addNamedStyle ___ ### addPivotCache • **addPivotCache** = `251` addPivotCache ___ ### addPivotField • **addPivotField** = `275` addPivotField ___ ### addPivotSlicerCache • **addPivotSlicerCache** = `394` addPivotSlicerCache ___ ### addPivotTable • **addPivotTable** = `271` addPivotTable ___ ### addRows • **addRows** = `33` addRows ___ ### addRule • **addRule** = `301` addRule ___ ### addShape • **addShape** = `201` addShape ___ ### addSheet • **addSheet** = `1` addSheet ___ ### addSheetNamedStyle • **addSheetNamedStyle** = `10` addSheetNamedStyle ___ ### addSheetTabStyle • **addSheetTabStyle** = `15` addSheetTabStyle ___ ### addSpan • **addSpan** = `35` addSpan ___ ### addSparklineEx • **addSparklineEx** = `321` addSparklineEx ___ ### addSparklineForGroup • **addSparklineForGroup** = `328` addSparklineForGroup ___ ### addSparklineGroup • **addSparklineGroup** = `324` addSparklineGroup ___ ### addTable • **addTable** = `171` addTable ___ ### addTableColumn • **addTableColumn** = `180` addTableColumn ___ ### addTableItemSlicerCache • **addTableItemSlicerCache** = `391` addTableItemSlicerCache ___ ### addTableRow • **addTableRow** = `177` addTableRow ___ ### addThreadedComment • **addThreadedComment** = `410` addThreadedComment ___ ### addThreadedCommentReply • **addThreadedCommentReply** = `413` addThreadedCommentReply ___ ### clearCustomDocProp • **clearCustomDocProp** = `23` clearCustomDocProp ___ ### clearCustomFunction • **clearCustomFunction** = `59` clearCustomFunction ___ ### clearCustomName • **clearCustomName** = `31` clearCustomName ___ ### clearFormatStringName • **clearFormatStringName** = `63` clearFormatStringName ___ ### clearRange • **clearRange** = `51` clearRange ___ ### clearRule • **clearRule** = `304` clearRule ___ ### clearSheetScopeCustomFunction • **clearSheetScopeCustomFunction** = `60` clearSheetScopeCustomFunction ___ ### clearSheetScopeCustomName • **clearSheetScopeCustomName** = `32` clearSheetScopeCustomName ___ ### clearSheetTabStyle • **clearSheetTabStyle** = `17` clearSheetTabStyle ___ ### clearSheets • **clearSheets** = `3` clearSheets ___ ### clearSparklineForGroup • **clearSparklineForGroup** = `330` clearSparklineForGroup ___ ### deleteColumns • **deleteColumns** = `40` deleteColumns ___ ### deleteGroupItem • **deleteGroupItem** = `149` deleteGroupItem ___ ### deleteRows • **deleteRows** = `34` deleteRows ___ ### groupSparkline • **groupSparkline** = `326` groupSparkline ___ ### insertGroupItem • **insertGroupItem** = `147` insertGroupItem ___ ### preserveUnsupportedChart • **preserveUnsupportedChart** = `223` preserveUnsupportedChart ___ ### removeAutoMerge • **removeAutoMerge** = `312` removeAutoMerge ___ ### removeCellState • **removeCellState** = `352` removeCellState ___ ### removeComment • **removeComment** = `162` removeComment ___ ### removeCustomDocProp • **removeCustomDocProp** = `22` removeCustomDocProp ___ ### removeCustomTheme • **removeCustomTheme** = `13` removeCustomTheme ___ ### removeDataValidator • **removeDataValidator** = `363` removeDataValidator ___ ### removeNamedStyle • **removeNamedStyle** = `9` removeNamedStyle ___ ### removePivotCache • **removePivotCache** = `252` removePivotCache ___ ### removePivotField • **removePivotField** = `276` removePivotField ___ ### removePivotSlicerCache • **removePivotSlicerCache** = `396` removePivotSlicerCache ___ ### removePivotTable • **removePivotTable** = `272` removePivotTable ___ ### removeRule • **removeRule** = `303` removeRule ___ ### removeShape • **removeShape** = `202` removeShape ___ ### removeSheet • **removeSheet** = `2` removeSheet ___ ### removeSheetNamedStyle • **removeSheetNamedStyle** = `11` removeSheetNamedStyle ___ ### removeSheetTabStyle • **removeSheetTabStyle** = `16` removeSheetTabStyle ___ ### removeSpan • **removeSpan** = `36` removeSpan ___ ### removeSparklineEx • **removeSparklineEx** = `322` removeSparklineEx ___ ### removeSparklineForGroup • **removeSparklineForGroup** = `329` removeSparklineForGroup ___ ### removeSparklineGroup • **removeSparklineGroup** = `325` removeSparklineGroup ___ ### removeTable • **removeTable** = `172` removeTable ___ ### removeTableColumn • **removeTableColumn** = `181` removeTableColumn ___ ### removeTableItemSlicerCache • **removeTableItemSlicerCache** = `393` removeTableItemSlicerCache ___ ### removeTableRow • **removeTableRow** = `178` removeTableRow ___ ### removeThreadedComment • **removeThreadedComment** = `412` removeThreadedComment ___ ### removeThreadedCommentReply • **removeThreadedCommentReply** = `415` removeThreadedCommentReply ___ ### reorderChildShape • **reorderChildShape** = `209` reorderChildShape ___ ### reorderShape • **reorderShape** = `203` reorderShape ___ ### reorderSheet • **reorderSheet** = `4` reorderSheet ___ ### setActiveSheetId • **setActiveSheetId** = `6` setActiveSheetId ___ ### setAxisOptions • **setAxisOptions** = `47` setAxisOptions ___ ### setAxisSize • **setAxisSize** = `45` setAxisSize ___ ### setCellState • **setCellState** = `354` setCellState ___ ### setColumnCount • **setColumnCount** = `42` setColumnCount ___ ### setCurrentTheme • **setCurrentTheme** = `50` setCurrentTheme ___ ### setCustomDocProps • **setCustomDocProps** = `25` setCustomDocProps ___ ### setCustomFunction • **setCustomFunction** = `57` setCustomFunction ___ ### setCustomName • **setCustomName** = `29` setCustomName ___ ### setDataValidatorRange • **setDataValidatorRange** = `364` setDataValidatorRange ___ ### setDirection • **setDirection** = `145` setDirection ___ ### setFileInfo • **setFileInfo** = `53` setFileInfo ___ ### setFilter • **setFilter** = `121` setFilter ___ ### setFormatStringName • **setFormatStringName** = `62` setFormatStringName ___ ### setFrozen • **setFrozen** = `43` setFrozen ___ ### setGroupItems • **setGroupItems** = `148` setGroupItems ___ ### setGroupSparklines • **setGroupSparklines** = `327` setGroupSparklines ___ ### setOutlineColumnOptions • **setOutlineColumnOptions** = `371` setOutlineColumnOptions ___ ### setOutlineColumnProperty • **setOutlineColumnProperty** = `372` setOutlineColumnProperty ___ ### setPrintInfo • **setPrintInfo** = `381` setPrintInfo ___ ### setPrintInfoOption • **setPrintInfoOption** = `382` setPrintInfoOption ___ ### setRange • **setRange** = `28` setRange ___ ### setRowCount • **setRowCount** = `41` setRowCount ___ ### setSelectionPolicyAndUnit • **setSelectionPolicyAndUnit** = `64` setSelectionPolicyAndUnit ___ ### setSheetAreaAutoMerge • **setSheetAreaAutoMerge** = `313` setSheetAreaAutoMerge ___ ### setSheetBackgroundImage • **setSheetBackgroundImage** = `56` setSheetBackgroundImage ___ ### setSheetName • **setSheetName** = `27` setSheetName ___ ### setSheetScopeCustomFunction • **setSheetScopeCustomFunction** = `58` setSheetScopeCustomFunction ___ ### setSheetScopeCustomName • **setSheetScopeCustomName** = `30` setSheetScopeCustomName ___ ### setSheetVisible • **setSheetVisible** = `52` setSheetVisible ___ ### setStartSheetIndex • **setStartSheetIndex** = `5` setStartSheetIndex ___ ### setTabSelected • **setTabSelected** = `26` setTabSelected ___ ### setTableColumnProperty • **setTableColumnProperty** = `182` setTableColumnProperty ___ ### setTableLayoutStyle • **setTableLayoutStyle** = `176` setTableLayoutStyle ___ ### setTableProperty • **setTableProperty** = `175` setTableProperty ___ ### setWorkbookOptions • **setWorkbookOptions** = `7` setWorkbookOptions ___ ### setWorkbookProperty • **setWorkbookProperty** = `55` setWorkbookProperty ___ ### setWorksheetOptions • **setWorksheetOptions** = `49` setWorksheetOptions ___ ### showFooter • **showFooter** = `174` showFooter ___ ### showHeader • **showHeader** = `173` showHeader ___ ### showOutline • **showOutline** = `146` showOutline ___ ### sortSwap • **sortSwap** = `111` sortSwap ___ ### switchPivotCache • **switchPivotCache** = `254` switchPivotCache ___ ### updateCellState • **updateCellState** = `353` updateCellState ___ ### updateChart • **updateChart** = `222` updateChart ___ ### updateChartSeries • **updateChartSeries** = `221` updateChartSeries ___ ### updateComment • **updateComment** = `163` updateComment ___ ### updateCustomDocProp • **updateCustomDocProp** = `24` updateCustomDocProp ___ ### updateCustomTheme • **updateCustomTheme** = `14` updateCustomTheme ___ ### updateDataValidator • **updateDataValidator** = `362` updateDataValidator ___ ### updateDocProp • **updateDocProp** = `18` updateDocProp ___ ### updateDocPropForApp • **updateDocPropForApp** = `19` updateDocPropForApp ___ ### updateDocPropForCore • **updateDocPropForCore** = `20` updateDocPropForCore ___ ### updateExternalReference • **updateExternalReference** = `102` updateExternalReference ___ ### updateFieldsModel • **updateFieldsModel** = `274` updateFieldsModel ___ ### updateFilterButtonVisibleInfo • **updateFilterButtonVisibleInfo** = `125` updateFilterButtonVisibleInfo ___ ### updateFilterData • **updateFilterData** = `128` updateFilterData ___ ### updateFilterRange • **updateFilterRange** = `126` updateFilterRange ___ ### updateFilterSortInfo • **updateFilterSortInfo** = `124` updateFilterSortInfo ___ ### updatePivotCache • **updatePivotCache** = `253` updatePivotCache ___ ### updatePivotCacheField • **updatePivotCacheField** = `255` updatePivotCacheField ___ ### updatePivotSlicerCacheProperty • **updatePivotSlicerCacheProperty** = `395` updatePivotSlicerCache ___ ### updatePivotTableLayout • **updatePivotTableLayout** = `273` updatePivotTableLayout ___ ### updatePivotTableOptions • **updatePivotTableOptions** = `277` updatePivotTableOptions ___ ### updateRule • **updateRule** = `302` updateRule ___ ### updateShapeFormula • **updateShapeFormula** = `205` updateShapeFormula ___ ### updateShapeProp • **updateShapeProp** = `204` updateShapeProp ___ ### updateShapeTransform • **updateShapeTransform** = `206` updateShapeTransform ___ ### updateSheetDefaultsOptions • **updateSheetDefaultsOptions** = `61` updateSheetDefaultsOptions ___ ### updateSlicerProperty • **updateSlicerProperty** = `397` updateSlicerProperty ___ ### updateSortState • **updateSortState** = `112` updateSortState ___ ### updateSpan • **updateSpan** = `37` updateSpan ___ ### updateSparkline • **updateSparkline** = `331` updateSparkline ___ ### updateSparklineGroup • **updateSparklineGroup** = `323` updateSparklineGroup ___ ### updateTableItemSlicerCacheProperty • **updateTableItemSlicerCacheProperty** = `392` updateTableItemSlicerCache ___ ### updateTablePosition • **updateTablePosition** = `179` updateTablePosition ___ ### updateThreadedComment • **updateThreadedComment** = `411` updateThreadedComment ___ ### updateThreadedCommentReply • **updateThreadedCommentReply** = `414` updateThreadedCommentReply ___ ### updateTopLeftPosition • **updateTopLeftPosition** = `54` updateTopLeftPosition ___ ### updateZoom • **updateZoom** = `46` updateZoom