GrapeCity.Xaml.Excel
ExcelWorksheet Class Members
Properties  Methods 


The following tables list the members exposed by ExcelWorksheet.

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

Reference

ExcelWorksheet Class
GrapeCity.Excel Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options