RE: [PHP] Limitation on PEAR : Spreadsheet_Excel_Writer
| From: | George Pitcher | Date: | Fri, 10 Feb 2006 15:17:27 +0000 |
| Subject: | RE: [PHP] Limitation on PEAR : Spreadsheet_Excel_Writer | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-230209@lists.php.net to get a copy of this message | ||
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:kthorson@allegroconsultants.com]
> 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:bnugroho@aitemail.com]
> 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
>
>