GrapeCity.Xaml.Excel
IExcelWorksheet Interface Members
Properties  Methods 

The following tables list the members exposed by IExcelWorksheet.

Public Properties
 NameDescription
 PropertyActiveColumnIndex Gets or sets the index of the active column.  
 PropertyActiveRowIndex Gets or sets the index of the active row.  
 PropertyAutoFilter Gets or sets the auto filter used in the worksheet.  
 PropertyColumnCount Gets or sets the column count of the sheet.  
 PropertyColumnGutter Gets or sets the column gutter.  
 PropertyColumnMaxOutlineLevel Gets or sets the column max outline level.  
 PropertyConditionalFormat Gets or sets the conditional formats used in the worksheet.  
 PropertyDefaultColumnWidth Gets or sets the default width of the column.  
 PropertyDefaultRowHeight Gets or sets the default height of the row.  
 PropertyDefaultViewport Gets or sets the default viewport information of the worksheet.  
 PropertyExtendedFormats Gets or sets the extended formats for the worksheet.  
 PropertyFrozenColumnCount Gets or sets the frozen column count.  
 PropertyFrozenRowCount Gets or sets the frozen row count.  
 PropertyGridLineColor Gets or sets the color of the grid line.  
 PropertyIsLocked Gets or sets a value indicating whether this instance is locked.  
 PropertyIsVisible Gets or sets a value indicating whether this instance is visible.  
 PropertyItemGets the IExcelCell with the specified location  
 PropertyMergedCells Gets or sets the merged cells information.  
 PropertyName Gets or sets the sheet name.  
 PropertyNamedCellRanges Gets or sets the named cell ranges information  
 PropertyPrintArea Gets or sets the print area information of the worksheet.  
 PropertyPrintSettings Gets or sets the print settings of the sheet.  
 PropertyPrintTitle Gets or sets the print title information of the worksheet.  
 PropertyRightToLeftColumns Gets or sets a value indicating whether the sheet is in 'right to left' display mode  
 PropertyRowCount Gets or sets the row count of the sheet.  
 PropertyRowGutter Gets or sets the row gutter.  
 PropertyRowMaxOutlineLevel Gets or sets the row max outline level.  
 PropertySelections Gets the selection information.  
 PropertySheetTabColor Gets or sets the color of the sheet tab.  
 PropertyShowFormulas Gets or sets a value indicating whether this sheet should display formulas.  
 PropertyShowGridLines Gets or sets a value indicating whether show gridlines or not.  
 PropertyShowHeaders Gets or sets a value indicating whether show headers.  
 PropertyShowZeros Gets or sets a value indicating whether the window should show 0 (zero) in cells containing zero value.  
 PropertySparklineGroups Gets or sets the groups of sparklines on the sheet.  
 PropertySummaryColumnsToRightOfDetail Get or set the direction of the summary columns.  
 PropertySummaryRowsBelowDetail Get or set the direction of the summary rows.  
 PropertyZoom Gets or sets the zoom factor of the sheet.  
Top
Public Methods
 NameDescription
 MethodGetCell Gets the cell at the specified row and column.  
 MethodGetColumn Gets the column at the specified column index  
 MethodGetDataValidations Gets the all data validation setting in the worksheet.  
 MethodGetNonEmptyCells Gets the non empty cells.  
 MethodGetNonEmptyColumns Gets the non-empty columns.  
 MethodGetNonEmptyRows Gets the non-empty rows.  
 MethodGetRow Gets the row at the specified column index  
 MethodGetSheetCharts Returns all charts defined in the current worksheet.  
 MethodGetSheetImages Returns all images defined in the current worksheet.  
 MethodGetSheetTables Returns all tables defined in the current worksheet.  
 MethodGetSpanCell Gets the range of cells that are spanned at a specified cell in this sheet.  
 MethodGetTopLeft Get the location of the top left visible cell in the current sheet  
 MethodGetValue Sets the value of the cell.  
 MethodSetColumn Initialize the column at the specified index.  
 MethodSetDataValidations Sets the data validation used in the worksheet  
 MethodSetSheetChart Add a chart to the current worksheet.  
 MethodSetSheetImage Add a image to the current worksheet.  
 MethodSetSheetTable Add a sheet table to the current worksheet.  
 MethodSetTopLeft Set the location of the top left visible cell.  
 MethodSetValue Sets the value of the cell.  
Top
See Also

Reference

IExcelWorksheet Interface
GrapeCity.Excel Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options