Xceed Grid for WinForms v4.3 Documentation
Xceed.Grid.v4.3 Assembly / Xceed.Grid.Exporting Namespace / ExcelExporter Class
Members


In This Topic
    ExcelExporter Class
    In This Topic
    The ExcelExporter class allows data from a Xceed.Grid.GridControl to be exported as a spreadsheet in XML format, suitable for import into Microsoft Excel.
    Syntax
    'Declaration
     
    Public Class ExcelExporter 
    'Usage
     
    Dim instance As ExcelExporter
    public class ExcelExporter 
    Inheritance Hierarchy

    System.Object
       Xceed.Grid.Exporting.ExcelExporter

    Public Constructors
     NameDescription
    Public Constructor  
    Top
    Public Properties
     NameDescription
    Public PropertyGets or sets an CellDataFormat value representing how the content of a cell is treated.  
    Public PropertyGets or sets the style of the column header.  
    Public PropertyGets a list of custom styles.  
    Public PropertyGets or sets the mode used to determine how detail grids are presented in the exported grid.  
    Public PropertyGets or sets the color of the spreadsheet's grid lines.  
    Public PropertyGets or sets a boolean value indicating whether column headers are to be included in the exported grid.  
    Public PropertyGets or sets a boolean value indicating whether detail grids are to be included in the exported grid.  
    Public PropertyGets or sets a boolean value indicating whether the styles of the GridControl whose data is to be exported should be used in the exported spreadsheet.  
    Public PropertyGets or sets a boolean value indicating whether parent data rows should be repeated with every child row in the exported grid.  
    Top
    Protected Properties
     NameDescription
    Protected PropertyGets the default value of the CellDataFormat property  
    Protected PropertyGets the default value of the ColumnHeaderStyle property  
    Protected PropertyGets the default value of the DetailGridsMode property.  
    Protected PropertyGets the default value of the GridLineColor property.  
    Protected PropertyGets the default value of the IncludeColumnHeaders property.  
    Protected PropertyGets the default value of the IncludeDetailGrids property.  
    Protected PropertyGets the default value of the IncludeGridStyles property.  
    Protected PropertyGets the default value of the RepeatParentData property.  
    Protected PropertyGets a list of the events to which the grid element is subscribed.  
    Protected PropertyGets a collection of property names whose values have been explicitly set as well as the corresponding values.  
    Top
    Public Methods
     NameDescription
    Public MethodOverloaded. Exports the data of a Xceed.Grid.GridControl to a spreadsheet in XML suitable for import into Microsoft Excel.  
    Public MethodResets the value of the CellDataFormat property to its default value, DefaultCellDataFormat.  
    Public MethodResets the value of the ColumnHeaderStyle property to its default value, DefaultColumnHeaderStyle.  
    Public MethodResets the value of the DetailGridsMode property to its default value, DefaultDetailGridsMode.  
    Public MethodResets the value of the GridLineColor property to its default value, DefaultGridLineColor.  
    Public MethodResets the value of the IncludeColumnHeaders property to its default value, DefaultIncludeColumnHeaders.  
    Public MethodResets the value of the IncludeDetailGrids property to its default value, DefaultIncludeDetailGrids.  
    Public MethodResets the value of the IncludeGridStyles property to its default value, DefaultIncludeGridStyles.  
    Public MethodResets the value of the RepeatParentData property to its default value, DefaultRepeatParentData.  
    Top
    Protected Methods
     NameDescription
    Protected MethodRetrieves the value of the specified property in the Properties collection.  
    Protected MethodRetrieves a boolean value indicating if the specified property has been explicitly set.  
    Protected MethodRaises the CellDataFormatChanged event.  
    Protected MethodRaises the ColumnHeaderStyleChanged event.  
    Protected MethodRaises the DetailGridsModeChanged event.  
    Protected MethodRaises the GridLineColorChanged event.  
    Protected MethodRaises the IncludeColumnHeadersChanged event.  
    Protected MethodRaises the IncludeDetailGridsChanged event.  
    Protected MethodRaises the IncludeGridStylesChanged event.  
    Protected MethodRaises the RepeatParentDataChanged event.  
    Protected MethodRaises the WritingCell event.  
    Protected MethodRaises the WritingColumn event.  
    Protected MethodRaises the WritingRow event.  
    Protected MethodRaises the WritingTable event.  
    Protected MethodRaises the WritingWorkbook event.  
    Protected MethodRaises the WritingWorksheet event.  
    Protected MethodRaises the specified event.  
    Protected MethodRemoves the specified property from the Properties collection.  
    Top
    Public Events
     NameDescription
    Public EventRaised when the value of the CellDataFormat property is changed.  
    Public EventRaised when the value of the ColumnHeaderStyle property is changed.  
    Public EventRaised when the value of the DetailGridsMode property is changed.  
    Public EventRaised when the value of the GridLineColor property is changed.  
    Public EventRaised when the value of the IncludeColumnHeaders property is changed.  
    Public EventRaised when the value of the IncludeDetailGrids property is changed.  
    Public EventRaised when the value of the IncludeGridStyles property is changed.  
    Public EventRaised when the value of the RepeatParentData property is changed.  
    Public EventRaised when a Cell element is being written.  
    Public EventRaised when a Column element is being written.  
    Public EventRaised when a Row element is being written.  
    Public EventRaised when a Table element is being written.  
    Public EventRaised when a Workbook element is being written.  
    Public EventRaised when a Worksheet element is being written  
    Top
    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also