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.HelpersAssembly: SealLibrary (in SealLibrary.dll) Version: 8.1.0.0+4fe7975a95558d7cdf0d4c425e2c3a22827d67dd
Syntax 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
BooleanSee Also