ExcelWorksheetLoadDataTable(DataTable, Int32, Int32, Boolean) Method

Loads the values from the specified System.Data.DataTable object into the worksheet at the location given by the top row and left column indexes.

Definition

Namespace: Winnovative.ExcelLib
Assembly: WnvXls_NetCore (in WnvXls_NetCore.dll) Version: 11.0.0
C#
public void LoadDataTable(
	DataTable dataTable,
	int topRowIndex,
	int leftColumnIndex,
	bool setColumnNames
)

Parameters

dataTable  DataTable
The DataTable object to be imported.
topRowIndex  Int32
The top row index of the range where the values will be loaded in worksheet.
leftColumnIndex  Int32
The left column index of the range where the values will be loaded in worksheet.
setColumnNames  Boolean
A flag indicating if the column names from DataTable should be used or not to create a header row in the range where the values are imported.

See Also