perl-unicode

Re: Unicode to UTF-8

2002-09-08 05:30:04

On Sat, 7 Sep 2002 21:05:13 -0400
Rick Dillon <dev(_at_)rickdillon(_dot_)com> wrote:

Hello.

I am currently populating html pages with content from MS Excel. I am 
using a Java program that literally places the Excel content directly 
into the output code (which is saved as html). It appears that Excel 
is using Unicode characters, which is causing strange glyphs when the 
html is viewed in a browser. Is there a Perl Way to parse the output 
and replace the Unicode characters with asciii, or UTF-8 equivalents? 
And do I need to upgrade to perl 5.6 to do this?

Thanks,

Rick Dillon

I think Spreadsheet/ParseExcel.pm and Spreadsheet/WriteExcel.pm
should provide a good solution.

http://search.cpan.org/author/KWITKNR/Spreadsheet-ParseExcel-0.2602/
http://search.cpan.org/author/JMCNAMARA/Spreadsheet-WriteExcel-0.38/

To transcode Unicode, Unicode/String.pm is good.

http://search.cpan.org/author/GAAS/Unicode-String-2.06/

If you need not to use regular expression operators,
like m// and s///, for Unicode,
Perl 5.005 or 5.6.1 may be still used with the modules
mentioned above.
Otherwise Perl 5.8.0 should be strongly recommended.

SADAHIRO Tomoyuki

<Prev in Thread] Current Thread [Next in Thread>