Namespace DRIT.Spreadsheet
Classes
AbstractBorder
AbstractBorders
AbstractCustomFilter
AbstractCustomFilters<T>
AbstractFont
AbstractFormattable
AutoFilter
Border
Contains information about the border of a cell
Borders
Describes the borders on a cell or range.
Cell
Represents a cell in a sheet.
CellAlignment
CellFill
Represents a base class for a cell fill.
CellsRange
CellStyle
CellWatch
Represents a cell address of cell being watched in the watch window.
Chartsheet
ChartsheetChartsCollection
ChartsheetProtection
ChartsheetView
ChildGroup
CollectionImportOptions
ColorFilter
Column
ColumnCollection
Represents a collection of columns in a sheet
ColumnFilter
Represents the filter column
ColumnFilterCollection
ColumnGroup
Comment
Represents a comment on a sheet cell.
CommentCollection
Represents a collection of comments on a worksheet.
CommentLine
Represents the border line style of a comment.
CompositeRange
Represents a range made of simple ranges
CurrencyFormat
Number format for currencies.
CustomChartsheetView
CustomFilter
CustomFilters
CustomProperty
Custom property of a sheet.
CustomWorkbookView
DataConsolidate
DataImportExport
DataReference
DataTableExportOptions
DataTableImportOptions
DataValidation
Represents the data validation of a worksheet range
DataValidationCollection
DataValidationException
DataViewImportOptions
DateGroupItem
DateTimeFormat
DateValuesFilter
DefinedName
Represents a defined name of a workbook or sheet. A defined name binds a name to a formula
DefinedNameCollection
Stores defined names for ranges in a workbook.
Dialogsheet
DocumentProperties
DocumentProperty
Represents a document property.
DoubleUnit
Double value and its unit.
DynamicFilter
ErrorException
FileVersion
Filter
Font
Format
Represents the format of a value.
Formats
FormattableBorders
FormattableCellAlignment
FormattableCellFill
FormattableFont
Represents a Font which is linked to a formattable element.
FormattingCellAlignment
FormattingCellBorders
FormattingCellFill
FormattingCellFont
FractionFormat
FullColumnRange
Represents a range that span one or many full columns.
FullRange
FullRowRange
GeneralFormat
GradientCellFill
Gradient fill used to draw the background of a cell
GradientStop
Group
HeaderFooter
HeaderFooters
Even, Odd and First page headers and footers of a sheet.
Hyperlink
HyperlinkCollection
IconFilter
ImportOptions
InputCells
This collection describes each input cell for the scenario.
LicenseException
LoadError
Macrosheet
NumberFormat
OleObject
Represents an OLE Object on a sheet.
OleObjectCollection
OpenXmlLoadError
OutlineProperties
PageBreak
PageBreakCollection
PageMargins
PageSetup
Represents the page setup of a sheet
PageSetupPage
PageSetupProperties
PageSetupWorksheet
Pane
PaneCollection
PasteOptions
PercentFormat
PhoneticProperties
PhoneticRun
PhoneticText
Range
Represents a set of cells in a sheet.
RangeAccessor
RangeFill
RangeFont
RichTextParagraph
RichTextRun
Row
RowCollection
Represents a collection of rows in a sheet.
RowGroup
Scenario
ScenarioCollection
ScientificFormat
Sheet
Base class for all types fo sheets. Descendants include Worksheet and Chartsheet.
SheetChartsCollection
Represents a base class for chart collections on a sheet.
SheetCollection
SheetFormatProperties
SheetProperties
Represents a set of properties for a sheet
SheetProtection
Represents the protection of a sheet
SheetView
SimpleRange
SingleCellRange
SortCondition
SortState
SpreadsheetDataFormats
Clipboard data formats supported by the spreadsheet
StandardFormats
Exposes standard cell formats
StatisticsProperties
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.
StyleSheetCellStyle
Represents the style of a cell.
SummaryProperties
TextFormat
Format for text
Top10Filter
UnitConverter
ValuesFilter
WebPublishing
Workbook
Represents a spreadsheet workbook. A workbook is a container of sheets.
WorkbookCreationArguments
WorkbookProperties
WorkbookProtection
WorkbookView
Worksheet
Represents an Excel worksheet
WorksheetCalculationProperties
WorksheetCollection
WorksheetPageSetup
WorksheetRangeAddress
WorksheetView
Structs
CellAddress
CellRelativeAddress
CellSpan
RangeAddress
Enums
BorderStyle
The BorderStyle enumeration specifies the border line style.
BorderType
Specifies the type of border to set.
CalendarType
CellComments
Represents the options how to display cell comments.
CellMoveOrientationHint
CommentsDisplayType
Represents the options how the comments are displayed.
CustomPropertyType
DataConsolidateFunction
Specifies values for the data consolidation function.
DataValidationErrorStyle
DataValidationImeMode
DataValidationOperator
DataValidationType
DateTimeGrouping
DateTimeOrigin
DynamicFilterType
ErrorType
FilterOperator
FontFamilyType
FontSchemeType
FormatCategory
FormatType
GradientType
HorizontalCellAlignment
IconType
https://support.content.office.net/en-us/media/e3c875a8-1f59-43c2-9e09-436ed4a66076.gif
NavigationDirection
ObjectDisplayType
OleObjectType
Orientation
PageOrder
PaneState
Represents the pane state of a sheet
PaneType
PaperSize
PatternType
PhoneticAlignment
PhoneticType
PrintError
ReferenceMode
ScreenMeasurementUnit
SheetDefaultDirection
Possible values of the default text direction on a sheet .
SheetState
SheetType
SheetViewType
SortBy
SortMethod
SortOrder
SortOrientation
SpreadsheetUnderline
StringValueType
TargetScreenSize
TextDirection
Possible value of text direction in a cell.