Worksheet Methods

The Worksheet type exposes the following members.

Methods
  NameDescription
Public methodAddPageBreaks
Adds page break.
Public methodAdvancedFilter
Filters data using complex criteria.
Public methodAutoFitColumn(Int32)
Autofits the column width.
Public methodAutoFitColumn(Int32, Int32, Int32)
Autofits the column width.
Public methodAutoFitColumns
Autofits all columns in this worksheet.
Public methodAutoFitColumns(AutoFitterOptions)
Autofits all columns in this worksheet.
Public methodAutoFitColumns(Int32, Int32)
Autofits the columns width.
Public methodAutoFitColumns(Int32, Int32, AutoFitterOptions)
Autofits the columns width.
Public methodAutoFitColumns(Int32, Int32, Int32, Int32)
Autofits the columns width.
Public methodAutoFitColumns(Int32, Int32, Int32, Int32, AutoFitterOptions)
Autofits the columns width.
Public methodAutoFitRow(Int32)
Autofits the row height.
Public methodAutoFitRow(Int32, Int32, Int32)
Autofits the row height.
Public methodAutoFitRow(Int32, Int32, Int32, AutoFitterOptions)
Autofits the row height.
Public methodAutoFitRow(Int32, Int32, Int32, Int32)
Autofits row height in a rectangle range.
Public methodAutoFitRows
Autofits all rows in this worksheet.
Public methodAutoFitRows(Boolean)
Autofits all rows in this worksheet.
Public methodAutoFitRows(AutoFitterOptions)
Autofits all rows in this worksheet.
Public methodAutoFitRows(Int32, Int32)
Autofits row height in a range.
Public methodAutoFitRows(Int32, Int32, AutoFitterOptions)
Autofits row height in a range.
Public methodCalculateFormula(String)
Calculates a formula.
Public methodCalculateFormula(String, CalculationOptions)
Calculates a formula.
Public methodCalculateFormula(CalculationOptions, Boolean)
Calculates all formulas in this worksheet.
Public methodCalculateFormula(Boolean, Boolean, ICustomFunction)
Calculates all formulas in this worksheet.
Public methodClearComments
Clears all comments in designer spreadsheet.
Public methodCopy(Worksheet)
Copies contents and formats from another worksheet.
Public methodCopy(Worksheet, CopyOptions)
Copies contents and formats from another worksheet.
Public methodDispose
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodFreezePanes(String, Int32, Int32)
Freezes panes at the specified cell in the worksheet.
Public methodFreezePanes(Int32, Int32, Int32, Int32)
Freezes panes at the specified cell in the worksheet.
Public methodGetFreezedPanes
Gets the freeze panes.
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetPanes
Gets the window panes.
Public methodGetPrintingPageBreaks
Gets automatic page breaks.
Public methodGetSelectedRanges
Gets selected ranges of cells in the designer spreadsheet.
Public methodGetType
Gets the type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodMoveTo
Moves the sheet to another location in the spreadsheet.
Public methodProtect(ProtectionType)
Protects worksheet.
Public methodCode exampleProtect(ProtectionType, String, String)
Protects worksheet.
Public methodRefreshPivotTables
Refreshes all PivotTables in this Worksheet.
Public methodRemoveAllDrawingObjects
Removes all drawing objects in this worksheet.
Public methodRemoveAutoFilter
Removes the auto filter of the worksheet.
Public methodRemoveSplit
Removes splitted window.
Public methodReplace
Replaces all cells' text with a new string.
Public methodSelectRange
Selects a range.
Public methodSetBackground Obsolete.
Sets worksheet background image.
Public methodSetVisible
Sets the visible options.
Public methodSplit
Splits window.
Public methodToString
Returns a string represents the current Worksheet object.
Public methodUnFreezePanes
Unfreezes panes in the worksheet.
Public methodUnprotect
Unprotects worksheet.
Public methodUnprotect(String)
Unprotects worksheet.
Public methodXmlMapQuery
Query cell areas that mapped/linked to the specific path of xml map.
See Also