ExcelSetPageSetup Method (IExcelXml)

In This Topic

Sets the Excel XML Page setup.

Syntax

Visual Basic
C#

'Declaration
 
Function ExcelSetPageSetup( _
   ByVal sheet As Short, _
   ByVal paperSize As Short, _
   ByVal scale As Short, _
   ByVal pageStart As Short, _
   ByVal fitWidth As Short, _
   ByVal fitHeight As Short, _
   ByVal leftToRight As Boolean, _
   ByVal isPortrait As Boolean, _
   ByVal noPls As Boolean, _
   ByVal noColor As Boolean, _
   ByVal draft As Boolean, _
   ByVal notes As Byte, _
   ByVal noOrient As Boolean, _
   ByVal usePage As Boolean, _
   ByVal printRes As Short, _
   ByVal vertPrintRes As Short, _
   ByVal numHdr As Double, _
   ByVal numFtr As Double, _
   ByVal copies As Short, _
   ByVal useSmartPrint As Boolean _
) As Boolean

'Usage
 
Dim instance As IExcelXml
Dim sheet As Short
Dim paperSize As Short
Dim scale As Short
Dim pageStart As Short
Dim fitWidth As Short
Dim fitHeight As Short
Dim leftToRight As Boolean
Dim isPortrait As Boolean
Dim noPls As Boolean
Dim noColor As Boolean
Dim draft As Boolean
Dim notes As Byte
Dim noOrient As Boolean
Dim usePage As Boolean
Dim printRes As Short
Dim vertPrintRes As Short
Dim numHdr As Double
Dim numFtr As Double
Dim copies As Short
Dim useSmartPrint As Boolean
Dim value As Boolean
 
value = instance.ExcelSetPageSetup(sheet, paperSize, scale, pageStart, fitWidth, fitHeight, leftToRight, isPortrait, noPls, noColor, draft, notes, noOrient, usePage, printRes, vertPrintRes, numHdr, numFtr, copies, useSmartPrint)

bool ExcelSetPageSetup( 
   short sheet,
   short paperSize,
   short scale,
   short pageStart,
   short fitWidth,
   short fitHeight,
   bool leftToRight,
   bool isPortrait,
   bool noPls,
   bool noColor,
   bool draft,
   byte notes,
   bool noOrient,
   bool usePage,
   short printRes,
   short vertPrintRes,
   double numHdr,
   double numFtr,
   short copies,
   bool useSmartPrint
)

Parameters

sheet: Sheet index
paperSize: Paper size
scale: Scaling factor
pageStart: Starting page
fitWidth: Width
fitHeight: Height
leftToRight: Whether left-to-right
isPortrait: Whether portrait page orientation
noPls: Whether no pls
noColor: Whether no color
draft: Whether draft
notes: Whether to print notes
noOrient: Whether no orientation
usePage: Whether use page
printRes: Print resolution
vertPrintRes: Vertical print resolution
numHdr: Number header
numFtr: Number footer
copies: Copies
useSmartPrint

Reference

IExcelXml Interface
IExcelXml Members

Product Support Forum | Print this page