Spread WinForms 15
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelXml Interface / ExcelSetPageSetup Method
Sheet index
Paper size
Scaling factor
Starting page
Width
Height
Whether left-to-right
Whether portrait page orientation
Whether no pls
Whether no color
Whether draft
Whether to print notes
Whether no orientation
Whether use page
Print resolution
Vertical print resolution
Number header
Number footer
Copies


In This Topic
ExcelSetPageSetup Method (IExcelXml)
In This Topic
Sets the Excel XML Page setup.
Syntax
'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)

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
See Also