• DR-IT Software
  • Products
  • Documentation
  • Product page
  • Examples
  • API reference
  • Support
Show / Hide Table of Contents

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.

Back to top

DR-IT Software documentation

DR-IT Software · Products · Documentation index · Product page · Downloads · Support · Licensing

Generated by DocFX