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
)

Public Sub LoadDataTable ( 
	dataTable As DataTable,
	topRowIndex As Integer,
	leftColumnIndex As Integer,
	setColumnNames As Boolean
)

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.

ExcelWorksheetAddLanguageSpecificTextSet("LST5D1BC316_0?cpp=::|nu=.");LoadDataTable Method (DataTable, Int32, Int32, Boolean)