PHP Classes

Not a recognisable format

Recommend this page to a friend!

      MS-Excel Stream Handler  >  All threads  >  Not a recognisable format  >  (Un) Subscribe thread alerts  
Subject:Not a recognisable format
Summary:File not readable after fixed amount of information.
Messages:5
Author:rein
Date:2005-01-27 12:17:11
Update:2007-11-06 20:01:27
 

  1. Not a recognisable format   Reply   Report abuse  
Picture of rein rein - 2005-01-27 12:17:15
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?

  2. Re: Not a recognisable format   Reply   Report abuse  
Picture of Ignatius Teo 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.

Thanks.

  3. Re: Not a recognisable format   Reply   Report abuse  
Picture of rein 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)?

Thank you.

  4. Re: Not a recognisable format   Reply   Report abuse  
Picture of le tan phap le tan phap - 2007-07-17 01:05:54 - In reply to message 3 from rein
Please Help me,
I created a file .xls, But i have problem with Unicode (Vietnam). It view is not true (some character 2 byte or greater). It save is not true

Please help. Thanks

  5. Re: Not a recognisable format   Reply   Report abuse  
Picture of hamed bazargani hamed bazargani - 2007-11-06 20:01:27 - In reply to message 4 from le tan phap
yes and my problem
i use it for my xls file but in utf-8 format bud it dont work good
please solv it for unicode
thanx