ExcelWorksheetLoadDataTable Method (DataTable, Int32, Int32, Boolean)

Winnovative Excel Library Documentation

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: Winnovative.ExcelLib
Assembly: wnvxls (in wnvxls.dll) Version: 10.0.0.0 (10.0.0.0)

Syntax

C++

Copy

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
)

public:
void LoadDataTable(
	DataTable^ dataTable, 
	int topRowIndex, 
	int leftColumnIndex, 
	bool setColumnNames
)

member LoadDataTable : 
        dataTable : DataTable * 
        topRowIndex : int * 
        leftColumnIndex : int * 
        setColumnNames : bool -> unit

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.

Reference

ExcelWorksheet Class

LoadDataTable Overload

Winnovative.ExcelLib Namespace

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

Parameters

Reference

ExcelWorksheetLoadDataTable Method (DataTable, Int32, Int32, Boolean)