in reply to Set the sheet #2 for View Zoom to 75%
I have reposted this using tags
use Win32::OLE; use Win32::OLE::Const 'Microsoft Excel'; $file = "t.xls"; my $Excel = Win32::OLE->new('Excel.Application', 'Quit'); my $Book = $Excel->Workbooks->Open($file); my $Sheet1 = $Book->Worksheets(1); $Book->Windows(1)->{Zoom} = 75; $Sheet1->Columns->Font->{Size} = 12; my $Sheet2 = $Book->Worksheets(2); $Sheet2->Columns->{NumberFormat} = "#,##0.00"; $Book = $Excel->Workbooks->Close();
My question is: After running the above perl program, sometimes View Zoom is changed to 75% in sheet #1 or sometimes View Zoom is changed to 75% in sheet #2. I'd like to know what I should write in order to the View Zoom in the sheet #2. Thanks.
2007-01-31 Considered by blue_cowdawg: delete: essentially a duplicate of OP with code tags added.
2007-02-02 Unconsidered by Arunbear: enough keep votes (Keep: 8, Edit: 0, Reap: 13)
|
|---|