Re^2: Another Excel/OLE question.

Thanks for the response and input! I had actually tried passing the value as a string and a constant with the same result. I wasn't actually sure it mattered, because no errors are thrown and if I set Merge to "True", it had the same effect as the constant True. To add a bit more detail, I am merging a bunch of cells and trying to add the title of an Excel spread sheet, and center it. Here's the nitty gritty:


#Insert logo and title
$sheet -> Range("1:1")        -> {RowHeight} = 60;
$sheet -> Range("F1:S1")    -> Font -> {Name}    = "Arial Rounded MT B
+old";
$sheet -> Range("F1:S1")    -> Font -> {Size}    = 36;
$sheet -> Range("F1:S1")    -> Font -> {Bold}    = True;
$sheet -> Range("F1:S1")    -> {MergeCells}        = True;    
$sheet -> Range("F1:S1")    -> {HorizontalAlignment}    = xlCenter;
$sheet -> Range("F1:S1")    -> {VerticalAlignment}         = xlCenter;
$sheet -> Range("F1:S1")    -> {Value}        = "Great Job!";
[download]

To get around this rather than use the whole row, I've just offset the title and left it left-justified, and hopefully it won't look too awful in common monitor resolutions.

Comment on Re^2: Another Excel/OLE question. Select or Download Code

Replies are listed 'Best First'.
Re^3: Another Excel/OLE question. by Anonymous Monk on Jun 03, 2011 at 18:06 UTC
I had actually tried passing the value as a string and a constant with the same result. Did you declare/define the constant?	[reply]
Re^4: Another Excel/OLE question. by Morellio (Initiate) on Jun 03, 2011 at 22:18 UTC
I looked into OLE constants and found some disparity that ended up fixing my problem. Some guides online had me using the second example below instead of the first. Googling perl ole excel constants led me to this page which had a better example. Read more... (549 Bytes)	[reply] [d/l] [select]
Re^5: Another Excel/OLE question. by Anonymous Monk on Jun 03, 2011 at 22:51 UTC
Googling perl ole excel constants led me to this page which had a better example You already have that page. http://search.cpan.org/dist/Win32-OLE/lib/Win32/OLE/TPJ.pod	[reply]