in reply to Spreadsheet::WriteExcel foreign currency

Hello, I haven't had to use a foreign currency yet, however, I'll give it a try.

Within the Spreadsheet-WriteExcel-2.17/examples directory of the module, there is an example program --> formats.pl

It'll show you Excel's built-in formats. Opening the excel file generated from formats.pl shows the Euro symbol for me.

From the generated table..
Index Index Unformatted Formatted Negative Format
5 0x05 1234,567 1.235 € -1.235 € ($#,##0_);($#,##0)


This leads me to believe that the currency symbol is simply set by the locale settings of the Excel program being used to open the file.

Hope it helps...

regexes


-------------------------
Nothing in the world can take the place of persistence. Talent will not; nothing is more common than unsuccessful men with talent. Genius will not; unrewarded genius is almost a proverb. Education will not; the world is full of educated derelicts. Persistence and determination are omnipotent. The slogan "press on" has solved and always will solve the problems of the human race.
-- Calvin Coolidge, 30th President of the USA.
  • Comment on Re: Spreadsheet::WriteExcel foreign currency

Replies are listed 'Best First'.
Re^2: Spreadsheet::WriteExcel foreign currency
by regexes (Hermit) on Jun 19, 2007 at 11:35 UTC
    Thanks jmcnamara, I overlooked it in the documentation.
    In Spreadsheet::WriteExcel, search for the set_num_format under the CELL FORMATTING section. You find this... 
    $format04->set_num_format('$0.00');
$worksheet->write(3,  0, 49.99,     $format04);    # $49.99

$format05->set_num_format('£0.00');
$worksheet->write(4,  0, 49.99,     $format05);    # £49.99

$format06->set_num_format('¥0.00');
$worksheet->write(5,  0, 49.99,     $format06);    # ¥49.99

    [download]

    regexes
[reply]
[d/l]

In Section Seekers of Perl Wisdom