Click or drag to resize

ExcelHelperLoadDataTableFromExcel Method

Load a DataTable from an Excel file. A start and end row, and/or colum can be specified. If hasHeader is false, column names are automatic.

Namespace: Seal.Helpers
Assembly: SealLibrary (in SealLibrary.dll) Version: 8.0.0.0+c5a14bc14715399f60fcf611201a5e8ad953fbc3
Syntax
C#
Copy
public static DataTable LoadDataTableFromExcel(
	string excelPath,
	string tabName = "",
	int startRow = 1,
	int startCol = 1,
	int endCol = 0,
	int endRow = 0,
	bool hasHeader = true
)

Parameters

excelPath  String
 
tabName  String  (Optional)
 
startRow  Int32  (Optional)
 
startCol  Int32  (Optional)
 
endCol  Int32  (Optional)
 
endRow  Int32  (Optional)
 
hasHeader  Boolean  (Optional)
 

Return Value

DataTable
See Also