Spread WPF 17
GrapeCity.Excel Namespace / IExcelWorksheet Interface
Properties Methods

In This Topic
    IExcelWorksheet Interface Members
    In This Topic

    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