Writing French Accented Characters in Excel using Perl.

[shintu]

Hallo,

I am trying to write french accented characters é è ê in Excel worksheet using my perl script , But I am stuck here as I couldnt find a way of writing it !:

My code:

use strict;
use warnings;
 
use Win32::OLE qw(in with);
use Win32::OLE::Const 'Microsoft Excel';
 
my $Excel = Win32::OLE->GetActiveObject('Excel.Application')
    or Win32::OLE->new('Excel.Application', 'Quit');
my $excel_file = 'd:/excelfile.xls';
 

And it goes on, where I am reading the french text from an xml file and I am writing it into my Excel worksheet using this :

$sheet->Cells($i,8)->{'Value'}="$temp";
 

Where $temp has the french text .. I see that It reads correctly from the xml file.

my $xmlsource3 = "LAX03fr.xml";
open IN3, "<:utf8", $xmlsource3 or die "Can't Read Source file $xmlsource3: $!\n";
 

There was a problem before with reading also but when I added this "<:utf8" tag in there the problem got solved and now it reads the characters correctly..

Also i printed the $temp in the output window and it shows the accented characters correctly , only when it writes to excel i cannot see the accented characters and instead I see ,something like this in my excel ! ---> Unité

How can I solve this problem ?

Please help me guys , any help would be greatly appreciated.

thanks a lot, in advance,
shintu