Spread Windows Forms 11.0 Product Documentation
Print Settings Imported
Spread Windows Forms 11.0 Product Documentation > Import and Export Reference > Excel-Formatted Files Import > Print Settings Imported

The following list summarizes the print settings that are imported when Spread imports data from an Excel file. These are all properties of the PrintInfo class.

Excel Setting Related Spread Property Remarks
Black and white, or color ShowColor  
Centering Centering  
Ending Column ColEnd  
Ending Row RowEnd  
Fit Height SmartPrintPagesTall  
Fit Width SmartPrintPagesWide  
Footer (page footer) Footer  
Header (page header) Header  
Margins (page margins) Margin  
Orientation (page orientation) Orientation  
Page order PageOrder  
Paper size for printing PaperSize Gets and sets the basic paper sizes: Letter, Legal, Executive, A4, Envelope #10, Envelope DL, Envelope C5, Envelope B5, Envelope Monarch
Starting Column ColStart  
Starting Row RowStart  

Headers, printing

ShowColumnHeader

ShowRowHeader

Excel allows users either to print both the column and row headers or to not print any headers. Therefore, if the Excel file is set to print both column and row headers, the ShowColumnHeader and ShowRowHeader properties in Spread are set to True.

Grid lines, printing ShowGrid  
Zoom; scaling ZoomFactor