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); }