xlsio library Null safety

Classes

AboveBelowAverage
Represents the above or below conditional formatting rule. Applying this rule to a range helps you highlight the cells which contain values above or below the average of selected range.
Border
Represent cell individual border.
Borders
Represents cell borders
BordersCollection
Represents cell borders
BordersCollectionWrapper
Represents cell borders
CalcEngine
CalcEngine encapsulates the code required to parse and compute formulas.
CellBorder
Represent cell individual border.
CellBorderWrapper
Represent wrapper class for cell individual border.
CellStyle
Represent the Cell style class.
CellStyleWrapper
Represent the Cell Style Wrapper class.
ChartHelper
Base class for charts
ColorConditionValue
Represents condition value for colorset condition.
ColorScale
Represents a color scale conditional formatting rule.
Column
Represents the colunm class.
ColumnCollection
Reprsents the colunm collection.
ConditionalFormat
Represents a conditional format.
ConditionalFormats
Represents a collection of conditional formats.
ConditionValue
Represents implementation of single condition value for iconset, databar, colorscale conditions.
CultureInfo
Represent the Culture Info class.
DataBar
Represents a data bar conditional formatting rule. Applying a data bar to a range helps you see the value of a cell relative to other cells.
DataValidation
Represents data validation for a worksheet range.
DateTimeFormatInfo
Represents the Date Time Format Info class.
ExcelDataCell
Represents the data cell for importing data.
ExcelDataRow
Represents the data cell for importing data.
ExcelSheetProtectionOption
Represents worksheet protection options.
ExcelTable
Represents a Table in a Worksheet.
ExcelTableCollection
Represents collections of tables in a worksheet.
ExcelTableColumn
Represents a column in the table.
Font
Represents cell font.
FormatsCollection
FormulaInfo
FormulaInfo maintains information on a single formula object.
Represent the Hyperlink object.
HyperlinkCollection
Represents Worksheet Hyperlink collection.
IconConditionValue
Represents a condition value for IconSet conditions.
IconSet
Represents a set of icons that are used in an icon set conditional formatting rule.
MergeCell
Represents merged cell.
MergedCellCollection
Represents merged cell collection class.
NumberFormatInfo
Represents the Number Format Info class.
Picture
Represent the Excel image.
PicturesCollection
Represents worksheet collection.
Range
Represent the Range
RangeCollection
Represents the worksheet rows.
Row
Represents the worksheet row.
RowCollection
Represents the worksheet rows.
SerializeWorkbook
Represent the workbook serialize.
SheetFamilyItem
Encapsulates the properties that are needed to support multiple families of crossed-referenced grids.
Stack
Represent stack class.
Style
Represents the Style class.
StylesCollection
Represents styles collection.
TextInfo
Represents the Text info class.
TopBottom
Represents the top or bottom conditional formatting rule. Applying this rule to a range helps you highlight the top or bottom ā€œnā€ cells from the selected range.
Workbook
Represents an Excel Workbook.
Worksheet
Represents a worksheet in a workbook.
WorksheetCollection
Represents worksheet collection.

Enums

BuiltInStyles
Represents the Built in Styles.
CellType
Specifies the excel cell types.
CFTimePeriods
Specifies the time periods for date time conditional formatting in Excel.
ConditionalFormatOperator
Specifies the type of conditions that can be used for Icon sets
ConditionValueType
Specifies the types of condition values.
DataBarAxisPosition
Specifies the axis position for a range of cells with conditional formatting as data bars.
DataBarDirection
Defines the directions of data bar in conditional formatting.
ExcelCFAverageType
Specifies whether the AboveBelowAverage conditional formatting rule looks for cell values above or below the average.
ExcelCFTopBottomType
Specifies whether the TopBottom conditional formatting rule looks for ranking from the top or bottom.
ExcelCFType
Specifies whether the conditional format is based on a cell value or an expression.
ExcelComparisonOperator
Specifies the comparison operator for conditional formatting in Excel.
ExcelDataValidationComparisonOperator
Specifies comparison operators for data validation.
ExcelDataValidationErrorStyle
Represents possible error style values.
ExcelDataValidationType
Specifies the type of validation test to be performed in conjunction with values.
ExcelFormatType
Possible format types.
ExcelHyperlinkAttachedType
Specify the hyperlink attached object name.
ExcelIconSetType
Specifies the type of icon set.
ExcelInsertOptions
Represents a possible insert options in Excel.
ExcelSheetProtection
Represents sheet protection flags enums.
ExcelTableBuiltInStyle
Represents Excel table styles which are built-in.
ExcelTableTotalFormula
Represents a function used for total calculation.
HAlignType
Specifies the horizontal alignment options for cell formatting.
HyperlinkType
Possible types of hyperlinks.
LineStyle
Specifies the line style for the cell border.
VAlignType
Specifies the vertical alignment options for cell formatting.