| |
 |
How to: Print a Workbook
The SpreadsheetControl provides the following methods to print a workbook or individual worksheets.
Method |
Description |
SpreadsheetControl.Print |
Prints a document using the default or custom printer settings defined by the System.Drawing.Printing.PrinterSettings class instance. |
Sheet.Print |
Prints a particular sheet in the document. |
SpreadsheetControl.ShowPrintDialog |
Invokes the Print dialog that allows you to select a printer and change print settings. |
C# |
using DevExpress.Spreadsheet;
using System.Drawing.Printing;
spreadsheetControl.Document.LoadDocument("Documents\\Document.xlsx");
PrinterSettings printerSettings = new PrinterSettings();
printerSettings.PrinterName = "Microsoft Print to PDF";
printerSettings.PrintToFile = true;
printerSettings.PrintFileName = "Documents\\PrintedDocument.pdf";
printerSettings.PrintRange = PrintRange.SomePages;
printerSettings.FromPage = 1;
printerSettings.ToPage = 3;
printerSettings.Copies = 1;
spreadsheetControl.Print(printerSettings);
|
VB |
Imports DevExpress.Spreadsheet
Imports System.Drawing.Printing
spreadsheetControl.Document.LoadDocument("Documents\Document.xlsx")
Dim printerSettings As New PrinterSettings()
printerSettings.PrinterName = "Microsoft Print to PDF"
printerSettings.PrintToFile = True
printerSettings.PrintFileName = "Documents\PrintedDocument.pdf"
printerSettings.PrintRange = PrintRange.SomePages
printerSettings.FromPage = 1
printerSettings.ToPage = 3
printerSettings.Copies = 1
spreadsheetControl.Print(printerSettings)
|
You can also specify various printout options to control how the document is printed. To do this, use properties of the WorksheetView and WorksheetPrintOptions objects as described in the How to: Specify Print Settings example.
Call the SpreadsheetControl.ShowPrintPreview or SpreadsheetControl.ShowRibbonPrintPreview method to invoke the Print Preview window that enables previewing the document before printing. See How to: Show a Print Preview Form for a Document for more details.

See Also
Is this topic helpful?
Additional Feedback
Close
|