Align numbers & text in a column to the right

jinhuang1992 has asked for the wisdom of the Perl Monks concerning the following question:

I'm very new to PERL with Win32::OLE & Microsoft Excel. Does anyone know how to write a few statements to align numbers & text in a column to the right? Thanks. Before in a column ==>

Amount

23.25

-2.10

none

6666

7525

Output should look like ==>

Amount

23.25

-2.10

none

6666

7525

for the size and bold of numbers and text in column A, I can write my $font = $sheet->{"A:A")->{Font}; $font->{Size} = 14; $font->{Bold} = 1; .... How do I align the numbers and text to the right? Thanks.

Comment on Align numbers & text in a column to the right

Replies are listed 'Best First'.
Re: Align numbers in a column to the right by SheridanCat (Pilgrim) on Jan 26, 2007 at 16:27 UTC
I haven't bothered to fiddle with OLE to do Excel work in the past. I've preferred Spreadsheet::WriteExcel. It has worked pretty well. There's justification functions that should help you out. Edited to fix stupid typos and syntax.	[reply]
Re^2: Align numbers in a column to the right by jinhuang1992 (Novice) on Jan 26, 2007 at 16:42 UTC
It's not what I want from Spreadsheet::WriteExcel. But, thanks, anyway.	[reply]
Re^3: Align numbers in a column to the right by davorg (Chancellor) on Jan 26, 2007 at 16:49 UTC
I what way is it not what you want? Did you read the documentation on formatting cells? I think you want something like this: `my $format = $workbook->add_format(align => 'left'); $worksheet->write_number(0, 0, 23.25, $format);` [download] -- <http://dave.org.uk> "The first rule of Perl club is you do not talk about Perl club." -- Chip Salzenberg	[reply] [d/l]
Re: Align numbers in a column to the right by davorg (Chancellor) on Jan 26, 2007 at 16:24 UTC
It all depends what output format you're using. Assuming we're talking about plain text, take a look at printf. Update: Oops. Of course you're not talking about plain text. You're talking about an Excel spreadsheet. Ignore me and look at Spreadsheet::WriteExcel. Thanks to ikegami for pointing out my insanity. -- <http://dave.org.uk> "The first rule of Perl club is you do not talk about Perl club." -- Chip Salzenberg	[reply]

Back to Seekers of Perl Wisdom