Winnovative Excel Library for .NET
Winnovative.ExcelLib Namespace
NamespacesWinnovative.ExcelLib
Winnovative Excel Library for .NET
The root namespace of the Winnovative Excel Library for .NET
Declaration Syntax
C#Visual BasicVisual C++
namespace Winnovative.ExcelLib
Namespace Winnovative.ExcelLib
namespace Winnovative.ExcelLib
Types
All TypesClassesEnumerations
IconTypeDescription
ExcelCellAlignment
Represents the alignment style options of the text in a cell.

ExcelCellBorder
Represents one of the borders of a range or style

ExcelCellBorderIndex
Specifies the index of the border to be retrieved from a borders collection.

ExcelCellBordersCollection
Represents a collection of four borders of a Range or a Style. A border index can be used to identify the Border object

ExcelCellFill
Represents the interior style of a cell or range of cells.

ExcelCellFillGradient
Represents a gradient fill options for a cell or range.

ExcelCellFillPattern
Represents the pattern fill of a cell interior

ExcelCellFillPatternType
The interior pattern of a cell

ExcelCellFillSolid
Represents the solid fill for a cell interior.

ExcelCellFillType
Represents the type of interior for cell or range of cells.

ExcelCellHorizontalAlignmentType
The horizontal alignment of data in a cell

ExcelCellLineStyle
Enumeration of the border line styles for cells in Excel.

ExcelCellNumber
Represents the number format options for a cell or a range of cells.

ExcelCellProtection
Represents the protection options for a cell or a range of cells.

ExcelCellStyle
Represents the style of a cell or a range of cells.

ExcelCellStylesCollection
Represents a collection of cell styles. The ExcelWorkbook offers such a collection containing all the styles created in the workbook.

ExcelCellTextDirectionType
Specifies the reading order for the cell

ExcelCellUnderlineType
Represents the underline style of the text in a cell

ExcelCellVerticalAlignmentType
The vertical alignment of data in a cell

ExcelChart
Represents a chart shape in a worksheet.

ExcelChartArea
Represents an area in an Excel chart.

ExcelChartAxisLabelPosition
Represents the axis labels position from the chart axis

ExcelChartCategoryAxis
Represents the category axis (horizontal axis) of a chart

ExcelChartCategoryAxisType
Represents the type of the category axis of a chart

ExcelChartDataPoint
Represents a data point in the chart.

ExcelChartDataPointLabel
Represents the label of a chart data point

ExcelChartDataPointsCollection
Represents a collection of data points in a chart series

ExcelChartDataTable
Represents the formatting options for the chart data table.

ExcelChartFormattedText
Represents a formatted text area in a chart.

ExcelChartInterior
Represents the interior of a chart element

ExcelChartLegend
Represents the legend of a chart.

ExcelChartLegendEntriesCollection
Represents the collection of legend entries for a picture.

ExcelChartLegendEntry
Represents and entry in the chart legend.

ExcelChartLegendPosition
Represents the chart legend position in chart area.

ExcelChartLine
Represents the border of a chart element

ExcelChartLineType
Represents the type of line for a chart element border.

ExcelChartLineWeightType
Represents the weight of a chart border line

ExcelChartRotation3D
Represents the rotation properties for a 3D chart.

ExcelChartsCollection
Represents the collection of charts in a worksheet

ExcelChartSeries
Represents a data series in a Excel chart

ExcelChartSeriesAxis
Represents the series axis (depth axis) of a chart

ExcelChartSeriesCollection
Represents a collection of chart series.

ExcelChartTickMarkType
Represents the chart axis tick marks type

ExcelChartTimeUnit
Represents the time unit for category axis

ExcelChartType
Enumeration of the Chart types in Excel.

ExcelChartValueAxis
Represents the value axis (vertical axis) of a chart

ExcelChartValueDisplayUnits
The display units for the value axis.

ExcelChartWorksheet
Represents a chart worksheet.

ExcelChartWorksheetPageSetup
Represents the chart worksheet page setup

ExcelChartWorksheetsCollection
Represents a colection of chart worksheets in a workbook.

ExcelColorsPalette
Represents the Excel colors palette.

ExcelComment
Represents a comment in a mec.

ExcelCommentsCollection
Represents a collection of comments in a worksheet

ExcelDataValidator
Represents a data type validator for a range of cells.

ExcelDataValidatorDataType
Represents the data types allowed by a data validator.

ExcelDataValidatorErrorStyle
Represents the style of the error alert for data validator.

ExcelDataValidatorOperator
Represents a comparison operator used by a data validator.

ExcelDeleteShiftDirection
Describes how the cells are shifted to replace deleted cells.

ExcelDocumentProperties
The document properties like title, subject, keywords, author, etc.

ExcelDocumentSecurity
Manage the document security like workbook structure and windows protection, open/write password protection.

ExcelFont
Represents a font in the Excel workbook

ExcelGradientColors
Represents the colors mode of a gradient

ExcelGradientDirection
Represents the possible directions of the gradient

ExcelGradientVariants
Represents the variants for a gradient direction.

ExcelGroupBy
Describes how to group the range.

ExcelHyperlink
Represents a hyperlink in the worksheet hyperlinks collection.

ExcelHyperlinksCollection
Represents a collection of hyperlinks

ExcelHyperlinkType
Represents the type of URL in a worksheet.

ExcelLibException
Exception thrown by the Excel library

ExcelNamedRange
Represents a named range in a worksheet. Named ranges can be added to the worksheet or workbook named ranges collection.

ExcelNamedRangesCollection
Represents a collection of named ranges. The ExcelWorksheet and ExcelWorkbook define such collections.

ExcelNamedRangeScopeType
Represents the scope of a named range.

ExcelPageBreak
Represents a horizontal or vertical page break in worksheet

ExcelPageBreaksCollection
Represents a collection of page breaks.

ExcelPageBreakType
Represents the type of pae break (horizontal or vertical).

ExcelPageOrientation
Represents the page orientation of a worksheet.

ExcelPagePaperSize
Represents the paper size for an Excel document.

ExcelPagePrintCommLocation
Represents the location where the comments in a worksheet will be printed.

ExcelPagePrintErrorsMode
Represents the mode of printing errors.

ExcelPagePrintOrder
Specifies the order in which cells are processed.

ExcelPageSetup
Represents the Excel page setup.

ExcelPicture
Represents a picture in a worksheet.

ExcelPicturesCollection
Represents a collection of picture in a worksheet.

ExcelProtectionAllowFlags
The allowed operations for a protected worksheet.

ExcelRange
Represents a range of cells in a worksheet

ExcelRangesCollection
Represents a collection of ranges in a worksheet.

ExcelShapeFill
Represents the interior of a shape

ExcelShapeFillGradient
Represents a gradient fill options for a shape.

ExcelShapeFillPattern
Represents the pattern fill of a shape interior.

ExcelShapeFillPatternType
Represents the possible patterns of shape interior.

ExcelShapeFillPicture
Represents a picture fill of a shape interior.

ExcelShapeFillPresetGradientType
Represents the available preset gradients

ExcelShapeFillSolid
Represents the solid fill for a shape interior.

ExcelShapeFillTexture
Represents the texture fill of a shape interior.

ExcelShapeFillTextureType
Represents the possible textures of the shape interior.

ExcelShapeFillType
Represents the type of interior of a shape.

ExcelUnitsConverter
Utility class to convert between various Excel measurement units (points, pixels, width characters)

ExcelWorkbook
The Excel Workbook

ExcelWorkbookDefaultSettings
A class encapsulating the default options (font, row height, column width) for a newly created workbook.

ExcelWorkbookFormat
The Excel workbook format

ExcelWorksheet
Excel Worksheet

ExcelWorksheetPageSetup
Represents the Excel page setup for a worksheet.

ExcelWorksheetsCollection
Represents the collection of Excel worksheets in a workbook

ExcelWorksheetSecurity
Manages the security options for a worksheet.