Pear Spreadsheet_Excel_Writer question

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I am using the Spreadsheet_Excel_Writer module from Pear to generate
Excel spreadsheets from my application.  Currently I am finding that
when I create a new excel spreadsheet I get a message when opening the
file saying:

File error:  Data may have been lost.

Not sure what this is caused by or how to rectify it.  I am trying to
open the excel file with excel 2007.


Re: Pear Spreadsheet_Excel_Writer question

Not sure why, do you need to set the version maybe:


"This method exists just to access experimental functionality from
BIFF8. It will be deprecated ! Only possible value is 8 (Excel
97/2000). For any other value it fails silently."

Quoted text here. Click to load it

Re: Pear Spreadsheet_Excel_Writer question

Mike Miller wrote:

Quoted text here. Click to load it

This isn't necessarily anything to do with PEAR. Search the MS website for
this error message. You'll find that it is produced in response to a
million different vague and untraceable conditions. :-(

Generally a good solution is to open the file in Calc,
copy and paste the data into a brand new spreadsheet and then use the new
spreadsheet instead.

Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.12-12mdksmp, up 53 days, 11:19.]

PHP Debugging with Style -OR- How I Learned to Stop Worrying and Love the Bug

Site Timeline