On Tue, 2009-01-13 at 15:51 +0200, Thodoris wrote:
Hi gang,
I am generating a spreadsheet using the contents of a mysql table. I
guess that there is something in the data that causes iconv used in the
module's script to generate this error:
*Notice*: iconv() [function.iconv
<file:///C:/Documents%20and%20Settings/tgol/Local%20Settings/Temp/function.iconv>]:
Detected an incomplete multibyte character in input string in
*/usr/local/share/pear/Spreadsheet/Excel/Writer/Worksheet.php* on line
*1547*
This causes the production of weird characters in a cell in the
spreadsheet and after that cell everything is printed out of order.
The data in the mysql table are filtered for non-printable character
before the data import.
I have tried to filter the data before writing them into the sheet but
this behavior persists.
Any ideas in what might be wrong?
Well a multibyte character is something like a character from utf-8 or
unicode, where more than one byte is used to represent the character.
Does the Excel writer you use support utf or unicode?
Ash
www.ashleysheridan.co.uk
Actually it does and AFAIK it changes everything into UTF-16LE. The
Excel writer is the pecl module Spreadsheet_Excel_Writer.
BTW do you have any suggestions for a better open source writer I could use?
--
Thodoris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
