Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Collapse]Cross-Platform Core Libraries
 [Expand]DevExpress ORM Tool
 [Expand]DevExpress Data Library
 [Expand]Miscellaneous
 [Collapse]API Reference
  [Expand]DevExpress.Data
  [Expand]DevExpress.Data.Browsing
  [Expand]DevExpress.Data.Browsing.Design
  [Expand]DevExpress.Data.Camera
  [Expand]DevExpress.Data.Controls
  [Expand]DevExpress.Data.Controls.ExpressionEditor
  [Expand]DevExpress.Data.Entity
  [Expand]DevExpress.Data.Filtering
  [Expand]DevExpress.Data.Filtering.Exceptions
  [Expand]DevExpress.Data.Filtering.Helpers
  [Expand]DevExpress.Data.Linq
  [Expand]DevExpress.Data.ODataLinq
  [Expand]DevExpress.Data.PivotGrid
  [Expand]DevExpress.Data.PLinq
  [Expand]DevExpress.Data.TreeList
  [Expand]DevExpress.Data.Utils
  [Expand]DevExpress.Data.Utils.ServiceModel
  [Expand]DevExpress.Data.WcfLinq
  [Expand]DevExpress.Data.WizardFramework
  [Expand]DevExpress.Data.XtraReports.DataProviders
  [Expand]DevExpress.Data.XtraReports.Labels
  [Expand]DevExpress.Data.XtraReports.ServiceModel
  [Expand]DevExpress.Data.XtraReports.ServiceModel.DataContracts
  [Expand]DevExpress.Data.XtraReports.Wizard
  [Expand]DevExpress.Data.XtraReports.Wizard.Presenters
  [Expand]DevExpress.Data.XtraReports.Wizard.Views
  [Expand]DevExpress.DataAccess
  [Expand]DevExpress.DataAccess.ConnectionParameters
  [Expand]DevExpress.DataAccess.EntityFramework
  [Expand]DevExpress.DataAccess.Excel
  [Expand]DevExpress.DataAccess.ExpressionEditor
  [Expand]DevExpress.DataAccess.Localization
  [Expand]DevExpress.DataAccess.ObjectBinding
  [Expand]DevExpress.DataAccess.Sql
  [Expand]DevExpress.DataAccess.Sql.DataApi
  [Expand]DevExpress.DataAccess.UI.Design
  [Expand]DevExpress.DataAccess.UI.EntityFramework
  [Expand]DevExpress.DataAccess.UI.Excel
  [Expand]DevExpress.DataAccess.UI.Localization
  [Expand]DevExpress.DataAccess.UI.ObjectBinding
  [Expand]DevExpress.DataAccess.UI.Sql
  [Expand]DevExpress.DataAccess.UI.Wizard
  [Expand]DevExpress.DataAccess.UI.Wizard.Services
  [Expand]DevExpress.DataAccess.UI.Wizard.Views
  [Expand]DevExpress.DataAccess.Web
  [Expand]DevExpress.DataAccess.Wizard
  [Expand]DevExpress.DataAccess.Wizard.Model
  [Expand]DevExpress.DataAccess.Wizard.Presenters
  [Expand]DevExpress.DataAccess.Wizard.Services
  [Expand]DevExpress.DataAccess.Wizard.Views
  [Expand]DevExpress.Diagram.Core
  [Expand]DevExpress.Diagram.Core.Layout
  [Expand]DevExpress.Diagram.Core.Localization
  [Expand]DevExpress.Diagram.Core.Shapes
  [Expand]DevExpress.Diagram.Core.Themes
  [Expand]DevExpress.DocumentServices.ServiceModel
  [Expand]DevExpress.DocumentServices.ServiceModel.Client
  [Expand]DevExpress.DocumentServices.ServiceModel.DataContracts
  [Expand]DevExpress.DocumentView
  [Expand]DevExpress.Entity.Model
  [Expand]DevExpress.Entity.ProjectModel
  [Expand]DevExpress.Export
  [Collapse]DevExpress.Export.Xl
   [Expand]IXlCell Interface
   [Expand]IXlCellError Interface
   [Expand]IXlColumn Interface
   [Expand]IXlDocument Interface
   [Expand]IXlDocumentOptions Interface
   [Expand]IXlExporter Interface
   [Expand]IXlFilterColumns Interface
   [Expand]IXlFilterCriteria Interface
   [Expand]IXlFormulaParameter Interface
   [Expand]IXlMergedCells Interface
   [Expand]IXlOutlineProperties Interface
   [Expand]IXlPageBreaks Interface
   [Expand]IXlPicture Interface
   [Expand]IXlRow Interface
   [Expand]IXlSheet Interface
   [Expand]IXlSheetViewOptions Interface
   [Expand]IXlTable Interface
   [Expand]IXlTableCollection Interface
   [Expand]IXlTableColumn Interface
   [Expand]IXlTableColumnCollection Interface
   [Expand]IXlTableStyleInfo Interface
   [Expand]XlAnchorPoint Structure
    XlAnchorType Enumeration
   [Expand]XlBorder Class
    XlBorderLineStyle Enumeration
   [Expand]XlBordersBase Class
    XlCalendarType Enumeration
   [Expand]XlCellAlignment Class
    XlCellErrorType Enumeration
   [Expand]XlCellFormatting Class
   [Expand]XlCellPosition Structure
   [Expand]XlCellRange Class
   [Expand]XlColor Class
   [Expand]XlColorFilter Class
    XlColorType Enumeration
    XlCommentsPrintMode Enumeration
    XlCondFmtAverageCondition Enumeration
    XlCondFmtAxisPosition Enumeration
    XlCondFmtColorScaleType Enumeration
   [Expand]XlCondFmtCustomIcon Class
    XlCondFmtIconSetType Enumeration
    XlCondFmtOperator Enumeration
   [Expand]XlCondFmtRule Class
   [Expand]XlCondFmtRuleAboveAverage Class
   [Expand]XlCondFmtRuleBlanks Class
   [Expand]XlCondFmtRuleCellIs Class
   [Expand]XlCondFmtRuleColorScale Class
   [Expand]XlCondFmtRuleDataBar Class
   [Expand]XlCondFmtRuleDuplicates Class
   [Expand]XlCondFmtRuleExpression Class
   [Expand]XlCondFmtRuleIconSet Class
   [Expand]XlCondFmtRuleSpecificText Class
   [Expand]XlCondFmtRuleTimePeriod Class
   [Expand]XlCondFmtRuleTop10 Class
   [Expand]XlCondFmtRuleUnique Class
   [Expand]XlCondFmtRuleWithFormatting Class
    XlCondFmtSpecificTextType Enumeration
    XlCondFmtTimePeriod Enumeration
    XlCondFmtType Enumeration
   [Expand]XlCondFmtValueObject Class
    XlCondFmtValueObjectType Enumeration
   [Expand]XlConditionalFormatting Class
   [Expand]XlCustomFilterCriteria Class
   [Expand]XlCustomFilters Class
   [Expand]XlCustomPropertyValue Structure
    XlDataBarDirection Enumeration
   [Expand]XlDataValidation Class
    XlDataValidationErrorStyle Enumeration
    XlDataValidationImeMode Enumeration
    XlDataValidationOperator Enumeration
    XlDataValidationType Enumeration
   [Expand]XlDateGroupItem Class
    XlDateTimeGroupingType Enumeration
    XlDisplayBlanksAs Enumeration
   [Expand]XlDocumentCustomProperties Class
    XlDocumentFormat Enumeration
   [Expand]XlDocumentProperties Class
    XlDocumentSecurity Enumeration
    XlDocumentTheme Enumeration
   [Expand]XlDynamicFilter Class
    XlDynamicFilterType Enumeration
    XlErrorsPrintMode Enumeration
   [Expand]XlExport Class
   [Expand]XlExpression Class
    XlExpressionStyle Enumeration
   [Expand]XlFill Class
   [Expand]XlFilterColumn Class
    XlFilterOperator Enumeration
    XlFilterType Enumeration
   [Expand]XlFont Class
   [Expand]XlFontBase Class
    XlFontFamily Enumeration
    XlFontSchemeStyles Enumeration
   [Expand]XlFormatting Class
   [Expand]XlFunc Class
   [Expand]XlHeaderFooter Class
    XlHorizontalAlignment Enumeration
   [Expand]XlHyperlink Class
   [Expand]XlHyperlinkBase Class
    XlIgnoreErrors Enumeration
   [Expand]XlNumberFormat Class
   [Expand]XlOper Class
   [Expand]XlPageMargins Class
    XlPageOrientation Enumeration
    XlPagePrintOrder Enumeration
   [Expand]XlPageSetup Class
    XlPageUnits Enumeration
    XlPatternType Enumeration
   [Expand]XlPictureHyperlink Class
    XlPositionType Enumeration
   [Expand]XlPrintOptions Class
   [Expand]XlPrintTitles Class
    XlReadingOrder Enumeration
   [Expand]XlRichTextRun Class
   [Expand]XlRichTextString Class
    XlScriptType Enumeration
    XlSheetVisibleState Enumeration
   [Expand]XlSourceRectangle Structure
   [Expand]XlSparkline Class
    XlSparklineAxisScaling Enumeration
   [Expand]XlSparklineGroup Class
    XlSparklineType Enumeration
    XlSummary Enumeration
   [Expand]XlTableColumnInfo Class
    XlTablePart Enumeration
   [Expand]XlTableReference Class
    XlThemeColor Enumeration
   [Expand]XlTop10Filter Class
    XlTotalRowFunction Enumeration
    XlUnderlineType Enumeration
   [Expand]XlValuesFilter Class
   [Expand]XlVariantValue Structure
    XlVariantValueType Enumeration
    XlVerticalAlignment Enumeration
  [Expand]DevExpress.Map
  [Expand]DevExpress.Mvvm
  [Expand]DevExpress.Mvvm.DataAnnotations
  [Expand]DevExpress.Mvvm.DataModel
  [Expand]DevExpress.Mvvm.ModuleInjection
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.Utils
  [Expand]DevExpress.Mvvm.ViewModel
  [Expand]DevExpress.Office
  [Expand]DevExpress.Office.Crypto
  [Expand]DevExpress.Office.Drawing
  [Expand]DevExpress.Office.Export
  [Expand]DevExpress.Office.Export.Html
  [Expand]DevExpress.Office.Import
  [Expand]DevExpress.Office.Localization
  [Expand]DevExpress.Office.Options
  [Expand]DevExpress.Office.Services
  [Expand]DevExpress.Office.Utils
  [Expand]DevExpress.Pdf
  [Expand]DevExpress.Pdf.Localization
  [Expand]DevExpress.PivotGrid.Printing
  [Expand]DevExpress.Printing
  [Expand]DevExpress.Printing.Core
  [Expand]DevExpress.ReportServer.Printing
  [Expand]DevExpress.ReportServer.Printing.Services
  [Expand]DevExpress.ReportServer.ServiceModel.Client
  [Expand]DevExpress.ReportServer.ServiceModel.ConnectionProviders
  [Expand]DevExpress.ReportServer.ServiceModel.DataContracts
  [Expand]DevExpress.Schedule
  [Expand]DevExpress.Services
  [Expand]DevExpress.Sparkline
  [Expand]DevExpress.Spreadsheet
  [Expand]DevExpress.Spreadsheet.Charts
  [Expand]DevExpress.Spreadsheet.Drawings
  [Expand]DevExpress.Spreadsheet.Export
  [Expand]DevExpress.Spreadsheet.Formulas
  [Expand]DevExpress.Spreadsheet.Functions
  [Expand]DevExpress.TreeMap
  [Expand]DevExpress.Utils
  [Expand]DevExpress.Utils.Commands
  [Expand]DevExpress.Utils.Controls
  [Expand]DevExpress.Utils.Filtering.Internal
  [Expand]DevExpress.Utils.IoC
  [Expand]DevExpress.Utils.Localization
  [Expand]DevExpress.Utils.Serializing.Helpers
  [Expand]DevExpress.WebUtils
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpo
  [Expand]DevExpress.Xpo.DB
  [Expand]DevExpress.Xpo.DB.Exceptions
  [Expand]DevExpress.Xpo.DB.Helpers
  [Expand]DevExpress.Xpo.Exceptions
  [Expand]DevExpress.Xpo.Helpers
  [Expand]DevExpress.Xpo.Metadata
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Localization
  [Expand]DevExpress.XtraCharts.Printing
  [Expand]DevExpress.XtraEditors
  [Expand]DevExpress.XtraEditors.DXErrorProvider
  [Expand]DevExpress.XtraExport.Csv
  [Expand]DevExpress.XtraGauges.Base
  [Expand]DevExpress.XtraGauges.Core
  [Expand]DevExpress.XtraGauges.Core.Base
  [Expand]DevExpress.XtraGauges.Core.Drawing
  [Expand]DevExpress.XtraGauges.Core.Localization
  [Expand]DevExpress.XtraGauges.Core.Model
  [Expand]DevExpress.XtraGauges.Core.Primitive
  [Expand]DevExpress.XtraGrid
  [Expand]DevExpress.XtraPivotGrid
  [Expand]DevExpress.XtraPivotGrid.Customization
  [Expand]DevExpress.XtraPivotGrid.Data
  [Expand]DevExpress.XtraPivotGrid.Localization
  [Expand]DevExpress.XtraPivotGrid.Selection
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrinting.BarCode
  [Expand]DevExpress.XtraPrinting.DataNodes
  [Expand]DevExpress.XtraPrinting.Drawing
  [Expand]DevExpress.XtraPrinting.Export
  [Expand]DevExpress.XtraPrinting.Export.Web
  [Expand]DevExpress.XtraPrinting.Localization
  [Expand]DevExpress.XtraPrinting.Native
  [Expand]DevExpress.XtraPrinting.Shape
  [Expand]DevExpress.XtraPrinting.Shape.Native
  [Expand]DevExpress.XtraPrinting.WebClientUIControl.DataContracts
  [Expand]DevExpress.XtraPrinting.XamlExport
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraReports
  [Expand]DevExpress.XtraReports.Design
  [Expand]DevExpress.XtraReports.Parameters
  [Expand]DevExpress.XtraReports.ReportGeneration
  [Expand]DevExpress.XtraReports.UI
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.API.Layout
  [Expand]DevExpress.XtraRichEdit.API.Native
  [Expand]DevExpress.XtraRichEdit.API.Native.Implementation
  [Expand]DevExpress.XtraRichEdit.Commands
  [Expand]DevExpress.XtraRichEdit.Export
  [Expand]DevExpress.XtraRichEdit.Export.Html
  [Expand]DevExpress.XtraRichEdit.Export.Rtf
  [Expand]DevExpress.XtraRichEdit.Forms
  [Expand]DevExpress.XtraRichEdit.Import
  [Expand]DevExpress.XtraRichEdit.Localization
  [Expand]DevExpress.XtraRichEdit.Services
  [Expand]DevExpress.XtraRichEdit.Utils
  [Expand]DevExpress.XtraScheduler
  [Expand]DevExpress.XtraScheduler.Compatibility
  [Expand]DevExpress.XtraScheduler.Drawing
  [Expand]DevExpress.XtraScheduler.Exchange
  [Expand]DevExpress.XtraScheduler.iCalendar
  [Expand]DevExpress.XtraScheduler.iCalendar.Components
  [Expand]DevExpress.XtraScheduler.Localization
  [Expand]DevExpress.XtraScheduler.Native
  [Expand]DevExpress.XtraScheduler.Outlook
  [Expand]DevExpress.XtraScheduler.Outlook.Interop
  [Expand]DevExpress.XtraScheduler.Reporting
  [Expand]DevExpress.XtraScheduler.Services
  [Expand]DevExpress.XtraScheduler.Services.Implementation
  [Expand]DevExpress.XtraScheduler.Tools
  [Expand]DevExpress.XtraScheduler.UI
  [Expand]DevExpress.XtraScheduler.Xml
  [Expand]DevExpress.XtraSpellChecker
  [Expand]DevExpress.XtraSpreadsheet
  [Expand]DevExpress.XtraSpreadsheet.Export
  [Expand]DevExpress.XtraSpreadsheet.Export.Html
  [Expand]DevExpress.XtraSpreadsheet.Import
  [Expand]DevExpress.XtraSpreadsheet.Localization
  [Expand]DevExpress.XtraSpreadsheet.Services
[Expand]Tools and Utilities
 End-User Documentation

DevExpress.Export.Xl Namespace

Contains classes and interfaces that constitute the XL Export Library used for generating spreadsheet files.

Expanded Classes

  Class Description
Public class XlBorder Provides access to the line characteristics of a cell border.
Public class XlBordersBase Serves as a base for the XlBorder class and specifies the border line style options.
Public class XlCellAlignment Contains alignment settings for a cell.
Public class XlCellFormatting Represents the object that specifies cell format characteristics.
Public class XlCellRange Defines a range of cells.
Public class XlColor Represents a color used in the spreadsheet document.
Public class XlColorFilter A filter by cell fill or font color.
Public class XlCondFmtCustomIcon Provides access to the particular icon in the custom icon set.
Public class XlCondFmtRule Base class for the conditional formatting rules.
Public class XlCondFmtRuleAboveAverage Represents the "Above or Below Average..." conditional formatting rule.
Public class XlCondFmtRuleBlanks Represents the conditional formatting rule that highlights blank/non-blank cells.
Public class XlCondFmtRuleCellIs Represents the conditional formatting rule that uses the relational operator.
Public class XlCondFmtRuleColorScale Represents the Color Scale conditional formatting rule.
Public class XlCondFmtRuleDataBar Represents the Data Bar conditional formatting rule.
Public class XlCondFmtRuleDuplicates Represents the conditional formatting rule for cells with duplicate values.
Public class XlCondFmtRuleExpression Represents the conditional formatting rule that uses a relational operator to determine which cells to format.
Public class XlCondFmtRuleIconSet Represents the Icon Set conditional formatting rule.
Public class XlCondFmtRuleSpecificText Represents "A Text That Contains..." conditional formatting rule.
Public class XlCondFmtRuleTimePeriod Represents the "Date Occurring..." conditional formatting rule.
Public class XlCondFmtRuleTop10 Represents the "Top/Bottom N" conditional formatting rule.
Public class XlCondFmtRuleUnique Represents the conditional formatting rule for cells with unique values.
Public class XlCondFmtRuleWithFormatting Provides formatting settings for the conditional formatting rules.
Public class XlCondFmtValueObject Represents a minimum or maximum threshold for a conditional formatting rule.
Public class XlConditionalFormatting Represents the worksheet ranges and conditional formatting rules applied to them.
Public class XlCustomFilterCriteria Specifies a criterion value and comparison operator for a custom filter.
Public class XlCustomFilters A custom filter that uses filter values and comparison operators to construct the filter expression.
Public class XlDataValidation Represents the data validation rule defined for a current worksheet.
Public class XlDateGroupItem A group of dates or times used in the filter criteria.
Public class XlDocumentCustomProperties Contains custom document properties associated with a workbook.
Public class XlDocumentProperties Contains basic document properties associated with a workbook.
Public class XlDynamicFilter A dynamic filter that shows dates that fall within a specified time period or displays values that are above or below the average.
Public class XlExport Represents an object that creates an exporter for generating spreadsheet files of the specified format.
Public class XlExpression An object which can be used to specify a worksheet cell formula.
Public class XlFill Contains the cell background attributes.
Public class XlFilterColumn A column in the filter range to which filtering is applied.
Public class XlFont Contains the cell font attributes.
Public class XlFontBase Serves as a base for the XlFont class and specifies the common font characteristics.
Public class XlFormatting Serves as a base for the XlCellFormatting class and provides properties to change cell format settings.
Public class XlFunc Provides static methods used to construct an internal representation of an expression (an IXlFormulaParameter object).
Public class XlHeaderFooter Represents the object that specifies headers and footers of a worksheet.
Public class XlHyperlink Represents a hyperlink in a worksheet.
Public class XlHyperlinkBase Serves as the base for the XlHyperlink and XlPictureHyperlink classes that define hyperlinks for cells and pictures.
Public class XlNumberFormat Represents the object that specifies a cell number format.
Public class XlOper A static class that implements methods to create arithmetic and logical operations in the IXlFormulaParameter expression.
Public class XlPageMargins Represents the object that specifies page margins for a worksheet.
Public class XlPageSetup Represents the object that specifies page formatting options.
Public class XlPictureHyperlink Represents a hyperlink associated with a picture.
Public class XlPrintOptions Represents the object that specifies printing options for a worksheet.
Public class XlPrintTitles Represents the object that specifies rows and columns to be repeated on every printed page.
Public class XlRichTextRun Represents a region of the cell text with its own set of font characteristics.
Public class XlRichTextString Represents a rich formatted text in a cell.
Public class XlSparkline A single sparkline in the sparkline group.
Public class XlSparklineGroup A sparkline group in a worksheet.
Public class XlTableColumnInfo Represents an object used to create a table column with custom formatting applied to its regions.
Public class XlTableReference Represents a reference to table data.
Public class XlTop10Filter A Top 10 filter that displays top/bottom ranked values.
Public class XlValuesFilter A filter by a list of cell values or date and time values.

Expanded Interfaces

  Interface Description
Public interface IXlCell Represents a single cell in a worksheet.
Public interface IXlCellError Contains information about a cell error.
Public interface IXlColumn Represents a single column in a worksheet.
Public interface IXlDocument Represents an interface that exposes the specific functionality of a workbook.
Public interface IXlDocumentOptions Contains options related to culture-specific settings of a workbook and document format specifications and limits.
Public interface IXlExporter Represents an exporter used to create a spreadsheet document and export it to a stream.
Public interface IXlFilterColumns A collection of XlFilterColumn objects.
Public interface IXlFilterCriteria A base interface for classes that specify the filter criteria applied to worksheet and table columns.
Public interface IXlFormulaParameter An internal representation of an expression. Used to set the cell formula.
Public interface IXlMergedCells Represents a collection of merged cells in a worksheet.
Public interface IXlOutlineProperties Contains options used to specify the summary rows and columns location.
Public interface IXlPageBreaks A collection of page breaks in a worksheet.
Public interface IXlPicture Represents a picture embedded in a worksheet.
Public interface IXlRow Represents a single row in a worksheet.
Public interface IXlSheet Represents a worksheet in a workbook.
Public interface IXlSheetViewOptions Provides access to a set of display options for a worksheet.
Public interface IXlTable Represents a table in a worksheet.
Public interface IXlTableCollection A read-only collection of tables contained in a worksheet.
Public interface IXlTableColumn Represents a single column in a table.
Public interface IXlTableColumnCollection A collection of columns in a table.
Public interface IXlTableStyleInfo Contains table style settings.

Expanded Structures

  Structure Description
Public structure XlAnchorPoint Represents an anchor point used to position a picture in a worksheet.
Public structure XlCellPosition Defines the column, row and the reference type (relative or absolute).
Public structure XlCustomPropertyValue Represents the value of a custom document property.
Public structure XlSourceRectangle Specifies the portion of the picture to display in a worksheet.
Public structure XlVariantValue A variant value that can be used as a cell value, filter value or function argument.

Expanded Enumerations

  Enumeration Description
Public enum XlAnchorType Lists anchoring types used to position an IXlPicture object in a worksheet or specifies how a picture should be moved and resized when a two cell anchoring is used.
Public enum XlBorderLineStyle Lists values used to specify the line styles for cell borders.
Public enum XlCalendarType Lists calendar types used to interpret filter values defined by the XlDateGroupItem instances.
Public enum XlCellErrorType Lists values used to specify the type of cell errors.
Public enum XlColorType Lists values used to specify the color type.
Public enum XlCommentsPrintMode Lists values used to specify how comments anchored to worksheet cells are printed.
Public enum XlCondFmtAverageCondition Lists the types of format operators used in the "Above or Below Average..." conditional formatting rule.
Public enum XlCondFmtAxisPosition List values that specify the axis position between negative and positive bars when the data bar conditional formatting is applied.
Public enum XlCondFmtColorScaleType Lists types of the color scale for the color scale conditional formatting rule.
Public enum XlCondFmtIconSetType Lists values that sets the icon set type for the icon set conditional format.
Public enum XlCondFmtOperator Lists the types of relational operators used in the conditional formatting rule.
Public enum XlCondFmtSpecificTextType List values specifying the type of the conditional format operator in a conditional formatting rule.
Public enum XlCondFmtTimePeriod Lists applicable time periods in a "date occurring..." conditional formatting rule.
Public enum XlCondFmtType Lists the types of the conditional formatting operators used in the conditional formatting rule.
Public enum XlCondFmtValueObjectType Lists values the specify the type of the threshold value to be used in conditional formatting rules
Public enum XlDataBarDirection Lists values that specify the direction of data bars when the data bar conditional format is applied.
Public enum XlDataValidationErrorStyle Lists the styles of the data validation error alerts.
Public enum XlDataValidationImeMode Lists values that specify how the input method editor (IME) is controlled by data validation.
Public enum XlDataValidationOperator Lists the types of operators that can be used in certain data validation types.
Public enum XlDataValidationType Lists the types of data validation.
Public enum XlDateTimeGroupingType Lists grouping types used to specify the filter criteria for DateTime values.
Public enum XlDisplayBlanksAs Lists values used to specify how empty cells are displayed on a sparkline.
Public enum XlDocumentFormat Lists values used to specify the document format.
Public enum XlDocumentSecurity Lists the security levels of the document.
Public enum XlDocumentTheme Lists values used to specify the document theme.
Public enum XlDynamicFilterType Lists the types of dynamic filter, i.e., a filter whose results may depend on the data to which it is applied or the current date.
Public enum XlErrorsPrintMode Lists values used to specify how cell errors are printed.
Public enum XlExpressionStyle Lists possible ways to interpret and calculate a formula in a worksheet.
Public enum XlFilterOperator Lists comparison operators used in a custom filter.
Public enum XlFilterType Lists types of filters available for the AutoFilter functionality.
Public enum XlFontFamily Lists values used to specify the font family to which a cell font may belong.
Public enum XlFontSchemeStyles Lists values used to specify the font scheme.
Public enum XlHorizontalAlignment Lists values used to specify the horizontal alignment of the cell content.
Public enum XlIgnoreErrors Lists the types of errors which occur in cell formulas and can be skipped using the IgnoreErrors property.
Public enum XlPageOrientation Lists values used to specify the page orientation applied when a worksheet is being printed.
Public enum XlPagePrintOrder Lists values used to specify the order in which worksheet pages are numbered and printed when the worksheet data does not fit on one page.
Public enum XlPageUnits Lists values used to specify the units of margin measurement.
Public enum XlPatternType Lists the types of patterns available for cell shading.
Public enum XlPositionType Lists reference types used to specify a cell position.
Public enum XlReadingOrder Lists values used to specify the reading order of the cell.
Public enum XlScriptType Lists values used to format the text in a cell as superscript or subscript.
Public enum XlSheetVisibleState Lists values used to specify the worksheet visibility.
Public enum XlSparklineAxisScaling Lists values used to specify how to calculate the minimum and maximum values for the vertical axis of a sparkline group.
Public enum XlSparklineType Lists values used to specify sparkline chart types (types of sparkline groups).
Public enum XlSummary Lists summary functions used in subtotals.
Public enum XlTablePart Lists special item specifiers used within structured references to refer to specific parts of a table or table column(s).
Public enum XlThemeColor Lists the base colors of the document theme.
Public enum XlTotalRowFunction Lists functions to calculate the totals of table columns.
Public enum XlUnderlineType Lists underline styles.
Public enum XlVariantValueType Lists values used to specify a variant value type.
Public enum XlVerticalAlignment Lists values used to specify the vertical alignment of the cell content.
How would you rate this topic?​​​​​​​