Re: Win32::OLE alignment

Untested:

my $xlRight = -4152;
$worksheet->Cells(1,2)->{HorizontalAlignment} = $xlRight;
[download]

Earth first! (We'll rob the other planets later)

Comment on Re: Win32::OLE alignment Download Code

Replies are listed 'Best First'.
Re^2: Win32::OLE alignment by Grygonos (Chaplain) on Nov 01, 2004 at 21:07 UTC
That is correct. However I would reccomend importing the Excel constants via `#Load a hash reference to Excel's constants in the scalar ref $xlC +onst my $xlConst = Win32::OLE::Const->Load('Microsoft Excel 8.0 Object +Library');` [download] and using `$worksheet->Cells(1,2)->{HorizontalAlignment} = $xlConst->{'xlRight'};` Grygonos	[reply] [d/l] [select]