The XLSheet type exposes the following members.

Methods

  Name Description
Public method Clone
Creates a copy of this sheet.
Public method CopyFormula
Copies the formula from a source cell to a destination cell, adjusting relative references.
Public method Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public method GetCell
Gets a reference to a cell at the specified coordinates or null if the cell doesn't exist.
Public method GetFormattedText
Gets formatted text is using XLStyle format value of the cell.
Public method GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object.)
Public method Load(Stream, Boolean)
Loads the Excel worksheet from a stream.
Public method Load(String, Boolean)
Loads the Excel worksheet from a file.
Public method LoadCsv(Stream)
Loads data from a stream containing comma-separated values (.csv) into the current sheet.
Public method LoadCsv(String)
Loads data from a file containing comma-separated values (.csv) into the current sheet.
Public method SaveCsv(Stream)
Saves data from the current sheet into a comma-separated values (.csv) formatted stream.
Public method SaveCsv(String)
Saves data from the current sheet into a comma-separated values (.csv) formatted file.
Public method ToString
Returns a string that represents the current object.
(Inherited from Object.)

Properties

  Name Description
Public property Book
Gets a reference to the C1XLBook that owns the sheet.
Public property ColumnMaxLevel
Gets maximum outline level for columns.
Public property Columns
Gets a reference to sheet's column collection.
Public property ConditionalFormattings
Gets the collection of XLConditionalFormatting objects for the current workbook.
Public property DefaultColumnWidth
Gets or sets the default column width for the sheet (in twips).
Public property DefaultRowHeight
Gets or sets the default row height for the sheet (in twips).
Public property GridColor
Gets or sets the color used to display gridlines.
Public property Item
Gets the cell at a specified position on the sheet, creating a new cell if necessary.
Public property Locked
Gets or sets a value that determines if the sheet is locked for editing.
Public property MaxOutlineLevel
Gets the maximum subtotals outline level for rows or columns.
Public property MergedCells
Gets an XLCellRangeCollection that contains the collection of cells that are merged on the sheet.
Public property Name
Gets or sets the name of the XLSheet.
Public property OutlinesBelow
Gets or sets a value indicating the vertical location of outline buttons.
Public property OutlinesRight
Gets or sets a value indicating the horizontal location of outline buttons.
Public property PrintSettings
Gets or sets an XLPrintSettings object that controls how the sheet is printed.
Public property RowMaxLevel
Gets maximum outline level for rows.
Public property Rows
Gets a reference to the sheet's row collection.
Public property Scale
Gets or sets the view scale of this worksheet using percentages.
Public property SelectedCells
Gets an XLCellRangeCollection that contains the collection of cells that are selected on the sheet.
Public property ShowGridLines
Gets or sets whether Excel should show the grid lines when displaying the sheet.
Public property ShowHeaders
Gets or sets whether Excel should show the row and column headers when displaying the sheet.
Public property ShowZeros
Gets or sets whether Excel should show the zero values on the sheet.
Public property TabColor
Gets or sets the color used to display the tab of this sheet.
Public property TotalsBelowData
Gets whether Excel should show the subtotals data when displaying the sheet.
Public property Visible
Gets or sets the sheet's visibility.

See Also