I know this group is specifically for WriteExcel (an excellent module!) I have a problem using Spreadsheet Parse Excel to read unicode characters. Hopefully someone can guide me.
The source spreadsheet (xls) has characters like this:
Prešovská 16
Which is a street address
When I read this with the formatter, I get gibberish
I believe I am using the tool correctly:
my $parser = Spreadsheet::ParseExcel->new();
my $formatter = Spreadsheet::ParseExcel::FmtUnicode->new();
my $workbook = $parser->parse($filename,$formatter);
Then, to read the cell:
$val = $cell->value();
$valuf = $cell->unformatted();
The result of $val and $valuf are the same.
Can anyone see what I am missing?
Thanks
hcbsez