On Sun, May 4, 2008 at 6:01 PM, Armin Burger <[EMAIL PROTECTED]> wrote:
> Thanks for the hint. I haven't discovered the settings for encoding and was
> thinking the Excel 5 format does not support it. I will modify the code in
> the next days.
>
> armin
>
You might not have been wrong...
You have to set $this->workbook->setVersion(8);
(whatever version this is :-); immediately after creating the workbook
and then
$worksheet->setInputEncoding('utf-8'); after each created worksheet
Of course, it works for other encodings too.
And, as I found after posting to pmapper-users, there is a years old
bug in Excel_Writer, which crashes such utf8 Excel file if it has more
than 150-200 rows inserted....:(
Which you can remedy by overwriting the Workbook.php in Excel_Writer
(also in 0.91) with the one provided here:
http://bugs.gentoo.org/attachment.cgi?id=136412
And then it works without flaws, at least for me...
HTH
BR
frequens
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users