Problem with encoding with Spreadsheet::Writer

[sam]

Hi,

I use Spreadsheet::Writer save chinese character fields into spread
sheet. However my client reported these fields are not readable by
Excel. If they copy these characters directly from the web page into
excel spreadsheet, it is readable, but not with those converted by
Spread::Writer.

Is there any workaround for this encoding problem when using
Spreadsheet::Writer?

Thanks
Sam

 

[jmcnamara]

I'm guessing that you are talking about Spreadsheet::WriteExcel.

Spreadsheet::WriteExcel supports wide characters in UTF16 and UTF8
formats. Other encodings are also supported via Perl 5.8's unicode
handling.

Search the documentation for the word unicode for further information.

http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/lib/Spreadsheet/WriteExcel.pm

There is also an example in Big5 Chinese in the Spreadsheet::WriteExcel
distro:

http://search.cpan.org/src/JMCNAMARA/Spreadsheet-WriteExcel-2.11/examples/unicode_big5.pl

http://search.cpan.org/src/JMCNAMARA/Spreadsheet-WriteExcel-2.11/examples/unicode_big5.txt

John.
--