Printing Workbooks

Usage Scenario

After you finish creating your spreadsheet, you will probably want to print a hard copy of the sheet for your need. When you are printing, MS Excel assumes you want to print the entire worksheet area unless you specify your selection. The following screenshot shows the dialog box for printing workbook with Excel.

todo:image_alt_text

Figure: Print Dialog Box

Printing Workbooks using Aspose.Cells

Aspose.Cells for Java provides a toPrinter method of the SheetRender class. By using the SheetRender.toPrinter method, you can provide the printer name as well as the print job name.

Sample Code

The following code snippet demonstrates the use of the SheetRender.toPrinter method to print your selected worksheet.

You can also use the WorkbookRender.toPrinter method to print the whole workbook. The following code snippet demonstrates the use of the WorkbookRender.toPrinter method to print the whole workbook.