Description: ------------ When creating a spreadsheet with 0.9.3 I get the following errors: fseek() expects parameter 1 to be resource, string given in /usr/local/lib/php/Spreadsheet/Excel/Writer/Worksheet.php on line 688 fread() expects parameter 1 to be resource, string given in /usr/local/lib/php/Spreadsheet/Excel/Writer/Worksheet.php on line 694 Reverting to 0.9.2 fixes the problem.

Sorry, I should have searched better. Looks like it is the issue with 0.9.3 and OLE-1.0.0RC2: http://pear.php.net/bugs/bug.php?id=19284 So either downgrade to 0.9.2 or OLE-1.0.0RC1

Actually it turns out the Mac/Excel 2011 can read them from 0.9.2 and OLE-1.0.0RC2, but for larger(?) spreadsheets, Windows/Excel 2010 needs 0.9.2 and OLE-1.0.0RC1

The problem seems to be code in Worksheet.php line 649-657 closing the file. But the file is accessed later again in line 688. So you need the move the closing code to the end of the getData() method: function close($sheetnames) { ...... /* WN: HOTFIX: CODE DISABLED - FILE IS ACCESSED AGAIN AFTER IT IS WRITTEN if ( $this->_tmp_file != '' ) { if ( $this->_filehandle ) { fclose($this->_filehandle); $this->_filehandle = ''; } @unlink($this->_tmp_file); $this->_tmp_file = ''; $this->_using_tmpfile = true; } */ ..... function getData() { ....... // WN: HOTFIX: MOVED CODE FROM LINE 653 here if ( $this->_tmp_file != '' ) { if ( $this->_filehandle ) { fclose($this->_filehandle); $this->_filehandle = ''; } @unlink($this->_tmp_file); $this->_tmp_file = ''; $this->_using_tmpfile = true; } // No data to return return ''; } With the OLE RC2 Workaround from identit (http://pear.php.net/bugs/bug.php?id=19284#1344445946) applied it seems to be possible to use Spreadsheet_Excel_Writer 0.9.3 together with 1.0.0RC2 successfully

I have a problem with Excel 2013 , in fact all the cells are not well formatted . the chart is stopped in a certain number of cells. Could someone help me please ?

Thank you for taking the time to report a problem with the package. Unfortunately you are not using a current version of the package -- the problem might already be fixed. Please download a new version from http://pear.php.net/packages.php If you are able to reproduce the bug with one of the latest versions, please change the package version on this bug report to the version you tested and change the status back to "Open". Again, thank you for your continued support of PEAR.

Download the latest from here: https://github.com/pear/Spreadsheet_Excel_Writer