in reply to Horizontal Alignment

I know you already rejected Spreadsheet::WriteExcel, but it should be noted, that module makes this easier: 
my $format = $workbook->add_format();
$format->set_align('center');
$format->set_align('vcenter');

[download]
Also, please consider using code tags in your posts.

Replies are listed 'Best First'.
Re^2: Horizontal Alignment
by jinhuang1992 (Novice) on Jan 26, 2007 at 20:30 UTC
    ikegami gave me the answer that I want. use Win32::OLE::Const 'Microsoft Excel';
    ...,/br> $sheet->Range($range)->{HorizontalAlignment} = xlHAlignCenter;
    Thank you very much for your help.
[reply]

In Section Seekers of Perl Wisdom