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.

Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 9.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 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.