Does your text get truncated or turned into hash '#' signs? I know that Excel has some limits regarding how many characters will go into a text column.
There is also a 64k row limit as well, but most sane people wouldn't use a spreadsheet to handle such a dataset. George > -----Original Message----- > From: Kristen G. Thorson [mailto:[EMAIL PROTECTED] > Sent: 10 February 2006 2:41 pm > To: Bagus Nugroho; php-general > Subject: RE: [PHP] Limitation on PEAR : Spreadsheet_Excel_Writer > > > -----Original Message----- > From: Bagus Nugroho [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 09, 2006 5:48 PM > To: php-general > Subject: [PHP] Limitation on PEAR : Spreadsheet_Excel_Writer > > Hello Everyone, > > I'm succesfully generate report from mysql table using PEAR : > Spreadsheet_Excel_Writer, but I have problem to generate from table > which contain long text, the text is not download completely. > such as .... blablabla. > it only contain .... blab > > How can manipulate PEAR, to get full text on excel sheet. > > Thanks in advance > Bgs > > > > > MySQL fields can contain 65535 characters. Excel fields can only hold > 32767 characters. If you have any text fields longer than 32767 > characters, then they will be truncated by Excel. > > > kgt > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
