Click or drag to resize

ExcelWorksheet.LoadDataView 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
Copy
public void LoadDataView(
	DataView dataView,
	int topRowIndex,
	int leftColumnIndex,
	int maxRowsCount,
	int maxColumnsCount,
	bool setColumnNames
)

Parameters

dataView
Type: System.Data.DataView
The DataView object to be imported.
topRowIndex
Type: System.Int32
The top row index of the range where the values will be loaded in worksheet.
leftColumnIndex
Type: System.Int32
The left column index of the range where the values will be loaded in worksheet.
maxRowsCount
Type: System.Int32
The maximum number of rows to load from data view. A negative value means to load all the rows.
maxColumnsCount
Type: System.Int32
The maximum number of columns to load from data view. A negative value means to load all the columns.
setColumnNames
Type: System.Boolean
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