Hi, I would like to generate an Excel document with my MySQL database. I used to try many solutions like Biffwriter or phpwriteexcel but I want to generate a document with more than 255 chars in a cell.
Is anyone can help me?
Don't store the fields that fill the cells with as VARCHAR or CHAR. Store them as LONGTEXT or LONGBLOB (a maximum 65535 characters).
I use a TEXT field (65535 chars)...
You might have limited the length of the TEXT field to 255 in your table creation syntax.
The problem does not come from the MySQL database but from the PHP script.
Are you certain? Then show us the code and I'll see if I can find the problem.
I have just found this: http://pear.php.net/package/Spreadsheet_Excel_Writer/
When using: $xls->setVersion('8')
The Excel document is now compatible with 97/2000 version and print more than 255 chars in a cell
