/// <summary>
/// Load a DataTable from an Excel tab into the database. A start row, and/or colum can be specified. An end column can be specified.
/// </summary>
public DataTable LoadDataTableFromExcel(string excelPath, string tabName = "", int startRow = 1, int startCol = 1, int endColIndex = 0)
{
if (MyLoadDataTableFromExcel != null)
{
return(MyLoadDataTableFromExcel(excelPath, tabName, startRow, startCol, endColIndex));
}
return(ExcelHelper.LoadDataTableFromExcel(excelPath, tabName, startRow, startCol, endColIndex));
}
public DataTable LoadDataTableFromExcel(string excelPath, string tabName = "", int startRow = 1, int startCol = 1, int endCol = 0, int endRow = 0, bool hasHeader = true)
{
if (MyLoadDataTableFromExcel != null)
{
return(MyLoadDataTableFromExcel(excelPath, tabName, startRow, startCol, endCol, endRow, hasHeader));
}
return(ExcelHelper.LoadDataTableFromExcel(excelPath, tabName, startRow, startCol, endCol, endRow, hasHeader));
}