in reply to trailing zeroes with EXCEL::Writer::XLSX

In cases like this you should ask yourself, "How would I do this if I were working in Excel/OpenOffice/etc.?" You'd use the spreadsheet software's cell formatting, right? Time to hit your module's docs and see how it lets you assign a cell format.

P.S.: If you aren't sure how to write a format, start your spreadsheet program and experiment. That way you'll know for certain when your format string is right.

  • Comment on Re: trailing zeroes with EXCEL::Writer::XLSX

Replies are listed 'Best First'.
Re^2: trailing zeroes with EXCEL::Writer::XLSX
by fionbarr (Friar) on Aug 08, 2014 at 14:39 UTC
    the answer is: 
    $right = $workbook->add_format(
        size  => 9,
        align => 'right',
        num_format => '#,##0.00',
    );

    [download]
[reply]
[d/l]

      There ya go! *thumbs up*

[reply]

In Section Seekers of Perl Wisdom