ImportFromDataGridViewOptions Class

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

Represents options for importing data from System.Windows.Forms.DataGridView to ExcelWorksheet.

public sealed class ImportFromDataGridViewOptions
Public NotInheritable Class ImportFromDataGridViewOptions
Inheritance:
System.Object
ImportFromDataGridViewOptions

Constructors

ImportFromDataGridViewOptions()

Initializes an instance of ImportFromDataGridViewOptions class.

public ImportFromDataGridViewOptions()
Public Sub New

ImportFromDataGridViewOptions(Int32, Int32)

Initializes an instance of ImportFromDataGridViewOptions class.

public ImportFromDataGridViewOptions(int startRow, int startColumn)
Public Sub New(startRow As Integer, startColumn As Integer)
Parameters
startRow
System.Int32

Index of the first row of imported data in ExcelWorksheet.

startColumn
System.Int32

Index of the first column of imported data in ExcelWorksheet.

ImportFromDataGridViewOptions(String)

Initializes an instance of ImportFromDataGridViewOptions class.

public ImportFromDataGridViewOptions(string startCell)
Public Sub New(startCell As String)
Parameters
startCell
System.String

Name of the first (top left) cell of imported data in ExcelWorksheet.

Properties

ColumnHeaders

Gets or sets a value indicating whether to import column headers into first row.

public bool ColumnHeaders { get; set; }
Public Property ColumnHeaders As Boolean
Property Value
System.Boolean

StartColumn

Gets or sets the index of the first column of imported data in ExcelWorksheet.

public int StartColumn { get; set; }
Public Property StartColumn As Integer
Property Value
System.Int32

StartRow

Gets or sets the index of the first row of imported data in ExcelWorksheet.

public int StartRow { get; set; }
Public Property StartRow As Integer
Property Value
System.Int32

Examples