ExcelGetPageSetup Method (IExcelBiffWrite)

In This Topic

Gets the page setup for printing for exporting to Excel BIFF file.

Syntax

Visual Basic
C#

'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 Boolean, _
   ByRef noOrient As Boolean, _
   ByRef usePage As Boolean, _
   ByRef endNotes 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 IExcelBiffWrite
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 fitToPage As Boolean
Dim value As Boolean
 
value = instance.ExcelGetPageSetup(sheet, paperSize, scale, pageStart, fitWidth, fitHeight, leftToRight, isPortrait, noPls, noColor, draft, notes, noOrient, usePage, endNotes, printRes, vertPrintRes, numHdr, numFtr, copies, fitToPage)

bool ExcelGetPageSetup( 
   short sheet,
   ref short paperSize,
   ref short scale,
   ref short pageStart,
   ref short fitWidth,
   ref short fitHeight,
   ref bool leftToRight,
   ref bool isPortrait,
   ref bool noPls,
   ref bool noColor,
   ref bool draft,
   ref bool notes,
   ref bool noOrient,
   ref bool usePage,
   ref bool endNotes,
   ref short printRes,
   ref short vertPrintRes,
   ref double numHdr,
   ref double numFtr,
   ref short copies,
   ref bool fitToPage
)

Parameters

sheet: Sheet index
paperSize
scale
pageStart
fitWidth
fitHeight
leftToRight
isPortrait
noPls
noColor
draft
notes
noOrient
usePage
endNotes: whether the comments are printed at the end of the sheet.
printRes
vertPrintRes
numHdr
numFtr
copies
fitToPage

Reference

IExcelBiffWrite Interface
IExcelBiffWrite Members

Product Support Forum | Print this page