使用兼容2007和2003的PHP创建excel文件

Question

am creating a .xls file using PHP fopen

write and append the contents to the file. Works fine with Excel 2003.

But excel 2007 showing a alert before opening as un supported type.

If i create file with .xlsx extension , it is not opening in 2003.

Is there any standard way that works fine in both 2003 and 2007 versions .

Answer 1

What format are you actually writing? Writing an Excel file isn't simply a matter of giving an arbitrary file an extension of xlsx or xls.

For commonality, you can write a BIFF5 or BIFF8 xls file (all versions of Excel post 95 will read this), or there is the Excel 2003 XML format, which can be opened by both Excel 2003 and Excel2007 (and Excel 2010 as well).