ISExcelWorksheet Class

Represents a Microsoft Excel Worksheet.

Methods

Name Description
Calculate Performs a calculation of the Worksheet.
Cell Returns a Cell based upon a Cell Reference, e.g. "A1", "D25".
CellByNamedRange Returns the top/ left Cell in the Named Range, or Nothing if the Named Range is invalid.
Clear Clears the contents of the Worksheet.
Columns System Use Only The collection of Columns in the Worksheet.
CreateCellRange
FreezePanes Freezes rows and/or columns in the worksheet. Frozen rows and columns remain visible when the user scrolls the worksheet.
GetNamedRangeInformation Gets information about a Named Range.
GetUsedRangeInformation Gets information about the Used Range of Cells.
ImportFromDataView Imports data from a Dataview.
Print Prints the Worksheet.
Rows System Use Only The collection of Rows in the Worksheet.
SetPrintArea Sets the area of the Worksheet to Print.
Sort Sorts cells within a Range of Cells.
UpdateCellsToFormattedValue Replaces all Cell values with the formatted Value by applying the Cell's NumberFormat.

Properties

Name Description
Columns2 Read-Only The collection of Columns in the Worksheet.
Gembox_ExcelWorksheet Read-Only System Use Only
Name The unique Name of the Worksheet.
PrintGridLines Determines whether to print Grid Lines.
Rows2 Read-Only The collection of Rows in the Worksheet.
Workbook Read-Only The parent Workbook the Worksheet belongs to.
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0