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