I know you are dealing with .csv and .xls but I hope my suggestion can offer some light. Excel files are not easy to handle with the Spreadsheet::WriteExcel because they're tab-delimited, a representation of the tab can trickle in the output, this might be why the excel file is giving you troubles, I'd rather convert the file to .csv or convert both files to .txt so handling them becomes easier and such unexpected behaviors kept in check. Make sure you save a copy of the original file.#this is Japanese... my $file = 'unicode_8859_11.txt'; open FH, '<:encoding(iso-2022-jp)', $file or die "$!\n";
In addition check this, they got some links to SpreadSheet examples for dealing with foreign languages in Unicode to the left of the page, it might be of use. I wish you luck...
Another point, using the OLE module is recommended over Spreadsheet::WriteExcel for more reliability working with Excel on Windows. Update after reply from jmcnamara
Update:Added a brief idea about Excel tab-delimiters and also about the OLE module
In reply to Re: WriteExcel unicode question
by biohisham
in thread WriteExcel unicode question
by demis
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |