Click or drag to resize

ExcelWorksheetLoadDataTable Method (DataTable, Int32, Int32, Boolean)

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.

Namespace:  ExpertXls.ExcelLib
Assembly:  expertxls (in expertxls.dll) Version: 7.0.0
Syntax
public void LoadDataTable(
	DataTable dataTable,
	int topRowIndex,
	int leftColumnIndex,
	bool setColumnNames
)

Parameters

dataTable
Type: System.DataDataTable
The DataTable object to be imported.
topRowIndex
Type: SystemInt32
The top row index of the range where the values will be loaded in worksheet.
leftColumnIndex
Type: SystemInt32
The left column index of the range where the values will be loaded in worksheet.
setColumnNames
Type: SystemBoolean
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