Printing Workbooks using Aspose.Cells
Aspose.Cells - Printing Workbooks
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.
//Instantiate a new workbook Workbook book = new Workbook(dataDir + "AsposeDataInput.xls"); //Create an object for ImageOptions ImageOrPrintOptions imgOptions = new ImageOrPrintOptions (); //Get the first worksheet Worksheet sheet = book.getWorksheets().get(0); //Create a SheetRender object with respect to your desired sheet SheetRender sr = new SheetRender(sheet, imgOptions); //Print the worksheet sr.toPrinter("Samsung ML-1520 Series");
//Create a WorkbookRender object with respect to your workbook WorkbookRender wr = new WorkbookRender(book, imgOptions); //Print the workbook wr.toPrinter("Samsung ML-1520 Series");