in reply to Re^2: Setting Excel cell formats
in thread Setting Excel cell formats

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';

In Section Seekers of Perl Wisdom