Spread Windows Forms 9.0 Product Documentation
PrintInfo Constructor(String,String,String,PrintMargin,PrintOrientation,PrintPageOrder,Boolean,PrintHeader,PrintHeader,Boolean,Boolean,Boolean,Boolean,Boolean,PrintHeader,Boolean,Boolean,PrintType,Int32,Int32,Int32,Int32,Int32,Int32,Boolean,SmartPrintRulesCollection,Boolean,Boolean,Boolean,String,Int32,Boolean,String,Single,Int32,PrintNotes,PaperSource,PaperSize,Boolean,Image[],Color[],Int32,Int32,Int32,Int32,Centering,Int32,Int32,Int32,Int32,Boolean,String,Stream,PdfWriteMode,PdfWriteTo)


Header text
Footer text
Print job name
Print margins
Page orientation
Print page order
Whether to print the sheet border
Whether to print column headers
Whether to print column footers
Whether to print column footers in each page
Whether to print the title
Whether to print the subtitle
Whether to print in color
Whether to print grid lines
Whether to print row headers
Whether to print the header shadows
Whether to print cells that do not have data
What to print
First column of cell range to print
Last column of cell range to print
First row of cell range to print
Last row of cell range to print
First page of page range to print
Last page of page range to print
Whether to use SmartPrint
SmartPrint rules
Whether to adjust column widths for printing
Whether to adjust row heights for printing
Whether to preview the sheet rather than print it
Printer to which to print
Page number to print on first page
Whether to show the print dialog
Message to display for canceling printing
Factor to zoom sheet for printing
Alpha value used for sheet
Whether cell notes are printed
Source location of paper
Paper size
Whether objects are printed
Images to use for headers and footers
Colors to use for headers and footers
Index of beginning column of a repeating range
Index of ending column of a repeating range
Index of a beginning row of a repeating range
Index of ending row of a repeating range
Type of centering to perform on print out
Number of pages tall to fit print out into when smart print is true
Number of pages wide to fit print out into when smart print is true
Sets the user defined height of the header area
Sets the user defined height of the footer area
Whether to print the sheet as PDF
File name and path for PDF printing to a file
File stream for PDF printing to a stream
How printing the sheet as PDF is handled
Output for printing the sheet as PDF
Creates a new PrintInfo object with the specified printing settings.
Syntax
'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)

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
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

PrintInfo Class
PrintInfo Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.