Namespace IronXL

Classes

Cell

Represents a Cell in an Excel WorkSheet.

ExcelFileFormat

Enum that represents the Excel file format which will be used for new workbook creation.

XLS or XLSX (preferred).

License

Allows IronXL license keys to be applied globally across an application.

Range

A class that represents a range of cells

RangeAddress

Class that represents address of the range.

RangeColumn

A class that represents a single column of cells.

RangeRow

A class that represents a single row of cells.

SortOrder

Represents sorting order

StreamCell

A single cell value read while forward-only streaming through an XLSX worksheet. Immutable snapshot: unlike Cell, a StreamCell is not backed by the workbook and cannot be used to write values back.

StreamCellType

Identifies the kind of value held by a StreamCell encountered while forward-only streaming through an XLSX worksheet.

StreamReadOptions

Options for a forward-only StreamRows(String, StreamReadOptions) read: which worksheet to stream and whether the first read row is a header.

StreamRow

A single row of StreamCell values read while forward-only streaming through an XLSX worksheet. Cells is sparse: only columns that actually had content in the source row are present, so gaps must be looked up via the indexer.

WorkBook

Class that stands for a whole Excel file. This is the first object most users will construct whether they are reading or writing a workbook. It is also the top level (home-base) object for creating new sheets and most other Excel programming operations.

WorkSheet

Class that stands for single sheet within Excel file.

WorksheetsCollection

Class for managing the collection of WorkSheet elements.