C1.Silverlight.Excel Namespace : XLSheet Class |
The following tables list the members exposed by XLSheet.
Name | Description | |
---|---|---|
Book | Gets a reference to the C1XLBook that owns the sheet. | |
ColumnMaxLevel | Gets maximum outline level for columns. | |
Columns | Gets a reference to sheet's column collection. | |
ConditionalFormattings | Gets the collection of XLConditionalFormatting objects for the current workbook. | |
DefaultColumnWidth | Gets or sets the default column width for the sheet (in twips). | |
DefaultRowHeight | Gets or sets the default row height for the sheet (in twips). | |
GridColor | Gets or sets the color used to display gridlines. | |
Item | Gets the cell at a specified position on the sheet, creating a new cell if necessary. | |
Locked | Gets or sets a value that determines if the sheet is locked for editing. | |
MaxOutlineLevel | Gets the maximum subtotals outline level for rows or columns. | |
MergedCells | Gets an XLCellRangeCollection that contains the collection of cells that are merged on the sheet. | |
Name | Gets or sets the name of the XLSheet. | |
OutlinesBelow | Gets or sets a value indicating the vertical location of outline buttons. | |
OutlinesRight | Gets or sets a value indicating the horizontal location of outline buttons. | |
PrintSettings | Gets or sets an XLPrintSettings object that controls how the sheet is printed. | |
RowMaxLevel | Gets maximum outline level for rows. | |
Rows | Gets a reference to the sheet's row collection. | |
Scale | Gets or sets the view scale of this worksheet using percentages. | |
SelectedCells | Gets an XLCellRangeCollection that contains the collection of cells that are selected on the sheet. | |
ShowGridLines | Gets or sets whether Excel should show the grid lines when displaying the sheet. | |
ShowHeaders | Gets or sets whether Excel should show the row and column headers when displaying the sheet. | |
ShowZeros | Gets or sets whether Excel should show the zero values on the sheet. | |
TabColor | Gets or sets the color used to display the tab of this sheet. | |
TotalsBelowData | Gets whether Excel should show the subtotals data when displaying the sheet. | |
Visible | Gets or sets the sheet's visibility. |
Name | Description | |
---|---|---|
Clone | Creates a copy of this sheet. | |
CopyFormula | Copies the formula from a source cell to a destination cell, adjusting relative references. | |
GetCell | Gets a reference to a cell at the specified coordinates or null if the cell doesn't exist. | |
GetFormattedText | Gets formatted text is using XLStyle format value of the cell. | |
Load | Overloaded. Loads the Excel worksheet from a file. | |
LoadCsv | Overloaded. Loads data from a file containing comma-separated values (.csv) into the current sheet. | |
SaveCsv | Overloaded. Saves data from the current sheet into a comma-separated values (.csv) formatted file. |