Spread WinForms 15
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelXml Interface / ExcelGetPageSetup 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
ExcelGetPageSetup Method (IExcelXml)
In This Topic
Gets the Excel XML page setup.
Syntax
'Declaration
 
Function ExcelGetPageSetup( _
   ByVal sheet As Short, _
   ByRef paperSize As Short, _
   ByRef scale As Short, _
   ByRef pageStart As Short, _
   ByRef fitWidth As Short, _
   ByRef fitHeight As Short, _
   ByRef leftToRight As Boolean, _
   ByRef isPortrait As Boolean, _
   ByRef noPls As Boolean, _
   ByRef noColor As Boolean, _
   ByRef draft As Boolean, _
   ByRef notes As Byte, _
   ByRef noOrient As Boolean, _
   ByRef usePage As Boolean, _
   ByRef printRes As Short, _
   ByRef vertPrintRes As Short, _
   ByRef numHdr As Double, _
   ByRef numFtr As Double, _
   ByRef copies As Short, _
   ByRef fitToPage 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 fitToPage As Boolean
Dim value As Boolean
 
value = instance.ExcelGetPageSetup(sheet, paperSize, scale, pageStart, fitWidth, fitHeight, leftToRight, isPortrait, noPls, noColor, draft, notes, noOrient, usePage, printRes, vertPrintRes, numHdr, numFtr, copies, fitToPage)

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