What if you try to read both the files in some variable, while you're opening the files you specify the Greek encoding for them in the open argument?
Something like;
#this is Japanese... my $file = 'unicode_8859_11.txt'; open FH, '<:encoding(iso-2022-jp)', $file or die "$!\n";
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.

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


Excellence is an Endeavor of Persistence. Chance Favors a Prepared Mind.

In reply to Re: WriteExcel unicode question by biohisham
in thread WriteExcel unicode question by demis

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.