ExcelWorksheetLoadDataTable(DataTable, Int32, Int32, Int32, Int32, Boolean) Method

public void LoadDataTable(
	DataTable dataTable,
	int topRowIndex,
	int leftColumnIndex,
	int maxRowsCount,
	int maxColumnsCount,
	bool setColumnNames
)

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

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

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

Parameters

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.

maxRowsCount  Int32

The maximum number of rows to load from data table. A negative value means to load all the rows.

maxColumnsCount  Int32

The maximum number of columns to load from data table. A negative value means to load all the columns.

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.

Reference