EMail Validation for particular Column

Posted by: narayanan on 8 September 2017, 3:07 pm EST

  • Posted 8 September 2017, 3:07 pm EST

    Hi All,

      I am using Far point Version 4.0 .User wants to insert the <b>EMail id </b>the Spread sheet. 

  • Replied 8 September 2017, 3:07 pm EST


    You can use RegularExpressionCellType for that matter as given below:-

                FarPoint.Win.Spread.CellType.RegularExpressionCellType regexcell = new FarPoint.Win.Spread.CellType.RegularExpressionCellType();
                regexcell.RegularExpression = @"^[a-z][a-z|0-9|]*([_][a-z|0-9]+)*([.][a-z|0-9]+([_][a-z|0-9]+)*)?@[a-z][a-z|0-9|]*\.([a-z][a-z|0-9]*(\.[a-z][a-z|0-9]*)?)$";
                fpSpread1.ActiveSheet.Columns[0].CellType = regexcell;

    Hope it helps.



  • Replied 31 October 2018, 5:44 am EST

    Hello Narayanan, I am trying to validate my email account for particular Column. On the above you have mentioned a statement I have applied but cannot resolve this issue. Please help. If you are trying to Download AOL Gold on your PC then I recommend this site
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels