Winnovative Excel Library

ExcelWorksheet Properties

Winnovative Excel Library Documentation

The ExcelWorksheet type exposes the following members.

Properties

  NameDescription
Public propertyCharts
Gets the charts collection of this worksheet.
Public propertyComments
Gets the comments collection of this worksheet.
Public propertyHorizontalPageBreaks
Gets the collection of horizontal page breaks of this worksheet.
Public propertyHyperlinks
Gets the collection of hyperlinks of this worksheet
Public propertyItemString
Gets range referenced by the range name or range reference string in A1 notation.
Public propertyItemInt32, Int32
Gets the specified cell in the worksheet.
Public propertyItemInt32, Int32, Int32, Int32
Gets cells range specified the the higher left and lower right coordinates.
Public propertyName
Gets or sets the worksheet name.
Public propertyNamedRanges
Gets the named ranges collection of this worksheet (Worksheet scope named ranges).
Public propertyPageSetup
Gets the worksheet page setup options (paper size, page orientation, etc.).
Public propertyPictures
Gets the pictures collection of this worksheet.
Public propertySheetIndex
Gets the index of this worksheet in the workbook sheets collection.
Public propertyShowGridLines
Gets or sets a flag indicating if the worksheet grid lines are visible or not. Default value is true.
Public propertyUsedRange
Gets the used range on the specified worksheet.
Public propertyUsedRangeCells
Gets the cells in the used range of the worksheet.
Public propertyUsedRangeColumns
Gets an arrat of Range objects representing all the columns in the used range of the worksheet.
Public propertyUsedRangeRows
Gets a an array of Range objects representing all the rows in the used range of the worksheet.
Public propertyVerticalPageBreaks
Gets the collection of vertical page breaks of this worksheet.
Public propertyWorkbook
Gets the parent workbook of this worksheet.
Public propertyWorksheetSecurity
Gets an object used to manage the worksheet security options like password protection.
Top
See Also

Reference