private static int GetRowCount(ExcelConnection connection, string sheetName)
{
var data = new DataTable();
var dataAdapter = new ExcelDataAdapter($"SELECT count(*) from [{sheetName}]", connection);
dataAdapter.Fill(data);
return(Convert.ToInt32(data.Rows[0][0]));
}
private static int AssignRownAndColumnIndex(ExcelConnection connection, string sheetName, List <Column> columns)
{
var data = new DataTable();
var dataAdapter = new ExcelDataAdapter($"SELECT top 100 * from [{sheetName}]", connection);
dataAdapter.Fill(data);
foreach (DataRow dataRow in data.Rows)
{
var headerRowId = UpdateRowAndColumIndex(dataRow, columns);
if (headerRowId != 0)
{
return(headerRowId);
}
}
return(0);
}