Xceed.Workbooks.NET Namespace

In This Topic

This is the base assembly used by Xceed Workbooks for .NET.

Classes

	Class	Description
	Alignment	Represents the horizontal and vertical alignment used to align the content of a Cell.
	Annotation	Base class that contains the basic components for Notes & Comments.
	AnnotationCollection	Represents a collection of all the Notes and ThreadCommentCollections in the Worksheet.
	Area	Encapsulates the properties that allow to customize Charts-related areas like PlotAreas, Markers, Legends, Series & data labels.
	Area3DChart	Encapsulates the 3D version of an AreaChart in a Worksheet.
	AreaChart	Encapsulates a Chart of the Area type in a Worksheet.
	AreaSeries	Encapsulates Series of the Area type.
	AutoFilter	Represents the object controlling the filtering process in a Table. It offers properties to display the filtering buttons and customize the filtering process on TableColumns.
	Axis	Abstract class encapsulating an axis in a Chart.
	Bar3DChart	Encapsulates the 3D version of a BarChart in a Worksheet.
	BarChart	Encapsulates a Chart of the Bar type in a Worksheet.
	Bars	Encapsulates the properties that allow to customize the UpBars & DownBars in a StockChart.
	BarSeries	Encapsulates Series of the Bar type.
	BetweenCondition	Represents the CellHighlightCondition that highlights Cells containing values that are located between two given values.
	BlankCondition	Represents the CellHighlightCondition that highlights empty Cells.
	Border	Defines the content of a specific border.
	BorderCollection	Defines the collection of Borders for a Style.
	BubbleChart	Encapsulates a Chart of the Bubble type in a Worksheet.
	BubbleSeries	Encapsulates Series of the Bubble type.
	CategoryAxis	Encapsulates the Category Axis in a Chart.
	CategoryData	Encapsulates the methods used to create a CategoryData for the Chart's CategoryAxis.
	Cell	A cell represents a rectangle in a Worksheet. Each cell is the intersection of a Row and a Column. It can be accessed by using an address (a combination of a letter and a number, like A1, B2, C3…, where the letter is the Column Id and the number is the Row Id) or by coordinates (by specifying the Row Id first & then the Column Id, for example, 0,0; 2,3; 5;5...). Note that indexes for Rows & Columns always start at 0.
	CellCollection	Represents a collection of Cells.
	CellHelper	Offers some static functions for converting data.
	CellHighlightCondition	Encapsulates the various conditions that can be used to highlight Cells when using a ConditionalFormattingCellHighlight.
	CellHighlightConditionHelper
	CellRange	Represents a rectangular range of Cells. The top-left and bottom-right Cells delimit the range.
	Chart	Abstract base class for all the 2D & 3D Charts in a Workbook.
	Chart3D	Abstract class encapsulating a 3D Chart in a Worksheet.
	ChartCollection	A collection containing all the Charts in a Worksheet.
	ChartValueRange	Manages a CellRange & its values according to a user needs.
	ColorHelper	Contains many methods that will help convert colors between Color, int, string and ThemeColor.
	ColorThreshold	Represents the various color stops that are used to create a gradient.
	Column	Represents a column in a Worksheet.
	Column3DChart	Encapsulates the 3D version of a ColumnChart in a Worksheet.
	ColumnCellCollection	This collection represents the collection of Cells for a specific Column.
	ColumnChart	Encapsulates a Chart of the Column type in a Worksheet.
	ColumnCollection	Represents a collection of Columns in a Worksheet.
	ColumnRange	Defines a ColumnRange, which is a range of consecutives Columns.
	ColumnSeries	Encapsulates Series of the Column type.
	Comment	This class represents a single Comment in a ThreadCommentCollection.
	ConditionalFormatting	Contains the methods shared by all available types of conditional formatting.
	ConditionalFormattingAboveAverage	Represents the Above Average ConditionFormatting, which creates an average from the various values in the area & formats the Cells based on this average.
	ConditionalFormattingCellHighlight	Represents the Highlight Cells ConditionalFormatting, which highlight Cells corresponding to a specific condition.
	ConditionalFormattingCollection	This collection represents the collection of ConditionalFormattings stored in the Worksheet.
	ConditionalFormattingColorScale	Represents the Color Scales ConditionalFormatting, which color Cells using a specific color scale.
	ConditionalFormattingDataBar	Represents the Data Bars ConditionalFormatting, which uses either a gradient or solid fill to create a data bar inside each Cell.
	ConditionalFormattingIconSet	Represents the Icon Sets ConditionalFormatting, which uses sets of icons to visually represent the various values.
	ConditionalFormattingTop10	Represents the Top 10 ConditionalFormatting, which formats a selected number of top tier values.
	Contour3DChart	Encapsulates a 3D Chart of the Contour type in a Worksheet.
	ContourSeries	Encapsulates Series of the Contour type.
	CSVImportOptions	Specifies the import options' properties for a CSV document or CSV stream when importing data in a Worksheet through the Worksheet.ImportData method.
	DataPointLabels<TPositionEnum>	This is the base class for the Series' data labels.
	DataPointLabelsBubble	Encapsulates the data labels that are specific to BubbleSeries.
	DataTableImportOptions	Specifies the properties of the import options used when importing data tables in a Worksheet through the Worksheet.ImportData method.
	DataValidation	Represents the data validation process used to validate the content of a Cell.
	DataValidationCollection	Represents the collection of DataValidations found in the Worksheet.
	DataValidationCondition	Represents the condition used in a DataValidation process.
	DataValidationError	Gets or sets an error message.
	DataValidationMessage	Represents the message that the user will see when entering data in a Cell.
	DataValidationRangeCondition	Represents the various types of DataValidations that use a condition based on two values.
	DataValidationSingleCondition	Represents the various types of DataValidations that use a condition based on only one value.
	DateInLast7DaysCondition	Represents the CellHighlightCondition that highlights Cells containing dates found within the last 7 days.
	DateInLastMonthCondition	Represents the CellHighlightCondition that highlights Cells containing dates found within the last month.
	DateInLastWeekCondition	Represents the CellHighlightCondition that highlights Cells containing dates found within the last week.
	DateInNextMonthCondition	Represents the CellHighlightCondition that highlights Cells containing dates found within the next month.
	DateInNextWeekCondition	Represents the CellHighlightCondition that highlights Cells containing dates found within the next week.
	DateInThisMonthCondition	Represents the CellHighlightCondition that highlights Cells containing dates found within the current month.
	DateInThisWeekCondition	Represents the CellHighlightCondition that highlights Cells containing dates found within the current week.
	DateTodayCondition	Represents the CellHighlightCondition that highlights Cells containing a date that corresponds to the current day.
	DateTomorrowCondition	Represents the CellHighlightCondition that highlights Cells containing a date that corresponds to the day after the current day.
	DateYesterdayCondition	Represents the CellHighlightCondition that highlights Cells containing a date that corresponds to the day before the current day.
	DoughnutChart	Encapsulates a Chart of the Doughnut type in a Worksheet.
	DoughnutSeries	Encapsulates Series of the Doughnut type.
	DrawingClientData	This class is used to enable or disable the selection & printing of elements within the Worksheet when it is protected.
	DuplicateCondition	Represents the CellHighlightCondition that highlights Cells containing duplicate values.
	EqualCondition	Represents the CellHighlightCondition that highlights Cells containing values that are equal to a given value.
	ErrorCondition	Represents the CellHighlightCondition that highlights Cells containing errors.
	ExcelColorElement	Provides three constructors that allow to choose between various ways of creating a colored element that can be used in Excel.
	Fill	Contains the properties related to filling a Cell, Row, Column or range with a Color and a pattern.
	Font	Represents the possible properties of a font.
	FormattedText	Represents a text that is formatted in a specific way.
	FormattedTextList	Represents a list of FormattedText objects.
	GreaterThanCondition	Represents the CellHighlightCondition that highlights Cells containing values greater than a given value.
	GreaterThanOrEqualCondition	Represents the CellHighlightCondition that highlights Cells containing values greater than or equal to a given value.
	Hyperlink	Encapsulates the object that represents a hyperlink.
	HyperlinkCollection	Represents a collection of Hyperlinks in a Worksheet.
	ImportOptions	Specifies the properties of the import options used when importing data in a Worksheet through the Worksheet.ImportData method.
	Legend	Encapsulates the data related to a Chart's legend.
	LessThanCondition	Represents the CellHighlightCondition that highlights Cells containing values that are less than a given value.
	LessThanOrEqualCondition	Represents the CellHighlightCondition that highlights Cells containing values that are less than or equal to a given value.
	Licenser	Represents the class used to register all classes defined in the Xceed.Workbooks.NET assembly.
	Line	Encapsulates the properties of lines in a Chart-related context.
	Line3DChart	Encapsulates the 3D version of a LineChart in a Worksheet.
	LinearRange<T>	Abstract class defining a LinearRange, which is a range of consecutives WorksheetElements.
	LinearWorksheetElement	Contains the common elements for the Column and Row classes.
	LineChart	Encapsulates a Chart of the Line type in the Worksheet.
	LineSeries	Encapsulates Series of the Line type.
	Margins	Represents the Worksheet's margins.
	Marker	Encapsulates Marker data for a Series' data labels.
	MergedCellCollection	Represents a collection of all the Cells that need to be merged.
	NotBetweenCondition	Represents the CellHighlightCondition that highlights Cells containing values that are not found between two given values.
	NotBlankCondition	Represents the CellHighlightCondition that highlights Cells which are not empty.
	Note	Represents a Note, which is made of multiple blocks of FormattedText that are added one after the other.
	NoteProtection	Represents the Protection properties of a Note.
	NotEqualCondition	Represents the CellHighlightCondition that highlights Cells containing values that are not equal to a given value.
	NotErrorCondition	Represents the CellHighlightCondition that highlights Cells containing no errors.
	PageLayout	Defines the options related to the Worksheet's page & printing layouts.
	Person	Represents the person who interacted with an object that requires identification.
	Picture	Represents a Picture element in the PictureCollection.
	PictureCollection	Represents a collection of all the Pictures in the Worksheet.
	PictureLocks	Allows the user to remove the authorization permitting the modification of certain Picture properties.
	Pie3DChart	Encapsulates the 3D version of a PieChart in a Worksheet.
	PieChart	Encapsulates a Chart of the Pie type in a Worksheet.
	PieOfChart	Encapsulates a Chart of the Pie-Of-Bar or Pie-Of-Pie type in a Worksheet.
	PieSeries	Encapsulates Series of the Pie type.
	PlotArea	Encapsulates a Chart's plot area.
	Position	Manages the values of properties that are unit dependent, like AbsoluteAnchor, TopLeftOffsets and BottomRightOffsets.
	PositionedElement	Acts as the base class for positioned elements.
	Protection	Represents the possible properties of the Cell protection process.
	ProtectionBase	Contains the base data for a Protection.
	RadarChart	Encapsulates a Chart of the Radar type in a Worksheet.
	RadarSeries	Encapsulates Series of the Radar type.
	RangeBase<T>	Contains the base data for a range.
	Row	Represents a row in the Worksheet.
	RowCellCollection	Represents the collection of Cells in a specific Row.
	RowCollection	Represents a collection of Rows in the Worksheet.
	RowRange	Defines a range of consecutives Rows.
	ScatterChart	Encapsulates a Chart of the Scatter type in a Worksheet.
	ScatterSeries	Encapsulates Series of the Scatter type.
	Series	This is the base class for all series; it contains their common properties.
	SeriesAxis	Encapsulates the Series Axis in a Chart3D.
	SeriesCollection	Represents a collection of Series.
	SheetView	Represents a view displaying a single sheet from a Worksheet.
	StockChart	Encapsulates a Chart of the Stock type in a Worksheet.
	StockSeries	Encapsulates Series of the Stock type.
	Style	Represents the style that is used to display a Cell, Cells from a Column or Cells from a Row.
	StyleBase<T>	This is a generic base class for styled objects like Style, Fill, Font and Alignment.
	StyledRange<T>	Contains the base data for a range.
	StyledWorksheetElement	Abstract class that can be used to stylize the various elements in a Worksheet.
	Surface3D	Encapsulates the data of a Surface3D object.
	Surface3DChart	Encapsulates a Chart of the Surface3D type in a Worksheet.
	SurfaceSeries	Encapsulates Series of the Surface type.
	Table	Represents a range of Cells that are independent from the other Cells in the Worksheet & grouped to form a rectangular arrangement of Rows and Columns.
	TableCollection	Represents a collection of Tables in a Worksheet.
	TableColumn	Represents a Column that is located inside a Table.
	TableColumnCollection	Represents a collection of TableColumns in a Table.
	TextBeginsWithCondition	Represents the CellHighlightCondition that highlights Cells containing text that begins with a given value.
	TextContainsCondition	Represents the CellHighlightCondition that highlights Cells containing text corresponding to a given value.
	TextEndsWithCondition	Represents the CellHighlightCondition that highlights Cells containing text that ends with a given value.
	TextNotContainsCondition	Represents the CellHighlightCondition that highlights Cells containing text which does not include a given value.
	TextOptions	Encapsulates the properties used to format text in a Chart.
	Theme	Represents a Theme in a Workbook-related context.
	ThemeColor	Represents the colors associated with a Theme.
	ThreadCommentCollection	Contains a collection of the various threads of Comments that can be found in the Worksheet.
	Title	Encapsulates the properties that are used to customize the title of the Chart or the title of its Axes.
	UniqueCondition	Represents the CellHighlightCondition that highlights Cells containing unique values.
	UserObjectImportOptions	Specifies the properties of the import options for user objects when importing data in a Worksheet through the Worksheet.ImportData method.
	ValueAxis	Encapsulates the Value Axis in a Chart.
	Workbook	Represents the root document containing the Worksheet(s).
	WorkbookElement	This is the base class for all single elements in a Workbook.
	WorkbookProtection	Represents the Protection used on a Workbook.
	WorkbookThemeColor	Represents a ThemeColor associated with the Workbook's Theme.
	WorkbookThemeColors	Represents the collection of ThemeColors associated with the Workbook's Theme.
	WorkbookView	Represents a view displaying a single Workbook.
	Worksheet	Represents a single worksheet from a Workbook.
	WorksheetCollection	Represents a collection of Worksheets in the Workbook.
	WorksheetElement	This is the base class for all single elements in a Worksheet.
	WorksheetProtection	Represents the actions that can be carried out on a Worksheet when it is protected.
	WorksheetRange	Represents a group of continuous Worksheets in a WorksheetCollection.

Interfaces

	Interface	Description
	IRangeBase<T>	Offers the base properties for a range.
	IReadonlyAlignment	Interface exposing the properties & methods of a read-only Alignment object.
	IReadonlyBorder	Interface exposing the properties & methods of a read-only Border object.
	IReadonlyFill	Interface exposing the properties & methods of a read-only Fill object.
	IReadonlyFont	Interface exposing the properties & methods of a read-only Font object.
	IReadonlyProtection	Interface exposing the properties & methods of a read-only Protection object.
	IReadonlyStyle	Interface exposing the properties & methods of a read-only Style object.
	IReadonlyThemeColor	Interface exposing the properties of a read-only ThemeColor object.
	IReadonlyWorkbookProtection	Interface exposing the actions that can be carried out on a Workbook when it is protected.
	IReadonlyWorksheetProtection	Interface exposing the actions that can be carried out on a Worksheet when it is protected.

Enumerations

	Enumeration	Description
	Anchor	Determines how a Picture is anchored in a Worksheet.
	AnnotationType	Determines the Annotation's type.
	Area3DChartSubType	Defines the available sub types for an Area3DChart.
	AreaChartSubType	Defines the available sub types for an AreaChart.
	AreaPattern	Defines the available pattern for styling the Area.
	ArrowSize	Defines the availalbe sizes for the arrows that can be attached to the beginning or end of a Line in a Chart.
	ArrowType	Defines the types of arrows that can be attached to the beginning or end of a Line in a Chart.
	AxisDisplayUnitsType	Defines the available display units for the ValueAxis' tick labels.
	Bar3DChartSubType	Defines the available sub types for a Bar3DChart.
	BarChartSubType	Defines the available sub types for a BarChart.
	BarColumn3DChartColumnShape	Defines the available shapes for the Columns in a Column3DChart.
	BorderType	Defines the Border's type.
	BreakType	Determines which kind of page break will be inserted.
	BubbleChartSubType	Defines the availalbe sub types for a BubbleChart.
	BuiltinStyleType	Represents the different types of built-in Cell Styles offered by MS Excel.
	CapType	Defines the types of caps that can be added to the extremities of a Line in a Chart.
	CFRuleType
	ClearOptions	Contains the options that determine what will be cleared when one of the Clear methods is used on a Row, Column, Worksheet or Range.
	ColorScalePreset	Contains the various presets that can be used with ConditionalFormattingColorScale.
	Column3DChartSubType	Defines the available sub types for a Column3DChart.
	ColumnChartSubType	Defines the available sub types for a ColumnChart.
	CompoundType	Defines the types of Lines that can be drawn in a Chart.
	ConditionalFormattingStylePresets	Defines the available pre-made styles that can be used on ConditionalFormattings.
	Contour3DChartSubType	Defines the available sub types for a Contour3DChart.
	CopyOptions	Determines if the Cell or CellRange is cut or copied.
	CrossPositionType	Defines where a relative Axis will cross the Axis.
	DashType	Defines the types of dashes that can used to draw a Line in a Chart.
	DataBarPreset	Contains the available presets that can be used to stylize the data bars in a ConditionalFormattingDataBar context.
	DataBarType	Contains the available types of data bars in a ConditionalFormattingDataBar context.
	DataComparisonType	Determines the type of comparison that the DataValidation process will use.
	DataPointLabelsSeparatorType	Defines the separators that can be used to separate data displayed in data labels.
	DataType	Determines the type of data entered in a Cell.
	DataValidationErrorStyle	Represents the different types of built-in error alerts offered by MS Excel.
	DeleteRangeShiftType	Determines how Cells are shifted after a CellRange is deleted.
	FillPattern	Represents the possible values for a pattern style when a Fill object is used to fill a Cell, Row, Column or range.
	HorizontalAlignment	Contains the various types of horizontal alignments that can be used in a Cell.
	HyperlinkType	Defines the Hyperlink's type.
	IconSetType	Represents the available icon sets that can be used with a ConditionalFormattingIconSet.
	InsertRangeShiftType	Determines how Cells are shifted after inserting a CellRange.
	JoinType	Defines the various ways of joining two intersecting segments when drawing a Line in a Chart.
	LegendPositionType	Defines the available positions for a Legend.
	LineChartSubType	Defines the available sub types for a LineChart.
	LineStyle	Defines the style of a Border.
	MarginPreset	Allows to set the Margins using pre-set values.
	MarkerSymbol	Defines the symbols that can be used to represent the Markers attached to a Series' data points.
	NoneDataPointLabelsPositionType	Defines the data labels' location when said location cannot be modified.
	OrientationType	Defines how a page is laid out.
	PaperSizeType	Defines the dimensions of a page.
	PasteOptions	Determines what kind of data will be pasted into the new location.
	PictureFormat	Represents the available formats for a Picture.
	PieOfChartSplitType	Defines the available types of split for a PieOfChart.
	PieOfChartSubType	Defines the available sub types for a PieOfChart.
	PieSliceDataPointLabelsPositionType	Defines the available locations for data labels when said location is defined in relation to pie slices.
	PointDataPointLabelsPositionType	Defines the available locations for data labels when said location is defined in relation to points.
	RadarChartSubType	Defines the available sub types for a RadarChart.
	RangeConditionType	Contains the available types of DataValidationRangeCondition.
	ScatterChartSubType	Defines the available sub types for a ScatterChart.
	SingleConditionType	Contains the available types of DataValidationSingleCondition.
	StockChartSubType	Defines the available sub types for a StockChart.
	Surface3DChartSubType	Defines the available sub types for the Surface3DChart.
	SurfaceDataPointLabelsPositionType	Defines the available locations for data labels when said location is inside a surface.
	TableStyle	Specifies the built-in style used on a Table.
	TextDirectionAlignment	Contains the options that determine how the text will flow.
	TextDirectionType	Contains the options that define the various ways of displaying text.
	ThemeColorType	The available types of ThemeColor.
	ThresholdType	Contains the various possible behavior of a ColorThreshold.
	TickLabelsPosition	Defines the available positions for the Axis' tick labels.
	TickMarksType	Defines the available types of major & minor tick marks.
	TotalRowFunction	Contains the values that can be used to apply a built-in formula in a TableColumn’s Total Row.
	TwoCellAnchorBehavior	Affects the behavior of a TwoCellAnchor Picture when adding and deleting Rows & Columns.
	UnderlineType	Defines which type of underline is used.
	Units	Determines what type of units are used for measurements.
	ValidationType	Defines which type of DataValidation is accepted.
	VerticalAlignment	Contains the various types of vertical alignments that can be used in a Cell.
	WorksheetViewType	Contains the various View modes the can be used by a SheetView.
	WorksheetVisibility	Contains the options that determine how the Worksheet is displayed.

Reference

Xceed.Workbooks.NET Assembly

Send Feedback

Business Suite

Ultimate Suite

Reference