Spread Silverlight Documentation
IExcelWorksheet Interface Members
Properties  Methods 

The following tables list the members exposed by IExcelWorksheet.

Public Properties
 NameDescription
 PropertyActiveColumnIndexGets or sets the index of the active column.  
 PropertyActiveRowIndexGets or sets the index of the active row.  
 PropertyAutoFilterGets or sets the auto filter used in the worksheet.  
 PropertyColumnCountGets or sets the column count of the sheet.  
 PropertyColumnGutterGets or sets the column gutter.  
 PropertyColumnMaxOutlineLevelGets or sets the column max outline level.  
 PropertyConditionalFormatGets or sets the conditional formats used in the worksheet.  
 PropertyDefaultColumnWidthGets or sets the default width of the column.  
 PropertyDefaultRowHeightGets or sets the default height of the row.  
 PropertyDefaultViewportGets or sets the default viewport information of the worksheet.  
 PropertyExtendedFormatsGets or sets the extended formats for the worksheet.  
 PropertyFrozenColumnCountGets or sets the frozen column count.  
 PropertyFrozenRowCountGets or sets the frozen row count.  
 PropertyGridLineColorGets or sets the color of the grid line.  
 PropertyIsLockedGets or sets a value indicating whether this instance is locked.  
 PropertyIsVisibleGets or sets a value indicating whether this instance is visible.  
 PropertyItemGets the IExcelCell with the specified location  
 PropertyMergedCellsGets or sets the merged cells information.  
 PropertyNameGets or sets the sheet name.  
 PropertyNamedCellRangesGets or sets the named cell ranges information  
 PropertyPrintAreaGets or sets the print area information of the worksheet.  
 PropertyPrintSettingsGets or sets the print settings of the sheet.  
 PropertyPrintTitleGets or sets the print title information of the worksheet.  
 PropertyRightToLeftColumnsGets or sets a value indicating whether the sheet is in 'right to left' display mode  
 PropertyRowCountGets or sets the row count of the sheet.  
 PropertyRowGutterGets or sets the row gutter.  
 PropertyRowMaxOutlineLevelGets or sets the row max outline level.  
 PropertySelectionsGets the selection information.  
 PropertySheetTabColorGets or sets the color of the sheet tab.  
 PropertyShowFormulasGets or sets a value indicating whether this sheet should display formulas.  
 PropertyShowGridLinesGets or sets a value indicating whether show gridlines or not.  
 PropertyShowHeadersGets or sets a value indicating whether show headers.  
 PropertyShowZerosGets or sets a value indicating whether the window should show 0 (zero) in cells containing zero value.  
 PropertySparklineGroupsGets or sets the groups of sparklines on the sheet.  
 PropertySummaryColumnsToRightOfDetailGet or set the direction of the summary columns.  
 PropertySummaryRowsBelowDetailGet or set the direction of the summary rows.  
 PropertyZoomGets or sets the zoom factor of the sheet.  
Top
Public Methods
 NameDescription
 MethodGetCellGets the cell at the specified row and column.  
 MethodGetColumnGets the column at the specified column index  
 MethodGetDataValidationsGets the all data validation setting in the worksheet.  
 MethodGetNonEmptyCellsGets the non empty cells.  
 MethodGetNonEmptyColumnsGets the non-empty columns.  
 MethodGetNonEmptyRowsGets the non-empty rows.  
 MethodGetRowGets the row at the specified column index  
 MethodGetSheetChartsReturns all charts defined in the current worksheet.  
 MethodGetSheetImagesReturns all images defined in the current worksheet.  
 MethodGetSheetTablesReturns all tables defined in the current worksheet.  
 MethodGetSpanCellGets the range of cells that are spanned at a specified cell in this sheet.  
 MethodGetTopLeftGet the location of the top left visible cell in the current sheet  
 MethodGetValueSets the value of the cell.  
 MethodSetColumnInitialize the column at the specified index.  
 MethodSetDataValidationsSets the data validation used in the worksheet  
 MethodSetSheetChartAdd a chart to the current worksheet.  
 MethodSetSheetImageAdd a image to the current worksheet.  
 MethodSetSheetTableAdd a sheet table to the current worksheet.  
 MethodSetTopLeftSet the location of the top left visible cell.  
 MethodSetValueSets the value of the cell.  
Top
See Also

Reference

IExcelWorksheet Interface
GrapeCity.Excel Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.