Excel automation

maikelj

Hi there,

Does anybody know how I can turn the page orientation around in Excel?
From landscape to portrait and vice versa.

MaikelJ

maikelj

I've already found the solution:

xlSheet.PageSetup.Orientation := 2; //Landscape

Luc_VanDyck

You can use this code:

fctOrientationLandscape(pblnLandscape : Boolean)
//fctOrientationLandscape
// PARAMETERS:
//   pblnLandscape
//   RETURN-VALUE: none
// EXAMPLE: fctOrientationLandscape(TRUE);

IF pblnLandscape THEN
  autExcelWorksheet.PageSetup.Orientation(2)
ELSE
  autExcelWorksheet.PageSetup.Orientation(1);

where autExcelWorksheet is an Automation variable with Subtype: 'Microsoft Excel 9.0 Object Library'.Worksheet

maikelj

Thanks for the code Luc, but I already solved the problem.

MaikelJ