Spread WPF 17
GrapeCity.Excel Namespace / ExcelWorksheet Class
Properties Methods

In This Topic
    ExcelWorksheet Class Members
    In This Topic

    The following tables list the members exposed by ExcelWorksheet.

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

    Reference

    ExcelWorksheet Class
    GrapeCity.Excel Namespace