Click or drag to resize

TaskHelperLoadTableFromExcel(String, String, String, String, Boolean, Int32, Int32, Int32, Int32, Boolean, Boolean) Method

Load a table from an Excel tab into the database. A start row, and/or column can be specified. An end column can be specified.

Namespace: Seal.Helpers
Assembly: SealLibrary (in SealLibrary.dll) Version: 8.1.0.0+4fe7975a95558d7cdf0d4c425e2c3a22827d67dd
Syntax
C#
public bool LoadTableFromExcel(
	string loadFolder,
	string sourceExcelPath,
	string sourceTabName,
	string destinationTableName,
	bool useAllConnections = false,
	int startRow = 1,
	int startColumn = 1,
	int endColumnIndex = 0,
	int endRowIndex = 0,
	bool hasHeader = true,
	bool forceLoad = false
)

Parameters

loadFolder  String
 
sourceExcelPath  String
 
sourceTabName  String
 
destinationTableName  String
 
useAllConnections  Boolean  (Optional)
 
startRow  Int32  (Optional)
 
startColumn  Int32  (Optional)
 
endColumnIndex  Int32  (Optional)
 
endRowIndex  Int32  (Optional)
 
hasHeader  Boolean  (Optional)
 
forceLoad  Boolean  (Optional)
 

Return Value

Boolean
See Also