Xceed Logo
Shop
Xceed DataGrid for WPF v7.3 Documentation
[Root] / Xceed.Wpf.DataGrid Assembly / Xceed.Wpf.DataGrid.Export Namespace / ExcelExporter Class


In This Topic
    ExcelExporter Class
    In This Topic
    This class, which derives from the ExcelExporterBase class, allows to export data from the grid in the xmlss format. 
    Syntax
    'Declaration
 
Public Class ExcelExporter 
   Inherits ExcelExporterBase
    'Usage
 
Dim instance As ExcelExporter
    public class ExcelExporter : ExcelExporterBase
    Remarks
    This class offers more options than the ExportToExcel method, allowing details and statistical functions to be exported.
    Inheritance Hierarchy

    System.Object
       Xceed.Wpf.DataGrid.Export.ExporterBase
          Xceed.Wpf.DataGrid.Export.ExcelExporterBase
             Xceed.Wpf.DataGrid.Export.ExcelExporter

    Public Constructors
     NameDescription
    Public ConstructorExcelExporter Constructor  
    Top
    Public Properties
     NameDescription
    Public PropertyDetailDepthGets or sets the number of detail levels that will be exported. (Inherited from Xceed.Wpf.DataGrid.Export.ExporterBase)
    Public PropertyExportStatFunctionsAsFormulasGets or sets a value indicating whether statistical functions should be exported as formulas or if only their resulting value should be exported. (Inherited from Xceed.Wpf.DataGrid.Export.ExcelExporterBase)
    Public PropertyFixedColumnCountGets or sets the number of columns that are fixed when they are exported using the ExcelExporter class. (Inherited from Xceed.Wpf.DataGrid.Export.ExcelExporterBase)
    Public PropertyGroupHeaderFormatGets the GroupHeaderFormat object used to determine the text displayed in the group headers. (Inherited from Xceed.Wpf.DataGrid.Export.ExcelExporterBase)
    Public PropertyIncludeColumnHeadersGets or sets a boolean value that indicates whether column headers will be exported. (Inherited from Xceed.Wpf.DataGrid.Export.ExporterBase)
    Public PropertyIsHeaderFixedGets or sets a value indicating whether the column header will scroll with the content or remain fixed at the top of the spreadsheet. (Inherited from Xceed.Wpf.DataGrid.Export.ExcelExporterBase)
    Public PropertyRepeatParentDataGets or sets a boolean value indicating whether a parent detail's and the master grid's information should be repeated. (Inherited from Xceed.Wpf.DataGrid.Export.ExporterBase)
    Public PropertyShowStatsInDetailsGets or sets a boolean value indicating whether the results of statistical functions should also be displayed in details. (Inherited from Xceed.Wpf.DataGrid.Export.ExporterBase)
    Public PropertyStatFunctionDepthGets or sets a value representing how "deeply" statistical functions are to be displayed. (Inherited from Xceed.Wpf.DataGrid.Export.ExporterBase)
    Public PropertyUseFieldNamesInHeaderGets or sets a boolean value indicating whether the column titles or the column field names are displayed in the headers. (Inherited from Xceed.Wpf.DataGrid.Export.ExporterBase)
    Top
    Protected Properties
     NameDescription
    Protected PropertyBaseStreamGets the base stream used for the export. (Inherited from Xceed.Wpf.DataGrid.Export.ExporterBase)
    Top
    Public Methods
     NameDescription
    Public MethodExportOverloaded. Starts the export process. (Inherited from Xceed.Wpf.DataGrid.Export.ExporterBase)
    Top
    Protected Methods
     NameDescription
    Protected MethodAlignDetailsWithParentSets if data & columns originating from details should align on the master element.  (Inherited from Xceed.Wpf.DataGrid.Export.ExcelExporterBase)
    Protected MethodEndDataItemOverridden. Called after each data item is exported.  
    Protected MethodEndDataItemFieldOverridden. Called after each field in a data item is exported.  
    Protected MethodEndExcelRowCalled after a row has been exported to Excel.  
    Protected MethodEndExportOverloaded. Overridden. Called after the export has finished.  
    Protected MethodEndGroupOverridden. Called after a group has been exported.  
    Protected MethodEndHeaderOverridden. Called after the headers of each master or detail level is exported.  
    Protected MethodEndHeaderFieldOverridden. Called after each field in a header is exported.  
    Protected MethodEndSummaryOverridden. Called after each summary is exported.  
    Protected MethodGenerateGroupHeaderValueSets the value that will be used for the group's header. (Inherited from Xceed.Wpf.DataGrid.Export.ExcelExporterBase)
    Protected MethodGetExcelFormulaConverterGets the ExcelFormulaConverter that will be used to produce the Excel formula corresponding to the provided StatFunction.  (Inherited from Xceed.Wpf.DataGrid.Export.ExcelExporterBase)
    Protected MethodStartDataItemOverridden. Called before each data item is exported.  
    Protected MethodStartDataItemFieldOverridden. Called before each field in a data item is exported.  
    Protected MethodStartExcelRowCalled before an Excel row is exported.  
    Protected MethodStartExportOverloaded. Overridden. Called be an export begins.  
    Protected MethodStartGroupOverridden. Called before a group is exported.  
    Protected MethodStartHeaderOverridden. Called before the headers of each master or detail level is exported.  
    Protected MethodStartHeaderFieldOverridden. Called before each field in a header is exported.  
    Protected MethodStartSummaryOverridden. Called before each summary is exported.  
    Protected MethodStartSummaryFieldOverridden. Called before each summary field is exported.  
    Top
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net20, net35, net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    ExcelExporter Members
    Xceed.Wpf.DataGrid.Export Namespace

    Send Feedback