Syncfusion.GridConverter.Windows
Fields  Properties  Methods  Events


Syncfusion.GridExcelConverter Namespace : GridExcelConverterControl Class

GridExcelConverterControl Class Members

The following tables list the members exposed by GridExcelConverterControl.

Public Constructors
 NameDescription
Public ConstructorInitializes a new instance of the GridExcelConverterControl class.  
Top
Public Fields
 NameDescription
Public Fieldstatic (Shared in Visual Basic)After v6.1 ExcelToGrid Conversion will check for Merged cells when importing borders. When there is no merged cells this can be set to true to avoid checking for MergeCells on importing borders from excel cells.

Default value is false.

 
Top
Protected Fields
 NameDescription
Protected Field Gets the number format in Excel (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Protected Field variable setting whether header has fore color (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Protected Field variable setting whether header has back color (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Top
Public Properties
 NameDescription
Public Property Gets or sets a value Indicating whether converter should auto fit the columns.  
Public Property Gets or sets a value Indicating whether converter should auto fit the rows.  
Public Property Gets or set a value indicating whether grid cell's combobox has to be exported as Excel sheet's DataValidation dropdown list.  
Public PropertyGets or sets a value indicating whether grid's column width has to be exported to Excel. If you want to disable this column width, you can set False and assign your needed RowHeight in DefaultRowHeight property.  
Public PropertyGets or sets a value indicating whether grid's row height has to be exported to Excel. If you want to disable this row height, you can set False and assign your needed RowHeight in DefaultRowHeight property.  
Public Property (Inherited from System.ComponentModel.Component)
Public PropertyGets or sets the default column width in Excel sheet for all columns. This is applicable when disabling CanExportColumnWidth and AutoFitColumns.  
Public PropertyGets or sets the default row height in Excel sheet for all rows. This is applicable when disabling CanExportRowHeight and AutoFitRows.  
Public Property Gets or sets the excel sheet's default version.  
Public Property Gets or sets a value indicating whether the cell borders should be exported. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Public Property Gets or sets the mode for exporting the hidden columns with various options.  
Public Property Gets or sets the mode for exporting the hidden columns with various options.  
Public Property Gets or sets a value indicating whether export the images into excel. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Public Property Gets or sets a value indicating whether the styles should get exported. The default value is true. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Public Property Gets or sets the exported header cell's back color in worksheet. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Public Property Gets or sets a value indicating whether the borders has to be imported.  
Public Property Gets or sets a value indicating whether the styles like fonts, borders, alignment, and so on has to be imported.  
Public Property Gets a string array that holds strings used with MessageBoxes that display error conditions.  
Public Property Gets or sets a value indicating whether gridlines has to be shown in Excel sheet.  
Public Property (Inherited from System.ComponentModel.Component)
Public Property Gets a value indicating whether default alignment setting should be used when alignment wasn't set. Read-only. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Top
Protected Properties
Public Methods
 NameDescription
Public MethodOverloaded.  Adds the custom function in excel work book while exporting  
Public Method Converts the Excel range to grid model.  
Public Method Converts the excel range to virtual grid.  
Public Method (Inherited from System.MarshalByRefObject)
Public MethodOverloaded. Overridden.  Releases the unmanaged resources used by the System.ComponentModel.Component and optionally releases the managed resources.  
Public MethodOverloaded.  Imports the excel file to GridControl.  
Public MethodOverloaded.  Imports the single sheet from excel to virtual grid.  
Public MethodOverloaded.  Exports the specified range to excel from GridModel to Excel.  
Public Method (Inherited from System.MarshalByRefObject)
Public Method Exports the grid cell to excel cell.  
Public MethodOverloaded.  Exports grid into excel file.  
Public Method (Inherited from System.MarshalByRefObject)
Public Method Saves the changes made in grid to Excel sheet. This is mainly used for Virtual grid importing. This method can be used in SaveCellInfo event.  
Public Method Exports the selected range from grid model to Excel.  
Public Method (Inherited from System.ComponentModel.Component)
Top
Protected Methods
 NameDescription
Protected Method Determines whether styles should be combined for specified cell styles and combines cell's interior, alignment, borders, font, cell type, format to destination cell. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Protected Method Creates excel engine. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Protected Method Exports alignment settings from grid cell into excel cell. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Protected MethodOverloaded.  Exports borders settings from grid cell into excel cell. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Protected Method Exports brush settings from grid cell into excel cell. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Protected Method Exports the cell data from grid to Excel.  
Protected Method Exports the column widths to Excel.  
Protected Method Exports the font settings from grid cell into excel cell. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Protected MethodOverloaded.  Exports the image from the grid cell to excel cell range. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Protected Method Exports the number format index for a range from specified grid style. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Protected Method Exports the row heights to Excel.  
Protected MethodOverloaded.  Exports the styles to Excel. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Protected Method (Inherited from System.ComponentModel.Component)
Protected Method (Inherited from System.ComponentModel.Component)
Protected Method Sets alignment of the GridStyleInfo.  
Protected Method Imports the excel style borders to Grid cells (for normal excel importing).  
Protected Method Sets grid cell borders based on excel style. This is specifically used for Virtual Grid.  
Protected Method Imports the excel style into GridControl.  
Protected Method Imports the grid cell style based on excel style for Virtual GridControl.  
Protected Method Imports the column width information from excel worksheet into grid.  
Protected Method Imports the combobox from excel worksheet into grid.  
Protected Method Imports the font for the cell based on ExcelRW style.  
Protected Method Imports the freeze panes from excel worksheet into grid.  
Protected Method Imports the grid line visibility to grid.  
Protected Method Imports the hyperlink to normal grid.  
Protected Method Imports the images from Excel sheet.  
Protected Method Imports the merged ranges into grid.  
Protected Method Copies the named range from excel worksheet into grid.  
Protected Method Imports the number format from excel style into grid cell.  
Protected Method Imports the orientation settings from excel style into grid cell.  
Protected Method Imports the row height information from excel worksheet into grid.  
Protected MethodOverloaded.  (Inherited from System.MarshalByRefObject)
Protected MethodInitiates call to OnQueryImportExportCellInfo. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Top
Extension Methods
 NameDescription
Public Extension MethodOverloaded.  Iterates the index.
Public Extension MethodOverloaded.  Iterates the index.
Top
Public Events
 NameDescription
Public Event (Inherited from System.ComponentModel.Component)
Public EventOccurs for each cell before the GridExcelConverterControl imports/ exports and let users customize the cell info. (Inherited from Syncfusion.GridExcelConverter.GridExcelConverterBase)
Top
See Also