Namespace DRIT.Spreadsheet
Classes
AbstractBorder
Provides a base class for border implementations.
AbstractBorders
Provides a base class for border collections managing all four cell edges.
AbstractCustomFilter
Represents the abstract custom filter class used by the spreadsheet model.
AbstractCustomFilters<T>
Represents the abstract custom filters class used by the spreadsheet model.
AbstractFont
Represents the abstract font class used by the spreadsheet model.
AbstractFormattable
Abstract base class for objects that support cell formatting.
AutoFilter
Represents the auto filter class used by the spreadsheet model.
Border
Represents the border formatting for a single edge of a cell.
Borders
Represents the border formatting for all four edges of a cell or range.
Cell
Represents a single cell in a worksheet.
CellAlignment
Represents the alignment settings for cell content.
CellFill
Represents the fill formatting for a cell, including solid colors and patterns.
CellStyle
Represents a named style that can be applied to cells for consistent formatting.
CellStyleTemplate
A reusable bundle of cell formatting (font, fill, borders, alignment, number format) that can be stamped onto many cells efficiently. Equivalent to Excel's "Home > Cell Styles" and "Format Painter" functionality.
CellWatch
Represents a cell address of cell being watched in the watch window.
CellsRange
Abstract base class for ranges that represent a rectangular area of cells.
Certificate
Wraps an X.509 certificate used for digitally signing a workbook. Provides a lightweight, workbook-focused view of the underlying X509Certificate2.
Chartsheet
Represents a chart sheet in a workbook that contains only a chart.
ChartsheetChartsCollection
Represents the chartsheet charts collection class used by the spreadsheet model.
ChartsheetProtection
Represents protection settings for a chartsheet.
ChartsheetView
Represents a view of a chartsheet.
CollectionImportOptions
Represents import options for collection-based data operations.
ColorFilter
Represents the color filter class used by the spreadsheet model.
Column
Represents a column in a worksheet.
ColumnCollection
Represents a collection of columns in a worksheet.
ColumnFilter
Represents the filter column
ColumnFilterCollection
Represents the column filter collection class used by the spreadsheet model.
Comment
Represents a comment on a sheet cell.
CommentAuthor
Represents a comment author tracked across a workbook.
CommentCollection
Represents a collection of comments on a worksheet.
CommentLine
Represents the border line style of a comment.
CompositeRange
Represents a range composed of multiple simple ranges that may be non-contiguous.
CsvLoadOptions
Load options for CSV (comma-separated values) files.
CsvSaveOptions
Save options for CSV (comma-separated values) files.
CurrencyFormat
Number format for currencies.
CustomChartsheetView
Represents a custom view settings for a chart sheet.
CustomFilter
Represents the custom filter class used by the spreadsheet model.
CustomFilters
Represents the custom filters class used by the spreadsheet model.
CustomProperty
Custom property of a sheet.
CustomWorkbookView
Represents a custom view settings for a workbook.
CustomXmlPart
Represents a custom XML part in a workbook.
CustomXmlPartCollection
Represents a collection of custom XML parts in a workbook.
DataConsolidate
Represents data consolidation settings for consolidating data from multiple ranges.
DataImportExport
Provides conversions between spreadsheet ranges and tabular ADO.NET data structures.
DataReference
Represents a reference to data for consolidation operations.
DataTableExportOptions
Represents the data table export options class used by the spreadsheet model.
DataTableImportOptions
Represents the data table import options class used by the spreadsheet model.
DataValidation
Represents the data validation of a worksheet range
DataValidationCollection
Represents the data validation collection class used by the spreadsheet model.
DataValidationException
Represents the data validation exception class used by the spreadsheet model.
DataViewImportOptions
Represents the data view import options class used by the spreadsheet model.
DateGroupItem
Represents the date group item class used by the spreadsheet model.
DateTimeFormat
Represents a date/time format for cell values.
DateValuesFilter
Represents the date values filter class used by the spreadsheet model.
DefinedName
Represents a named range or formula in a workbook.
DefinedNameCollection
Stores defined names for ranges in a workbook.
Dialogsheet
Represents a dialog sheet in a workbook.
DocumentProperties
Represents document properties for a workbook.
DocumentProperty
Represents a document property.
DoubleUnit
Double value and its unit.
DynamicFilter
Represents the dynamic filter class used by the spreadsheet model.
ErrorException
Represents the error exception class used by the spreadsheet model.
FileVersion
Represents the file version class used by the spreadsheet model.
Filter
Represents the filter class used by the spreadsheet model.
Font
Represents font formatting for cells, including font family, size, color, and style attributes.
Format
Represents the format of a value.
Formats
Represents the formats class used by the spreadsheet model.
FormattableBorders
Provides access to border formatting properties for a formattable range.
FormattableCellAlignment
Provides access to alignment formatting properties for a formattable range.
FormattableCellFill
Provides access to fill formatting properties for a formattable range.
FormattableFont
Provides access to font formatting properties for a formattable range.
FormattingCellAlignment
Represents alignment formatting for a cell style.
FormattingCellBorders
Represents border formatting for a cell style.
FormattingCellFill
Represents fill formatting for a cell style.
FormattingCellFont
Represents font formatting for a cell style.
FractionFormat
Represents the fraction format class used by the spreadsheet model.
FullColumnRange
Represents a range that spans one or more full columns in a worksheet.
FullRange
Abstract base class for ranges that span entire rows or columns in a worksheet.
FullRowRange
Represents a range that spans one or more full rows in a worksheet.
GeneralFormat
Represents the general format class used by the spreadsheet model.
GradientCellFill
Represents a gradient fill for cell backgrounds.
GradientStop
Represents a color stop in a gradient fill.
HeaderFooter
Represents the header footer class used by the spreadsheet model.
HeaderFooterField
Provides named constants for the OOXML field codes used in header and footer sections. Use with HeaderFooter.Append.
HeaderFooters
Even, Odd and First page headers and footers of a sheet.
HtmlLoadOptions
Load options for HTML files.
HtmlSaveOptions
Save options for HTML files.
Hyperlink
Represents a hyperlink attached to a worksheet cell or range.
HyperlinkCollection
Represents the hyperlink collection class used by the spreadsheet model.
IconFilter
Represents the icon filter class used by the spreadsheet model.
ImportOptions
Represents the import options class used by the spreadsheet model.
InputCells
This collection describes each input cell for the scenario.
InterruptionToken
Propagates a cooperative cancellation request to long-running save, load, and export operations.
InterruptionTokenSource
Represents the interruption token source class used by the spreadsheet model.
JsonExportOptions
Options controlling how a worksheet range is exported to JSON.
JsonImportOptions
Options controlling how JSON text is imported into worksheet cells.
LicenseException
Represents the license exception class used by the spreadsheet model.
LoadOptions
Abstract base class for all load options.
LoadWarning
Represents a non-fatal warning encountered while loading a workbook. Delivered via WarningCallback immediately after load.
Macrosheet
Represents the macrosheet class used by the spreadsheet model.
MergeOptions
Options controlling how worksheets are merged from source workbooks into a target workbook.
MergeResult
Describes the outcome of a MergeFrom(IEnumerable<Workbook>, MergeOptions) operation.
NumberFormat
Represents the number format class used by the spreadsheet model.
OleObject
Represents an OLE Object on a sheet.
OleObjectCollection
Represents the ole object collection class used by the spreadsheet model.
OutlineProperties
Represents the outline properties class used by the spreadsheet model.
PageBreak
Represents the page break class used by the spreadsheet model.
PageBreakCollection
Represents the page break collection class used by the spreadsheet model.
PageMargins
Represents the page margins class used by the spreadsheet model.
PageSetup
Represents the page setup of a sheet
PageSetupPage
Represents the page setup page class used by the spreadsheet model.
PageSetupProperties
Represents the page setup properties class used by the spreadsheet model.
PageSetupWorksheet
Represents the page setup worksheet class used by the spreadsheet model.
Pane
Represents the pane class used by the spreadsheet model.
PaneCollection
Represents the pane collection class used by the spreadsheet model.
PasteOptions
Represents paste Options in the spreadsheet object model.
PercentFormat
Represents the percent format class used by the spreadsheet model.
PhoneticProperties
Represents the phonetic properties class used by the spreadsheet model.
PhoneticRun
Represents the phonetic run class used by the spreadsheet model.
PhoneticText
Represents the phonetic text class used by the spreadsheet model.
ProtectedRange
Represents a range of cells that can be edited by specific users when the worksheet is protected.
ProtectedRangeCollection
Represents a collection of protected ranges in a worksheet.
Range
Represents a set of cells in a worksheet.
RangeAccessor
Provides access to ranges within a worksheet using string-based labels.
RangeFill
Provides access to fill formatting properties for a range of cells.
RangeFont
Provides access to font formatting properties for a range of cells.
RichTextParagraph
Represents the rich text paragraph class used by the spreadsheet model.
RichTextRun
Represents the rich text run class used by the spreadsheet model.
Row
Represents a row in a worksheet.
RowCollection
Represents a collection of rows in a sheet.
SaveOptions
Abstract base class for all save/export options.
Scenario
Represents the scenario class used by the spreadsheet model.
ScenarioCollection
Represents the scenario collection class used by the spreadsheet model.
ScientificFormat
Represents the scientific format class used by the spreadsheet model.
Sheet
Base class for all sheet types in a workbook, including worksheets and chartsheets.
SheetChartsCollection
Represents a base class for chart collections on a sheet.
SheetCollection
Represents a collection of all sheet types in a workbook.
SheetFormatProperties
Represents the sheet format properties class used by the spreadsheet model.
SheetProperties
Represents a set of properties for a sheet
SheetProtection
Represents the protection of a sheet
SheetView
Represents the sheet view class used by the spreadsheet model.
SimpleRange
Abstract base class for simple (contiguous) ranges that represent a single rectangular area of cells.
SingleCellRange
Represents a range that consists of a single cell.
SortBuilder
Fluent builder for multi-level sort operations on a Range.
Created by the SortingExtensions.Sort extension method and
Sort(Range).
SortCondition
Represents the sort condition class used by the spreadsheet model.
SortState
Represents the sort state class used by the spreadsheet model.
SortingExtensions
Extension methods providing fluent sort builders on Range.
SplitOptions
Options controlling how a workbook is split into one-workbook-per-sheet results.
SpreadsheetDataFormats
Clipboard data formats supported by the spreadsheet
StandardFormats
Exposes standard cell formats
StatisticsProperties
Represents the statistics properties class used by the spreadsheet model.
StyleSheetCellStyle
Represents a cell style stored in the workbook's style sheet.
Styles
Contains style information for a workbook. In general, you should not use this class directly. Instead, you should set properties on cells and ranges.
SummaryProperties
Represents the summary properties class used by the spreadsheet model.
TagCollection
A key-value collection of string tags for custom data storage on
shapes. Keys are case-sensitive. Maps to the OOXML
p:custDataLst/p:tagLst elements.
TextFormat
Format for text
ThreadedComment
Represents a single comment in a threaded comment conversation on a worksheet cell.
ThreadedCommentAuthor
Represents an author of a threaded comment, tracked at the workbook level.
ThreadedCommentAuthorCollection
Represents the collection of threaded comment authors on a workbook.
ThreadedCommentCollection
Represents the collection of threaded comments on a worksheet.
Top10Filter
Represents the top10 filter class used by the spreadsheet model.
UnitConversionOptions
Represents the unit conversion options class used by the spreadsheet model.
UnitConverter
Represents the unit converter class used by the spreadsheet model.
ValuesFilter
Represents the values filter class used by the spreadsheet model.
WebPublishing
Represents the web publishing class used by the spreadsheet model.
Workbook
Represents a spreadsheet workbook containing worksheets, chartsheets, and other sheet types.
WorkbookCreationArguments
Specifies arguments for creating a new workbook.
WorkbookMediaExtensions
Provides access to embedded media (images) stored in a workbook's media cache.
WorkbookProperties
Represents workbook-level properties and settings.
WorkbookProtection
Represents the workbook protection class used by the spreadsheet model.
WorkbookView
Represents the workbook view class used by the spreadsheet model.
Worksheet
Represents a worksheet in a spreadsheet workbook.
WorksheetCalculationProperties
Represents the worksheet calculation properties class used by the spreadsheet model.
WorksheetCollection
Represents a collection of worksheets in a workbook.
WorksheetPageSetup
Represents the worksheet page setup class used by the spreadsheet model.
WorksheetRangeAddress
Represents a worksheet range address combining a worksheet name and range address.
WorksheetView
Represents the view settings for a worksheet.
XlsxDigitalSignatureInfo
Read-only metadata about a digital signature present in an XLSX package.
XlsxDigitalSignatureSaveOptions
Digital signature parameters for XLSX save operations.
XlsxLoadOptions
Load options for XLSX files.
XlsxSaveOptions
Save options for XLSX files.
XmlColumnProperty
Represents a column property in an XmlMap, describing how an XML element maps to a specific worksheet column.
XmlDataBinding
Represents the data binding associated with an XmlMap, describing how the XML data is connected to the workbook (file binding or connection-based binding).
XmlMap
Represents a data binding between an XML schema and worksheet cells, enabling XML data import/export. Excel UI: "Developer > Source > XML Maps".
XmlMapCollection
Represents a collection of XmlMap objects on a workbook.
Structs
CellAddress
Represents a cell address with row and column coordinates.
CellRelativeAddress
Represents a relative address between two cells.
CellSpan
Represents a span of cells defined by a row and column offset.
ColumnCellsAccessor
Provides indexed cell access for a column.
RangeAddress
Represents the address of a range as a pair of cell addresses (top-left and bottom-right corners).
RowCellsAccessor
Provides indexed cell access for a row: row.Cells[columnIndex]
Interfaces
IProgressCallback
Callback interface for reporting progress during long-running save, load, and export operations.
Enums
BorderStyle
The BorderStyle enumeration specifies the border line style.
BorderType
Specifies the type of border to set for cell formatting.
BuiltInCellStyleType
Represents the built-in cell styles available in the Excel "Home > Cell Styles" gallery.
CalendarType
Specifies the calendar type for date handling.
CellComments
Represents the options how to display cell comments.
CellMoveOrientationHint
Specifies the orientation for cell movement operations during range deletion.
CommentsDisplayType
Represents the options how the comments are displayed.
CustomPropertyType
Specifies the type of a custom property.
DataConsolidateFunction
Specifies values for the data consolidation function.
DataValidationErrorStyle
Specifies the style of error message for data validation.
DataValidationImeMode
Specifies the IME (Input Method Editor) mode for data validation.
DataValidationOperator
Specifies the operator for data validation comparisons.
DataValidationType
Specifies the type of data validation.
DateTimeGrouping
Represents the date time grouping enumeration used by the spreadsheet model.
DateTimeOrigin
Specifies the origin date for date/time calculations.
DynamicFilterType
Represents the dynamic filter type enumeration used by the spreadsheet model.
ErrorType
Represents the error type enumeration used by the spreadsheet model.
FilterOperator
Represents the filter operator enumeration used by the spreadsheet model.
FontSchemeType
Represents the font scheme type enumeration used by the spreadsheet model.
FormatCategory
Represents the format category enumeration used by the spreadsheet model.
FormatType
Represents the format type enumeration used by the spreadsheet model.
GradientType
Specifies the type of gradient fill.
HorizontalCellAlignment
Represents the horizontal cell alignment enumeration used by the spreadsheet model.
HtmlCrossType
Controls how cell content that overflows the cell boundary is handled in HTML export.
IconType
https://support.content.office.net/en-us/media/e3c875a8-1f59-43c2-9e09-436ed4a66076.gif
NameConflictResolution
Controls how sheet-name collisions are resolved during a merge operation.
NavigationDirection
Represents the navigation direction enumeration used by the spreadsheet model.
ObjectDisplayType
Represents the object display type enumeration used by the spreadsheet model.
OleObjectType
Represents the ole object type enumeration used by the spreadsheet model.
Orientation
Represents the orientation enumeration used by the spreadsheet model.
PageOrder
Represents the page order enumeration used by the spreadsheet model.
PaneState
Represents the pane state of a sheet
PaneType
Represents the pane type enumeration used by the spreadsheet model.
PaperSize
Represents the paper size enumeration used by the spreadsheet model.
PatternType
Represents the pattern type enumeration used by the spreadsheet model.
PhoneticAlignment
Represents the phonetic alignment enumeration used by the spreadsheet model.
PhoneticType
Represents the phonetic type enumeration used by the spreadsheet model.
PrintError
Specifies how cells containing errors should be printed.
ReferenceMode
Represents the reference mode enumeration used by the spreadsheet model.
ScreenMeasurementUnit
Represents the screen measurement unit enumeration used by the spreadsheet model.
SheetDefaultDirection
Possible values of the default text direction on a sheet .
SheetState
Represents the sheet state enumeration used by the spreadsheet model.
SheetType
Represents the sheet type enumeration used by the spreadsheet model.
SheetViewType
Represents the sheet view type enumeration used by the spreadsheet model.
SortBy
Represents the sort by enumeration used by the spreadsheet model.
SortMethod
Represents the sort method enumeration used by the spreadsheet model.
SortOrder
Represents the sort order enumeration used by the spreadsheet model.
SortOrientation
Represents the sort orientation enumeration used by the spreadsheet model.
SpreadsheetUnderline
Specifies the underline style for cell fonts.
StringValueType
Represents the string value type enumeration used by the spreadsheet model.
TargetScreenSize
Represents the target screen size enumeration used by the spreadsheet model.
TextDirection
Specifies the text direction in a cell.
UpdateLinks
Represents the update links enumeration used by the spreadsheet model.
ValueType
Represents the value type enumeration used by the spreadsheet model.
VerticalCellAlignment
Represents the vertical cell alignment enumeration used by the spreadsheet model.
VerticalRunAlignment
Represents the vertical run alignment enumeration used by the spreadsheet model.
WorkbookVisibility
Specifies the visibility of a workbook or worksheet.
XlsxEncryptionExpectation
Indicates what encryption type the caller expects when loading XLSX files.
XlsxEncryptionMode
Selects the package encryption mode when saving XLSX files.
XlsxXAdESType
XAdES signature level for XLSX digital signatures.