Spread Windows Forms 17
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