Re: [PHP] Limitation on PEAR : Spreadsheet_Excel_Writer
On Fri, 2006-02-10 at 05:47 +0700, Bagus Nugroho wrote: 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. Next time direct your question to the PEAR General List ([EMAIL PROTECTED]) 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 signature.asc Description: This is a digitally signed message part
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
RE: [PHP] 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:[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