Click or drag to resize

ExcelWorksheetLoadDataView Method (DataView, Int32, Int32, Int32, Int32, Boolean)

Loads the values from the specified System.Data.DataView 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 LoadDataView(
	DataView dataView,
	int topRowIndex,
	int leftColumnIndex,
	int maxRowsCount,
	int maxColumnsCount,
	bool setColumnNames
)

Parameters

dataView
Type: System.DataDataView
The DataView 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 view. A negative value means to load all the rows.
maxColumnsCount
Type: SystemInt32
The maximum number of columns to load from data view. A negative value means to load all the columns.
setColumnNames
Type: SystemBoolean
A flag indicating if the column names from DataView should be used or not to create a header row in the range where the values are imported.
See Also