private static int?GetNullableInt(ExcelWorksheet sheet, PersonImport columnId, int rowNumber)
{
var cellValue = sheet.Cells[rowNumber, columnId.ToInt()].Text;
if (string.IsNullOrEmpty(cellValue))
{
return(null);
}
if (int.TryParse(cellValue, out var intValue))
{
return(intValue);
}
return(null);
}
private static string ReadStringCell(ExcelWorksheet sheet, int rowNumber, PersonImport columnId)
{
return(sheet.Cells[rowNumber, columnId.ToInt()].Text.Trim());
}
private static int?ReadNullableIntCell(ExcelWorksheet sheet, int rowNumber, PersonImport columnId)
{
return(ReadNullableIntCell(sheet, rowNumber, columnId.ToInt()));
}
