This program works perfectly for me, only there's a problem.
Everything works fine until I try to export a file with more than 50 rows and 5 colums. Also the bigger the texts in each field, the sooner this happends.
The following error then occurs:
-- excel returns: This file is not in a recognisable format.
-- The file is constructed at 16 bytes
Maybe you can help get this error out?
Btw: I get data from mysql by constructing the needed array in a loop as
$array_xls[$i][mysql_field_name($result, $colum_no)] = $row[$colum_no];
(this works, and I dont suppose the error is because of this.
I want to note that OpenOffice doesn't open the files correctly, it just shows some squares and a few words in one cell.
Is this a common problem?
Ignatius Teo - 2005-01-28 00:52:23 - In reply to message 1 from rein
Please make sure you are using the latest version of the xlsStream package.
Please advise what version of the xlsStream package you are using, what platform you're running on and version of Apache/PHP.
rein - 2005-01-28 10:10:57 - In reply to message 2 from Ignatius Teo
Yeah thats right, I didn't have the newest version, although mine was only like a month old at most. You've developed quick;)
Although my main problem is solved, I still like to say that OpenOffice doesn't open the files generated, while it opens files generated by MS Excel normally.
Do you know how to make it work with OpenOffice (v1.1.3)?