Re^2: Setting Excel cell formats

Many thanks to all.
The codes line were just what I wanted.
I do have another setting question that I posted yesterday.
As I have not had any replies I have taken the liberty of repeating it below.

I want to change the values for an Excel spreadsheet that are set
manually with File->page set up. Below is part of the code I am using.
All works fine except the $sheet->set_margins_LR which has not effect at all

    $workbook = $excel->Workbooks->Add;

       $sheet = $workbook->Worksheets("Sheet1");
    $sheet->Activate();       
    $sheet->{Name} = "Tool List";

    $sheet_margin = 2;
    $sheet->set_margins_LR($sheet_margin);
[download]

What should I be doing?

Comment on Re^2: Setting Excel cell formats Download Code

Replies are listed 'Best First'.
Re^3: Setting Excel cell formats by Samy_rio (Vicar) on Jul 27, 2007 at 04:08 UTC
Hi merrymonk, set the left and right margin value like below `$sheet1->PageSetup->{LeftMargin} = $Excel->InchesToPoints("0.19"); $sheet1->PageSetup->{RightMargin} = $Excel->InchesToPoints("0.54");` [download] In the same way, you can set the value of the remaining margin. `TopMargin BottomMargin HeaderMargin FooterMargin` [download] Regards, Velusamy R. eval"print uc\"\\c$_\""for split'','j)@,/6%@0%2,`e@3!-9v2)/@\|6%,53!-9@2~j';	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^3: Setting Excel cell formats
by Samy_rio (Vicar) on Jul 27, 2007 at 04:08 UTC

Hi merrymonk, set the left and right margin value like below

$sheet1->PageSetup->{LeftMargin}  = $Excel->InchesToPoints("0.19");
$sheet1->PageSetup->{RightMargin} = $Excel->InchesToPoints("0.54");
[download]

In the same way, you can set the value of the remaining margin.

        TopMargin 
        BottomMargin
        HeaderMargin
        FooterMargin
[download]

Regards,
Velusamy R.

eval"print uc\"\\c$_\""for split'','j)@,/6%@0%2,`e@3!-9v2)/@|6%,53!-9@2~j';

[reply]
[d/l]
[select]