#!/usr/bin/perl -w
##############################################################################
#
# A simple example of writing some Unicode text with Spreadsheet::WriteExcel.
#
# This example shows UTF16 encoding. With perl 5.8 it is also possible to use
# utf8 without modification.
#
# reverse('©'), May 2004, John McNamara, jmcnamara@cpan.org
#
use
strict;
my
$workbook
= Spreadsheet::WriteExcel->new(
'unicode_utf16.xls'
);
my
$worksheet
=
$workbook
->add_worksheet();
# Write the Unicode smiley face (with increased font for legibility)
my
$smiley
=
pack
"n"
, 0x263a;
my
$big_font
=
$workbook
->add_format(
size
=> 40);
$worksheet
->write_utf16be_string(
'A3'
,
$smiley
,
$big_font
);
# Write a phrase in Cyrillic
my
$uni_str
=
pack
"H*"
,
"042d0442043e002004440440043004370430002004"
.
"3d043000200440044304410441043a043e043c0021"
;
$worksheet
->write_utf16be_string(
'A5'
,
$uni_str
);
$worksheet
->write_utf16be_string(
'A7'
,
pack
"H*"
,
"0074006500730074"
);
__END__