Validate Spreadsheet? XML Schema for OpenXML Excel?

Topics: Developer Forum
Dec 6, 2009 at 8:11 AM


Does PHPExcel provide a way to validate if an Excel spreadsheet .xlsx is syntactically correct?

If so, then how is it done?

Curious, is there a standard XML Schema file used to validate OpenXML Excel files?


Jeff in Seattle

Jan 21, 2010 at 7:55 AM

No, this is not a feature of PHPExcel.

The reader knows what namespaces and elements that can be present, based on the OpenXML specs (part 4). Same goes for the writer.

No XML Schema is used to validate the document after writing.