RE: Limitation on PEAR : Spreadsheet_Excel_Writer

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxxxxxxx]
> Sent: 10 February 2006 2:41 pm
> To: Bagus Nugroho; php-general
> Subject: RE:  Limitation on PEAR : Spreadsheet_Excel_Writer
>
>
> -----Original Message-----
> From: Bagus Nugroho [mailto:bnugroho@xxxxxxxxxxxx]
> Sent: Thursday, February 09, 2006 5:48 PM
> To: php-general
> Subject:  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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux