Limitation on PEAR : Spreadsheet_Excel_Writer

------_=_NextPart_001_01C62DCA.D9FBCB37
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello Everyone,
=20
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
=20
How can manipulate PEAR, to get full text on excel sheet.
=20
Thanks in advance
Bgs

------_=_NextPart_001_01C62DCA.D9FBCB37--

RE: Limitation on PEAR : Spreadsheet_Excel_Writer

-----Original Message-----
From: Bagus Nugroho [mailto:bnugroho@aitemail.com]=20
Sent: Thursday, February 09, 2006 5:48 PM
To: php-general
Subject: [PHP] Limitation on PEAR : Spreadsheet_Excel_Writer

Hello Everyone,
=20
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
=20
How can manipulate PEAR, to get full text on excel sheet.
=20
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

RE: Limitation on PEAR : Spreadsheet_Excel_Writer

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
>
>

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Limitation on PEAR : Spreadsheet_Excel_Writer

--=-sjN+wSZwaBCJmI6NPUGN
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Fri, 2006-02-10 at 05:47 +0700, Bagus Nugroho wrote:
> Hello Everyone,
> =20
> 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
> =20
> How can manipulate PEAR, to get full text on excel sheet.
> =20

Next time direct your question to the PEAR General List
(pear-general@lists.php.net) to get a much more useful answer.

This is due to the default mode of Spreadsheet_Excel_Writer creating an
Excel 7 (or maybe 6) compatible spreadsheet which has these string
limitations. If you change the version of spreadsheet it is creating you
will not have these problems.

I don't know the exact commands or versions to set it to but check the
documentation or search the archives of pear-general. I know for sure it
is in the pear-general archives as this question has been asked and
answered many times.

Adam Ashley

--=-sjN+wSZwaBCJmI6NPUGN
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQBD78w1iQOxIxaQ8/ARAjQVAJ9j7vu0qasQdUeuJLopjeJwZ7u7QACf b4Hw
jvKmC8kr3gNuiroU3FwalzE=
=7PEx
-----END PGP SIGNATURE-----

--=-sjN+wSZwaBCJmI6NPUGN--