Druckbereich von Seiten mit SheetRender und WorkbookRender
Microsoft Excel ermöglicht es Ihnen, den Seitenbereich des Arbeitsmappen- oder Arbeitsblattes zu drucken. Der folgende Screenshot zeigt die Microsoft Excel-Benutzeroberfläche zur Angabe des Seitenbereichs.
Aspose.Cells für Python via .NET stellt die Methoden WorkbookRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) und SheetRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) für diesen Zweck bereit.
Microsoft Excel-Benutzeroberfläche zur Angabe des Seitenbereichs zum Drucken
Der folgende Beispielcode veranschaulicht die Verwendung der Methoden WorkbookRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) und SheetRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount). Es druckt die Seiten 2-5 des Arbeitsbuches und des Arbeitsblattes.
| 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)) |