Click or drag to resize

ExcelWorksheetLoadDataTable Method (DataTable, Int32, Int32, 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,
	int maxRowsCount,
	int maxColumnsCount,
	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.
maxRowsCount
Type: SystemInt32
The maximum number of rows to load from data table. A negative value means to load all the rows.
maxColumnsCount
Type: SystemInt32
The maximum number of columns to load from data table. A negative value means to load all the columns.
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