Description
Excel Jetcell.NET component provides high-quality and easy-in-use solution to read/create/rewrite native Microsoft Excel files (XSLX, XLS, CSV) without Microsoft Excel on client machine. For quick start look at samples folder in the component package. Main class below is ExcelWorkbook, which represents in-memory the Excel file.

Types

                             
  All Types     Classes      Structures     Enumerations     Delegates  
  Name Description
ColorPalette
This class contains the definition of all user-defined colours available for ExcelCell.
DefinedFormats
Represents a list of common used formats.
ExcelCell
ExcelCell provides access to a single worksheet cell or to a merged range if the cell is merged.
ExcelCellAnchor
This element specifies a two cell anchor placeholder for a group, a shape, or a drawing element.
ExcelCellAnchorAddress
This element specifies the anchor point for the drawing element.
ExcelCellBorder
Contains settings of ExcelCell border lines.
ExcelCellCollection
Collection of cells (ExcelCell).
ExcelCellFont
This class contains font related settings.
ExcelCellHyperlink
Allows to created hyperlink to URL, to external file, to cell in the workbook.
ExcelCellRange
Represents cell range of ExcelCell elements contained in ExcelRow, ExcelColumn.
ExcelCellStyle
Contains settings specifying how the ExcelCell data will be displayed.
ExcelColumn
ExcelColumn contains the properties of a single column and column cells.
ExcelColumnCollection
Collection of Excel column (ExcelColumn).
ExcelHeaderFooter
Represents the Header/Footer of ExcelWorksheet.
ExcelPanes
This record stores the position of window panes.
ExcelPicture
Picture object used by ExcelPictureCollection in the ExcelWorksheet.
ExcelPictureAnchor
This simple type specifies all possible settings for how DrawingML contents shall be resized when the rows and columns between its start and ending anchor (the from and to child elements) are resized, or have additional rows/columns inserted within them.
ExcelPictureCollection
Collection of the ExcelPicture.
ExcelRow
ExcelRow contains the properties of a single row and row cells.
ExcelRowCollection
Collection of excel row (ExcelRow).
ExcelWorkbook
Represents a ExcelWorkbook.
ExcelWorksheet
Excel worksheet is a table with additional properties, identified by an unique name.
ExcelWorksheetCollection
Collection of (ExcelWorksheet).
ExcelWorksheetProtection
Represents options of worksheet protection.
HorizontalPageBreak
Specifies a horizontal position where the new page begins when the worksheet is printed.
HorizontalPageBreakCollection
Collection of horizontal page breaks (HorizontalPageBreak).
PrintArea
Represets set methods for set print area.
ProgressEventArgs
Holds event data for events [!:ExcelWorkbook.SavingProgress] and [!:ExcelWorkbook.ReadingProgress].
ProgressEventHandler
Represents the method that will handle the [!:ExcelWorkbook.SavingProgress] and [!:ExcelWorkbook.ReadingProgress].
RichTextString
Represents rich text.
RichTextStruct
Represents rich text string.
TypeOfActivePane
Type of Active Pane
TypeOfBorderLine
Represents the style of borderline of ExcelCell.
TypeOfCellDataFormat
Defined type cell data format.
TypeOfCsvDelimeter
Formatting type for CSV files.
TypeOfDiagonal
Represents the types of diagonal line of cell.
TypeOfFillPattern
Represents the types of style of fill pattern foreground.
TypeOfHAlignment
Represents the types of horizontal alignment.
TypeOfHeaderFooter
Represents type of Header/Footer.
TypeOfMultipleBorders
Flags for borders and border groups that can be set on the excel cell.
TypeOfScript
Represents the types of script of ExcelCellFont
TypeOfUnderline
Represents the types of style underline.
TypeOfVAlignment
Represents the types of vertical alignment.
VerticalPageBreak
Each class contains the following data: Index to first column of this page break; Index to first row of this page break; Index to last row of this pag break.
VerticalPageBreakCollection
Collection of vertical page breaks (VerticalPageBreak).
WorkbookOptions
Options specified when reading CSV files.
WorksheetOptions
Excel worksheet view related options.
WorksheetOrientation
Represent worksheet orientation.