Re: iconv is messing up a spreadsheet generated by the Spreadsheet Excel Writer

On Tue, 2009-01-13 at 16:07 +0200, Thodoris wrote: > > 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 > > Unfortunately I don't know of any other Excel writers, but I never really use that format anymore if I can help it. Would a CSV not work? Ash www.ashleysheridan.co.uk