Click or drag to resize

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

Load a table from an Excel tab into the database. If the tab name is empty or contains a wildcard, all matching tabs are loaded. Returns the number of rows inserted.

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

Parameters

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

Return Value

Int32
See Also