Spread Windows Forms 15.0
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelBiffRead 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
whether the comments are printed at the end of the sheet.
Print resolution
Vertical print resolution
Number header
Number footer
Copies
UseSmartPrint


In This Topic
    ExcelSetPageSetup Method (IExcelBiffRead)
    In This Topic
    ExcelSetPageSetup - Excel Biff Record
    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 Boolean, _
       ByVal noOrient As Boolean, _
       ByVal usePage As Boolean, _
       ByVal endNotes 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 IExcelBiffRead
    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 Boolean
    Dim noOrient As Boolean
    Dim usePage As Boolean
    Dim endNotes 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, endNotes, 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
    endNotes
    whether the comments are printed at the end of the sheet.
    printRes
    Print resolution
    vertPrintRes
    Vertical print resolution
    numHdr
    Number header
    numFtr
    Number footer
    copies
    Copies
    useSmartPrint
    UseSmartPrint
    See Also