ExpertXls Excel Library for .NET
LoadDataTable Method (dataTable, topRowIndex, leftColumnIndex, maxRowsCount, maxColumnsCount, setColumnNames)
Namespaces ► ExpertXls.ExcelLib ► ExcelWorksheet ► LoadDataTable(DataTable, Int32, Int32, Int32, Int32, Boolean)
ExpertXls Excel Library for .NET
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.
Declaration Syntax

C# | Visual Basic | Visual C++

    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
    )

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.

Assembly: ExpertXls.ExcelLib (Module: ExpertXls.ExcelLib) Version: 2.1.0.0 (2.1.0.0)