private static bool CellHasSpecialCharacters(SheetCell cell)
{
bool hasSpecialCharacters = false;
if (regkey.IsMatch(cell.Value))
{
hasSpecialCharacters = true;
}
return hasSpecialCharacters;
}
private static bool CellHasStyleErrors(SheetCell cell, Dictionary<int, CellFormat> sharedFormatList)
{
bool hasStyleError = false;
if (cell.ExcelCell.StyleIndex == null)
{
return hasStyleError;
}
if (cell.ExcelCell.CellValue == null && cell.ExcelCell.StyleIndex == 0)
{
hasStyleError = true;
}
else if (cell.ExcelCell.CellValue != null || cell.ExcelCell.StyleIndex >= 0)
{
CellFormat cellformate = sharedFormatList[Convert.ToInt32(cell.ExcelCell.StyleIndex.Value)];
if ((cellformate.FontId != null && cellformate.FontId > 0 && cell.ExcelCell.DataType != null) ||
(cellformate.FillId != null && cellformate.FillId > 0))
{
hasStyleError = true;
}
}
return hasStyleError;
}
private static bool CellHasCommas(SheetCell cell)
{
bool hasCommas = false;
if (!string.IsNullOrWhiteSpace(cell.Value.ToString()) && cell.Value.Contains(','))
{
hasCommas = true;
}
return hasCommas;
}