DataGridViewConverter Class

Namespace:
GemBox.Spreadsheet.WinFormsUtilities
Assembly:
GemBox.Spreadsheet.dll

DataGridViewConverter is used for importing System.Windows.Forms.DataGridView control into ExcelWorksheet and exporting a CellRange from ExcelWorksheet into System.Windows.Forms.DataGridView control.

public static class DataGridViewConverter
Public Module DataGridViewConverter
Inheritance:
System.Object
DataGridViewConverter

Methods

ExportToDataGridView(ExcelWorksheet, DataGridView, ExportToDataGridViewOptions)

Imports data from ExcelWorksheet to System.Windows.Forms.DataGridView using specified ExportToDataGridViewOptions.

public static void ExportToDataGridView(ExcelWorksheet worksheet, DataGridView dataGridView, ExportToDataGridViewOptions options)
Public Shared Sub ExportToDataGridView(worksheet As ExcelWorksheet, dataGridView As DataGridView, options As ExportToDataGridViewOptions)
Parameters
worksheet
ExcelWorksheet
dataGridView
System.Windows.Forms.DataGridView

Destination System.Windows.Forms.DataGridView.

options
ExportToDataGridViewOptions

ImportFromDataGridView(ExcelWorksheet, DataGridView, ImportFromDataGridViewOptions)

Imports data from System.Windows.Forms.DataGridView control into ExcelWorksheet using specified ImportFromDataGridViewOptions.

public static void ImportFromDataGridView(ExcelWorksheet worksheet, DataGridView dataGridView, ImportFromDataGridViewOptions options)
Public Shared Sub ImportFromDataGridView(worksheet As ExcelWorksheet, dataGridView As DataGridView, options As ImportFromDataGridViewOptions)
Parameters
worksheet
ExcelWorksheet

Destination ExcelWorksheet.

dataGridView
System.Windows.Forms.DataGridView

Source System.Windows.Forms.DataGridView.

options
ImportFromDataGridViewOptions

Examples