InsertDataTableOptions Class

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

Represents options for inserting data from System.Data.DataTable to ExcelWorksheet.

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

Constructors

InsertDataTableOptions()

Initializes an instance of InsertDataTableOptions class.

public InsertDataTableOptions()
Public Sub New

InsertDataTableOptions(Int32, Int32)

Initializes an instance of InsertDataTableOptions class.

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

Index of the first row of inserted data in ExcelWorksheet.

startColumn
System.Int32

Index of the first column of inserted data in ExcelWorksheet.

InsertDataTableOptions(String)

Initializes an instance of InsertDataTableOptions class.

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

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

Properties

ColumnHeaders

Gets or sets a value indicating whether to insert column headers.

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 inserted 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 inserted data in ExcelWorksheet.

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

Events

DataTableCellToExcelCellConverting

Event that fires when converting System.Data.DataTable cell value to ExcelCell value.

public event EventHandler<DataTableCellToExcelCellConvertingEventArgs> DataTableCellToExcelCellConverting
Public Event DataTableCellToExcelCellConverting As EventHandler(Of DataTableCellToExcelCellConvertingEventArgs)
Event Type
System.EventHandler<DataTableCellToExcelCellConvertingEventArgs>

Examples

See Also