Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: trailing zeroes with EXCEL::Writer::XLSX

by Bethany (Scribe)
on Aug 08, 2014 at 14:17 UTC ( [id://1096764]=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://1096764]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others goofing around in the Monastery: (5)
As of 2024-04-24 05:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found