Which Format is Written by Excel5, BIFF5 or BIFF8?

Topics: Developer Forum, Project Management Forum, User Forum
Sep 29, 2012 at 4:33 PM
Edited Sep 29, 2012 at 5:42 PM

PHPExcel 1.7.7, PHP 5.2.1

I have a script that writes an Excel5 file for import into SQL Server. The resulting file is meant to be compatible with 97-2003, but it won't import the data.

When the user opens the file in 2010 and saves as 97-2003, it will import the file.

I have seen this and this, both of which refer to the $_BIFF_version property. However, I cannot find the piece of code indicated in the articles.

What version file is being written with Excel5, BIFF8 or BIFF5?

Coordinator
Sep 29, 2012 at 11:00 PM

The Excel5 Writer generates a BIFF 8 file that should be fully compatible with all versions of Excel from 97 upwards. The piece of code referenced in the article has been superceded by a change to the BIFFWriter.php file that directly sets the BIFF version flag in line 183

$version = 0x0600;   // BIFF8

Simply changing this will not change the file to BIFF 5, but simply flag it ass a BIFF 5 file. The file content itself otherwise identical.