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


In This Topic
    WorkbooksExporter Class
    In This Topic
    This class is used to export data from the Grid into an Excel Workbooks file (.xlsx).
    Syntax
    'Declaration
 
Public NotInheritable Class WorkbooksExporter 
   Inherits Xceed.Wpf.DataGrid.Export.ExcelExporterBase
    'Usage
 
Dim instance As WorkbooksExporter
    public sealed class WorkbooksExporter : Xceed.Wpf.DataGrid.Export.ExcelExporterBase
    Remarks
    This class derives from ExcelExporterBase. 
    Inheritance Hierarchy

    System.Object
       Xceed.Wpf.DataGrid.Export.ExporterBase
          Xceed.Wpf.DataGrid.Export.ExcelExporterBase
             Xceed.Wpf.DataGrid.Workbooks.WorkbooksExporter

    Public Constructors
     NameDescription
    Public ConstructorWorkbooksExporter 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 the value resulting from said functions should be exported.  (Inherited from Xceed.Wpf.DataGrid.Export.ExcelExporterBase)
    Public PropertyFixedColumnCountGets or sets the number of fixed columns when columns 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.   
    Protected MethodEndExportOverloaded. Overridden.   
    Protected MethodEndGroupOverridden.   
    Protected MethodEndSummaryOverridden.   
    Protected MethodGenerateGroupHeaderValueSets the value that will be used for the group's header. (Inherited from Xceed.Wpf.DataGrid.Export.ExcelExporterBase)
    Protected MethodGetExcelFormulaConverterOverridden. Gets the ExcelFormulaConverter that will be used to produce the Excel formula corresponding to the provided StatFunction.   
    Protected MethodStartDataItemOverridden.   
    Protected MethodStartDataItemFieldOverridden.   
    Protected MethodStartExportOverloaded. Overridden.   
    Protected MethodStartGroupOverridden.   
    Protected MethodStartHeaderOverridden.   
    Protected MethodStartHeaderFieldOverridden.   
    Protected MethodStartSummaryOverridden.   
    Protected MethodStartSummaryFieldOverridden.   
    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

    WorkbooksExporter Members
    Xceed.Wpf.DataGrid.Workbooks Namespace

    Send Feedback