Help for this page

Select Code to Download


  1. or download this
    $Book->ExportAsFixedFormat(
    {
...
        OpenAfterPublish     => $excel->{False},
    }
);
  2. or download this
    ' The next 2 lines will force the PDF to fit the range onto one page
ActiveSheet.PageSetup.FitToPagesWide = 1
ActiveSheet.PageSetup.FitToPagesTall = 1
  3. or download this
    $sheet = $Book -> Worksheets("Sheet1");
$sheet -> Activate;
$sheet->PageSetup->FitToPagesWide = 1;
$sheet->PageSetup->FitToPagesTall = 1;