Stampa Intervallo di pagine utilizzando SheetRender e WorkbookRender
Contents
[
Hide
]
Microsoft Excel consente di stampare un intervallo di pagine di un documento o di un foglio di lavoro. La seguente schermata mostra l’interfaccia di Microsoft Excel per specificare l’intervallo di pagine.
Aspose.Cells per Python via .NET fornisce i metodi WorkbookRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) e SheetRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) per questo scopo.
Interfaccia di Microsoft Excel per specificare l’intervallo di pagine da stampare
Il seguente codice di esempio illustra l’uso dei metodi WorkbookRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) e SheetRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount). Stampa le pagine 2-5 del documento e del foglio di lavoro.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from aspose.cells import Workbook | |
| from aspose.cells.rendering import ImageOrPrintOptions, SheetRender, WorkbookRender | |
| # For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET | |
| # The path to the documents directory. | |
| dataDir = RunExamples.GetDataDir(".") | |
| # Create workbook from source Excel file | |
| workbook = Workbook(dataDir + "SampleBook.xlsx") | |
| printerName = "" | |
| while null == printerName or "" == printerName: | |
| print("Please Enter Your Printer Name:") | |
| printerName = input() | |
| bookRenderOptions = ImageOrPrintOptions() | |
| bookRenderOptions.page_index = 1 | |
| bookRenderOptions.page_count = 2 | |
| # Print the worbook specifying the range of pages. Here we are printing pages 2-3 | |
| wr = WorkbookRender(workbook, ImageOrPrintOptions()) | |
| try: | |
| wr.to_printer(printerName) | |
| except Exception as ex: | |
| print(str(ex)) | |
| # Access first worksheet | |
| worksheet = workbook.worksheets[0] | |
| sheetRenderOptions = ImageOrPrintOptions() | |
| sheetRenderOptions.page_index = 1 | |
| sheetRenderOptions.page_count = 2 | |
| # Print the worksheet specifying the range of pages. Here we are printing pages 2-3 | |
| sr = SheetRender(worksheet, ImageOrPrintOptions()) | |
| try: | |
| sr.to_printer(printerName) | |
| except Exception as ex: | |
| print(str(ex)) |