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
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Expand]Controls and Libraries
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Charts.Designer
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.UI.Interactivity
  [Expand]DevExpress.Mvvm.UI.ModuleInjection
  [Expand]DevExpress.Xpf.Accordion
  [Expand]DevExpress.Xpf.Bars
  [Expand]DevExpress.Xpf.Carousel
  [Expand]DevExpress.Xpf.Charts
  [Expand]DevExpress.Xpf.Charts.Localization
  [Expand]DevExpress.Xpf.Charts.RangeControlClient
  [Expand]DevExpress.Xpf.ChunkList
  [Expand]DevExpress.Xpf.Controls
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Core.ConditionalFormatting
  [Expand]DevExpress.Xpf.Core.DataSources
  [Expand]DevExpress.Xpf.Core.ServerMode
  [Expand]DevExpress.Xpf.Data
  [Expand]DevExpress.Xpf.DataAccess
  [Expand]DevExpress.Xpf.DataAccess.DataSourceWizard
  [Expand]DevExpress.Xpf.Diagram
  [Expand]DevExpress.Xpf.Docking
  [Expand]DevExpress.Xpf.Docking.Base
  [Expand]DevExpress.Xpf.DocumentViewer
  [Expand]DevExpress.Xpf.DXBinding
  [Expand]DevExpress.Xpf.Editors
  [Expand]DevExpress.Xpf.Editors.DateNavigator
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor.Native
  [Expand]DevExpress.Xpf.Editors.Filtering
  [Expand]DevExpress.Xpf.Editors.Flyout
  [Expand]DevExpress.Xpf.Editors.Flyout.Native
  [Expand]DevExpress.Xpf.Editors.Helpers
  [Expand]DevExpress.Xpf.Editors.Popups
  [Expand]DevExpress.Xpf.Editors.RangeControl
  [Expand]DevExpress.Xpf.Editors.Settings
  [Expand]DevExpress.Xpf.Editors.Validation
  [Expand]DevExpress.Xpf.ExpressionEditor
  [Expand]DevExpress.Xpf.Gauges
  [Expand]DevExpress.Xpf.Gauges.Localization
  [Collapse]DevExpress.Xpf.Grid
    AutoFilterCondition Enumeration
    AutoGenerateColumnsMode Enumeration
   [Expand]BandBase Class
   [Expand]BaseColumn Class
   [Expand]BaseGridColumnHeader Class
   [Expand]BaseGridHeader Class
    BestFitArea Enumeration
   [Expand]CanSelectCellEventArgs Class
   [Expand]CanSelectRowEventArgs Class
   [Expand]CanUnselectCellEventArgs Class
   [Expand]CanUnselectRowEventArgs Class
   [Expand]CardData Class
   [Expand]CardHeaderData Class
    CardLayout Enumeration
   [Expand]CardView Class
   [Expand]CardViewCommands Class
   [Expand]CardViewHitInfo Class
    CardViewHitTest Enumeration
    CardViewSelectMode Enumeration
   [Expand]CellContentPresenter Class
   [Expand]CellMergeEventArgs Class
   [Expand]CellValueChangedEventArgs Class
    CellValueChangedEventHandler Delegate
   [Expand]CellValueEventArgs Class
    CellValueEventHandler Delegate
    ClipboardCopyMode Enumeration
    ClipboardCopyOptions Enumeration
    ClipboardMode Enumeration
   [Expand]ClipboardRowCellValuePastingEventArgs Class
   [Expand]ClipboardRowPastingEventArgs Class
   [Expand]ColorScaleFormatCondition Class
   [Expand]ColumnBase Class
   [Expand]ColumnChooserControl Class
   [Expand]ColumnDataEventArgsBase Class
    ColumnFilterMode Enumeration
    ColumnFilterPopupMode Enumeration
    ColumnPosition Enumeration
    CompactFilterElementShowMode Enumeration
   [Expand]CompactModeFilterItem Class
    CompactPanelShowMode Enumeration
    CompactSortElementShowMode Enumeration
   [Expand]ContentDetailDescriptor Class
   [Expand]CopyingToClipboardEventArgs Class
   [Expand]CopyingToClipboardEventArgsBase Class
    CopyingToClipboardEventHandler Delegate
   [Expand]CustomBestFitEventArgs Class
   [Expand]CustomBestFitEventArgsBase Class
    CustomBestFitEventHandler Delegate
   [Expand]CustomCellAppearanceEventArgs Class
   [Expand]CustomColumnDisplayTextEventArgs Class
    CustomColumnDisplayTextEventHandler Delegate
   [Expand]CustomColumnSortEventArgs Class
    CustomColumnSortEventHandler Delegate
   [Expand]CustomDataUpdateFormatConditionEventArgs Class
   [Expand]CustomFilterDisplayTextEventArgs Class
    CustomFilterDisplayTextEventHandler Delegate
   [Expand]CustomGroupDisplayTextEventArgs Class
    CustomGroupDisplayTextEventHandler Delegate
   [Expand]CustomRowAppearanceEventArgs Class
   [Expand]DataBarFormatCondition Class
   [Expand]DataControlBase Class
   [Expand]DataControlDetailDescriptor Class
   [Expand]DataControlSerializationOptions Class
   [Expand]DataUpdateFormatCondition Class
   [Collapse]DataViewBase Class
     DataViewBase Members
    [Expand]DataViewBase Properties
    [Expand]DataViewBase Events
    [Collapse]DataViewBase Methods
      CancelRowEdit Method
      CanMoveSearchResult Method
      ChangeHorizontalScrollOffsetBy Method
      ChangeVerticalScrollOffsetBy Method
      CloseEditor Method
     [Expand]CommitEditing Method
      CopyFocusedRowToClipboard Method
      CopyRangeToClipboard Method
      CopyRowsToClipboard Method
      CopySelectedRowsToClipboard Method
      CopyToClipboard Method
     [Expand]ExportToCsv Method
     [Expand]ExportToDocx Method
     [Expand]ExportToHtml Method
     [Expand]ExportToImage Method
     [Expand]ExportToMht Method
     [Expand]ExportToPdf Method
     [Expand]ExportToRtf Method
     [Expand]ExportToText Method
     [Collapse]ExportToXls Method
       ExportToXls(Stream) Method
       ExportToXls(String) Method
       ExportToXls(String, XlsExportOptions) Method
       ExportToXls(Stream, XlsExportOptions) Method
     [Expand]ExportToXlsx Method
     [Expand]ExportToXps Method
      GetCellElementByMouseEventArgs Method
      GetCellElementByRowHandleAndColumn Method
      GetCellElementByTreeElement Method
      GetColumnByMouseEventArgs Method
      GetColumnByTreeElement Method
      GetColumnHeaderDragIndicatorSize Method
      GetIsFocusedCell Method
      GetIsFocusedRow Method
      GetRowElementByMouseEventArgs Method
      GetRowElementByRowHandle Method
      GetRowElementByTreeElement Method
      GetRowHandle Method
      GetRowHandleByMouseEventArgs Method
      GetRowHandleByTreeElement Method
      GetSelectedRowHandles Method
      HideColumnChooser Method
      HideEditor Method
      HideSearchPanel Method
      IncrementalSearchEnd Method
      IncrementalSearchMoveNext Method
      IncrementalSearchMovePrev Method
      IsRowSelected Method
      MoveColumnTo Method
      MoveFirstRow Method
      MoveFocusedRow Method
      MoveLastRow Method
      MoveNextCell Method
      MoveNextPage Method
      MoveNextRow Method
      MovePrevCell Method
      MovePrevPage Method
      MovePrevRow Method
      PostEditor Method
      Print Method
     [Expand]PrintDirect Method
     [Expand]ScrollIntoView Method
      SearchResultNext Method
      SearchResultPrev Method
      SelectAll Method
      SetColumnHeaderDragIndicatorSize Method
      SetIsFocusedCell Method
      SetIsFocusedRow Method
      SetRowHandle Method
      ShouldSerializeColumnChooserColumns Method
      ShouldSerializeColumnChooserColumnsSortOrderComparer Method
      ShouldSerializeSearchPanelImmediateMRUPopup Method
      ShowColumnChooser Method
     [Expand]ShowEditor Method
     [Expand]ShowFilterEditor Method
      ShowFixedTotalSummaryEditor Method
     [Expand]ShowPrintPreview Method
     [Expand]ShowPrintPreviewDialog Method
      ShowSearchPanel Method
      ShowTotalSummaryEditor Method
      ShowUnboundExpressionEditor Method
      ValidateEditor Method
   [Expand]DataViewCommandsBase Class
   [Expand]DefaultColumnMenuItemNames Class
   [Expand]DefaultSummaryMenuItemNames Class
   [Expand]DetailDescriptorBase Class
   [Expand]DetailDescriptorCollection Class
   [Expand]DetailDescriptorSelector Class
   [Expand]DetailDescriptorTrigger Class
    EditFormPostMode Enumeration
   [Expand]EditFormShowingEventArgs Class
    EditFormShowMode Enumeration
   [Expand]EditGridCellData Class
    EditorButtonShowMode Enumeration
   [Expand]EditorEventArgs Class
   [Expand]EditorEventArgsBase Class
    EditorEventHandler Delegate
    ErrorsWatchMode Enumeration
   [Expand]ExcelColumnFilterSettings Class
    ExceptionMode Enumeration
   [Expand]ExpressionConditionBase Class
   [Expand]FilterEditorEventArgs Class
    FilterEditorEventHandler Delegate
   [Expand]FilterPopupEventArgs Class
    FilterPopupEventHandler Delegate
    FilterPopupMode Enumeration
    FixedRowPosition Enumeration
    FixedStyle Enumeration
   [Expand]FocusedRowChangedEventArgs Class
    FocusedRowChangedEventHandler Delegate
   [Expand]FormatCondition Class
   [Expand]FormatConditionBase Class
   [Expand]FormatConditionCollection Class
   [Expand]GridBandMenuInfo Class
   [Expand]GridCell Class
   [Expand]GridCellData Class
   [Expand]GridCellValidationEventArgs Class
    GridCellValidationEventHandler Delegate
   [Expand]GridColumn Class
   [Expand]GridColumnCollection Class
   [Expand]GridColumnCommands Class
   [Expand]GridColumnData Class
   [Expand]GridColumnDataEventArgs Class
    GridColumnDataEventHandler Delegate
   [Expand]GridColumnHeader Class
   [Expand]GridColumnHeaderBase Class
   [Expand]GridColumnWidth Structure
   [Expand]GridCommands Class
   [Expand]GridControl Class
   [Expand]GridControlBand Class
   [Expand]GridControlBandsLayout Class
   [Expand]GridControlLocalizer Class
    GridControlRuntimeStringId Enumeration
    GridControlStringId Enumeration
   [Expand]GridDataBase Class
   [Expand]GridDataViewBase Class
   [Expand]GridGroupSummaryData Class
   [Expand]GridGroupSummarySortInfo Class
   [Expand]GridGroupSummarySortInfoCollection Class
   [Expand]GridMenuEventArgs Class
    GridMenuEventHandler Delegate
   [Expand]GridMenuInfo Class
    GridMenuType Enumeration
   [Expand]GridPopupMenu Class
   [Expand]GridRowContent Class
   [Expand]GridRowValidationEventArgs Class
    GridRowValidationEventHandler Delegate
   [Expand]GridSelectionChangedEventArgs Class
    GridSelectionChangedEventHandler Delegate
   [Expand]GridSerializationOptions Class
   [Expand]GridSortInfo Class
   [Expand]GridSortInfoCollection Class
   [Expand]GridSummaryData Class
   [Expand]GridSummaryItem Class
    GridSummaryItemAlignment Enumeration
   [Expand]GridSummaryItemCollection Class
   [Expand]GridTotalSummaryData Class
   [Expand]GridViewBase Class
   [Expand]GridViewCommandsBase Class
   [Expand]GridViewHitInfoBase Class
    GridViewNavigationStyle Enumeration
   [Expand]GroupRowData Class
    GroupSummaryDisplayMode Enumeration
    HeaderPosition Enumeration
    HeaderPresenterType Enumeration
   [Expand]HeadersData Class
   [Expand]IconSetFormatCondition Class
    IncrementalSearchMode Enumeration
   [Expand]IndicatorFormatConditionBase Class
    IndicatorState Enumeration
   [Expand]InitNewRowEventArgs Class
    InitNewRowEventHandler Delegate
   [Expand]InvalidRowExceptionEventArgs Class
    InvalidRowExceptionEventHandler Delegate
   [Expand]LightweightCellEditor Class
   [Expand]LightweightCellEditorBase Class
    MergedGroupingMode Enumeration
    MergeGroupPosition Enumeration
   [Expand]MultiDetailDescriptor Class
    MultiSelectMode Enumeration
    NewItemRowPosition Enumeration
    PostConfirmationMode Enumeration
   [Expand]RowAllowEventArgs Class
    RowAllowEventHandler Delegate
    RowAnimationKind Enumeration
   [Expand]RowControl Class
   [Expand]RowData Class
   [Expand]RowDataBase Class
    RowDetailsVisibilityMode Enumeration
   [Expand]RowDoubleClickEventArgs Class
    RowDoubleClickEventHandler Delegate
   [Expand]RowEventArgs Class
    RowEventHandler Delegate
    RowFixingPosition Enumeration
    RowPosition Enumeration
    ScrollAnimationMode Enumeration
    ScrollBarAnnotationAlignment Enumeration
   [Expand]ScrollBarAnnotationInfo Class
    ScrollBarAnnotationMode Enumeration
   [Expand]ScrollBarAnnotationRowInfo Class
   [Expand]ScrollBarAnnotationsAppearance Class
   [Expand]ScrollBarAnnotationsCreatingEventArgs Class
   [Expand]ScrollBarCustomRowAnnotationEventArgs Class
    ScrollingMode Enumeration
    ScrollMode Enumeration
   [Expand]SelectedRowsCollection Class
    SelectionState Enumeration
    ShowFilterPanelMode Enumeration
    ShowFixRowButton Enumeration
   [Expand]ShowingEditorEventArgs Class
   [Expand]ShowingEditorEventArgsBase Class
    ShowingEditorEventHandler Delegate
    ShowSearchPanelMode Enumeration
   [Expand]SummaryItemBase Class
   [Expand]TableView Class
   [Expand]TableViewCommands Class
   [Expand]TableViewHitInfo Class
    TableViewHitTest Enumeration
    TableViewSelectMode Enumeration
   [Expand]TabViewDetailDescriptor Class
   [Expand]TopBottomRuleFormatCondition Class
    TreeDerivationMode Enumeration
   [Expand]TreeListBandMenuInfo Class
   [Expand]TreeListColumn Class
   [Expand]TreeListColumnCollection Class
   [Expand]TreeListControl Class
   [Expand]TreeListControlBand Class
   [Expand]TreeListControlBandsLayout Class
    TreeListFilterMode Enumeration
    TreeListLineStyle Enumeration
   [Expand]TreeListNode Class
   [Expand]TreeListNodeCollection Class
   [Expand]TreeListNodeIterator Class
   [Expand]TreeListNodeSummaryItemCollection Class
   [Expand]TreeListSortInfoCollection Class
   [Expand]TreeListSummaryItem Class
   [Expand]TreeListSummaryItemCollection Class
   [Expand]TreeListView Class
   [Expand]TreeListViewCommands Class
   [Expand]UnboundExpressionEditorEventArgs Class
    UnboundExpressionEditorEventHandler Delegate
   [Expand]UniqueDuplicateRuleFormatCondition Class
    UseCardLightweightTemplates Enumeration
    UseLightweightTemplates Enumeration
    WaitIndicatorType Enumeration
  [Expand]DevExpress.Xpf.Grid.ConditionalFormatting
  [Expand]DevExpress.Xpf.Grid.LookUp
  [Expand]DevExpress.Xpf.Grid.TreeList
  [Expand]DevExpress.Xpf.Layout.Core
  [Expand]DevExpress.Xpf.LayoutControl
  [Expand]DevExpress.Xpf.Map
  [Expand]DevExpress.Xpf.NavBar
  [Expand]DevExpress.Xpf.Navigation
  [Expand]DevExpress.Xpf.PdfViewer
  [Expand]DevExpress.Xpf.PivotGrid
  [Expand]DevExpress.Xpf.PivotGrid.Printing
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpf.Printing.Parameters
  [Expand]DevExpress.Xpf.Printing.Parameters.Models
  [Expand]DevExpress.Xpf.Printing.PreviewControl
  [Expand]DevExpress.Xpf.Printing.PreviewControl.Bars
  [Expand]DevExpress.Xpf.Prism
  [Expand]DevExpress.Xpf.PropertyGrid
  [Expand]DevExpress.Xpf.Reports.UserDesigner
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Extensions
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Localization
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard.Pages
  [Expand]DevExpress.Xpf.Ribbon
  [Expand]DevExpress.Xpf.RichEdit
  [Expand]DevExpress.Xpf.RichEdit.Menu
  [Expand]DevExpress.Xpf.Scheduler
  [Expand]DevExpress.Xpf.Scheduler.Drawing
  [Expand]DevExpress.Xpf.Scheduler.Menu
  [Expand]DevExpress.Xpf.Scheduler.Reporting
  [Expand]DevExpress.Xpf.Scheduler.UI
  [Expand]DevExpress.Xpf.Scheduling
  [Expand]DevExpress.Xpf.Scheduling.Editors
  [Expand]DevExpress.Xpf.Scheduling.Reporting
  [Expand]DevExpress.Xpf.Scheduling.Visual
  [Expand]DevExpress.Xpf.SpellChecker
  [Expand]DevExpress.Xpf.Spreadsheet
  [Expand]DevExpress.Xpf.Spreadsheet.Menu
  [Expand]DevExpress.Xpf.TreeMap
  [Expand]DevExpress.Xpf.Utils.Themes
  [Expand]DevExpress.Xpf.WindowsUI
  [Expand]DevExpress.Xpf.WindowsUI.Internal
  [Expand]DevExpress.Xpf.WindowsUI.Navigation
  [Expand]DevExpress.XtraRichEdit
[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
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

DataViewBase.ExportToXls(Stream, XlsExportOptions) Method

For internal use only.

Namespace:DevExpress.Xpf.Grid
Assembly:DevExpress.Xpf.Grid.v17.2.Core.dll

Expanded Syntax

Parameters

stream
Type: Stream
 
options
Type: XlsExportOptions
 

Expanded Remarks

To export grid data to XLS, use the ExportToXls method of a particular grid view.

Expanded See Also

How would you rate this topic?​​​​​​​