Namespace SlapKit.Excel.Excel
Classes
- Blank
A blank value. Used as a value of blank cells or as an optional argument for function calls.
- LoadOptions
A class that defines various aspects of a newly created workbook.
- XLHelper
Common methods
- XLPredefinedFormat
Reference point of date/number formats available. See more at: https://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.numberingformat.aspx
Structs
- XLCellValue
A value of a single cell. It contains a value a specific Type. Structure provides following group of methods:
Is*properties to check type (IsNumber, IsBlank...)Get*methods that return the stored value or throw InvalidCastException for incorrect type.- Explicit operators to convert
XLCellValueto a concrete type. It is an equivalent ofGet*methods. TryConvertmethods to try to get value of a specific type, even if the value is of a different type.
Interfaces
- IXLAddress
Reference to a single cell in a workbook. Reference can be absolute, relative or mixed. Reference can be with or without a worksheet.
- IXLAddressable
A very lightweight interface for entities that have an address as a rectangular range.
- IXLPivotCache
A cache of pivot data - essentially a collection of fields and their values that can be displayed by a IXLPivotTable. Data for the cache are retrieved from an area (a table or a range). The pivot cache data are cached, i.e. the data in the source are not immediately updated once the data in a worksheet change.
- IXLPivotCaches
A collection of pivot caches. Pivot cache can be added from a IXLRange or a IXLTable.
- IXLPivotValue
A pivot value field, it is basically a specification of how to determine and format values from source to display in the pivot table.
- IXLPivotValueCombination
An interface for fluent configuration of how to show IXLPivotValue, when the value should be displayed not as a value itself, but in relation to another value (e.g. percentage difference in relation to different value).
Enums
- XLDataType
A value that is in the cell.
- XLError
A formula error.
- XLFontScheme
A font theme scheme. Theme has categories of fonts and when the theme changes, texts that are associated with the particular theme scheme are switched to a font of a new theme.
- XLItemsToRetain
Specifies the number of unused items to allow in a IXLPivotCache before discarding unused items.
- XLTransposeOptions
A behavior of extra outside cells for transpose operation. The option is meaningful only for transposition of non-squared ranges, because squared ranges can always be transposed without effecting outside cells.