'Declaration
 
Public Function New( _
   ByVal header As String, _
   ByVal footer As String, _
   ByVal jobName As String, _
   ByVal margin As PrintMargin, _
   ByVal orientation As PrintOrientation, _
   ByVal pageOrder As PrintPageOrder, _
   ByVal border As Boolean, _
   ByVal colHeaders As PrintHeader, _
   ByVal colFooters As PrintHeader, _
   ByVal showColFooterEachPage As Boolean, _
   ByVal showTitle As Boolean, _
   ByVal showSubtitle As Boolean, _
   ByVal color As Boolean, _
   ByVal grid As Boolean, _
   ByVal rowHeaders As PrintHeader, _
   ByVal showShadows As Boolean, _
   ByVal useMax As Boolean, _
   ByVal type As PrintType, _
   ByVal colStart As Integer, _
   ByVal colEnd As Integer, _
   ByVal rowStart As Integer, _
   ByVal rowEnd As Integer, _
   ByVal pageStart As Integer, _
   ByVal pageEnd As Integer, _
   ByVal useSmartPrint As Boolean, _
   ByVal rules As SmartPrintRulesCollection, _
   ByVal bestFitCols As Boolean, _
   ByVal bestFitRows As Boolean, _
   ByVal preview As Boolean, _
   ByVal printer As String, _
   ByVal firstPageNum As Integer, _
   ByVal showDialog As Boolean, _
   ByVal abortMessage As String, _
   ByVal zoomFactor As Single, _
   ByVal opacity As Integer, _
   ByVal notes As PrintNotes, _
   ByVal paperSrc As PaperSource, _
   ByVal paperSz As PaperSize, _
   ByVal objects As Boolean, _
   ByVal imgList() As Image, _
   ByVal colorList() As Color, _
   ByVal repeatColStart As Integer, _
   ByVal repeatColEnd As Integer, _
   ByVal repeatRowStart As Integer, _
   ByVal repeatRowEnd As Integer, _
   ByVal center As Centering, _
   ByVal pagesTall As Integer, _
   ByVal pagesWide As Integer, _
   ByVal headerHeight As Integer, _
   ByVal footerHeight As Integer, _
   ByVal printToPdf As Boolean, _
   ByVal pdfFileName As String, _
   ByVal pdfStream As Stream, _
   ByVal pdfWriteMode As PdfWriteMode, _
   ByVal pdfWriteTo As PdfWriteTo _
)

'Usage
 
Dim header As String
Dim footer As String
Dim jobName As String
Dim margin As PrintMargin
Dim orientation As PrintOrientation
Dim pageOrder As PrintPageOrder
Dim border As Boolean
Dim colHeaders As PrintHeader
Dim colFooters As PrintHeader
Dim showColFooterEachPage As Boolean
Dim showTitle As Boolean
Dim showSubtitle As Boolean
Dim color As Boolean
Dim grid As Boolean
Dim rowHeaders As PrintHeader
Dim showShadows As Boolean
Dim useMax As Boolean
Dim type As PrintType
Dim colStart As Integer
Dim colEnd As Integer
Dim rowStart As Integer
Dim rowEnd As Integer
Dim pageStart As Integer
Dim pageEnd As Integer
Dim useSmartPrint As Boolean
Dim rules As SmartPrintRulesCollection
Dim bestFitCols As Boolean
Dim bestFitRows As Boolean
Dim preview As Boolean
Dim printer As String
Dim firstPageNum As Integer
Dim showDialog As Boolean
Dim abortMessage As String
Dim zoomFactor As Single
Dim opacity As Integer
Dim notes As PrintNotes
Dim paperSrc As PaperSource
Dim paperSz As PaperSize
Dim objects As Boolean
Dim imgList() As Image
Dim colorList() As Color
Dim repeatColStart As Integer
Dim repeatColEnd As Integer
Dim repeatRowStart As Integer
Dim repeatRowEnd As Integer
Dim center As Centering
Dim pagesTall As Integer
Dim pagesWide As Integer
Dim headerHeight As Integer
Dim footerHeight As Integer
Dim printToPdf As Boolean
Dim pdfFileName As String
Dim pdfStream As Stream
Dim pdfWriteMode As PdfWriteMode
Dim pdfWriteTo As PdfWriteTo
 
Dim instance As New PrintInfo(header, footer, jobName, margin, orientation, pageOrder, border, colHeaders, colFooters, showColFooterEachPage, showTitle, showSubtitle, color, grid, rowHeaders, showShadows, useMax, type, colStart, colEnd, rowStart, rowEnd, pageStart, pageEnd, useSmartPrint, rules, bestFitCols, bestFitRows, preview, printer, firstPageNum, showDialog, abortMessage, zoomFactor, opacity, notes, paperSrc, paperSz, objects, imgList, colorList, repeatColStart, repeatColEnd, repeatRowStart, repeatRowEnd, center, pagesTall, pagesWide, headerHeight, footerHeight, printToPdf, pdfFileName, pdfStream, pdfWriteMode, pdfWriteTo)

public PrintInfo( 
   string header,
   string footer,
   string jobName,
   PrintMargin margin,
   PrintOrientation orientation,
   PrintPageOrder pageOrder,
   bool border,
   PrintHeader colHeaders,
   PrintHeader colFooters,
   bool showColFooterEachPage,
   bool showTitle,
   bool showSubtitle,
   bool color,
   bool grid,
   PrintHeader rowHeaders,
   bool showShadows,
   bool useMax,
   PrintType type,
   int colStart,
   int colEnd,
   int rowStart,
   int rowEnd,
   int pageStart,
   int pageEnd,
   bool useSmartPrint,
   SmartPrintRulesCollection rules,
   bool bestFitCols,
   bool bestFitRows,
   bool preview,
   string printer,
   int firstPageNum,
   bool showDialog,
   string abortMessage,
   float zoomFactor,
   int opacity,
   PrintNotes notes,
   PaperSource paperSrc,
   PaperSize paperSz,
   bool objects,
   Image[] imgList,
   Color[] colorList,
   int repeatColStart,
   int repeatColEnd,
   int repeatRowStart,
   int repeatRowEnd,
   Centering center,
   int pagesTall,
   int pagesWide,
   int headerHeight,
   int footerHeight,
   bool printToPdf,
   string pdfFileName,
   Stream pdfStream,
   PdfWriteMode pdfWriteMode,
   PdfWriteTo pdfWriteTo
)

Parameters

header

Header text

footer

Footer text

jobName

Print job name

margin

Print margins

orientation

Page orientation

pageOrder

Print page order

border

Whether to print the sheet border

colHeaders

Whether to print column headers

colFooters

Whether to print column footers

showColFooterEachPage

Whether to print column footers in each page

showTitle

Whether to print the title

showSubtitle

Whether to print the subtitle

color

Whether to print in color

grid

Whether to print grid lines

rowHeaders

Whether to print row headers

showShadows

Whether to print the header shadows

useMax

Whether to print cells that do not have data

type

What to print

colStart

First column of cell range to print

colEnd

Last column of cell range to print

rowStart

First row of cell range to print

rowEnd

Last row of cell range to print

pageStart

First page of page range to print

pageEnd

Last page of page range to print

useSmartPrint

Whether to use SmartPrint

rules

SmartPrint rules

bestFitCols

Whether to adjust column widths for printing

bestFitRows

Whether to adjust row heights for printing

preview

Whether to preview the sheet rather than print it

printer

Printer to which to print

firstPageNum

Page number to print on first page

showDialog

Whether to show the print dialog

abortMessage

Message to display for canceling printing

zoomFactor

Factor to zoom sheet for printing

opacity

Alpha value used for sheet

notes

Whether cell notes are printed

paperSrc

Source location of paper

paperSz

Paper size

objects

Whether objects are printed

imgList

Images to use for headers and footers

colorList

Colors to use for headers and footers

repeatColStart

Index of beginning column of a repeating range

repeatColEnd

Index of ending column of a repeating range

repeatRowStart

Index of a beginning row of a repeating range

repeatRowEnd

Index of ending row of a repeating range

center

Type of centering to perform on print out

pagesTall

Number of pages tall to fit print out into when smart print is true

pagesWide

Number of pages wide to fit print out into when smart print is true

headerHeight

Sets the user defined height of the header area

footerHeight

Sets the user defined height of the footer area

printToPdf

Whether to print the sheet as PDF

pdfFileName

File name and path for PDF printing to a file

pdfStream

File stream for PDF printing to a stream

pdfWriteMode

How printing the sheet as PDF is handled

pdfWriteTo

Output for printing the sheet as PDF

Reference

PrintInfo Class
PrintInfo Members
Overload List