Preserving data validations

[rsharma123]

I am trying to preserve data validations in an excel sheet while editing it through PHPExcel but all are vanishing for now. Can any one suggest me what to do if some one has tried it and got success in doing the same

[billlater]

I think, your file was created in Office 2010. Excel 2010 writes "data validations" in another place. I saw a class PHPExcel_Reader_Excel2007. Class don't reads this place. I created the same file in Excel2007 and everything works