Utskrift av sidområde med hjälp av SheetRender och WorkbookRender
Contents
[
Hide
]
Microsoft Excel ger dig möjlighet att skriva ut sidområdet av arbetsbok eller arbetsblad. I följande skärmbild visas gränssnittet i Microsoft Excel för att ange sidområdet.
Aspose.Cells för Python via .NET tillhandahåller metoderna WorkbookRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) och SheetRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) för detta ändamål.
Microsoft Excel-gränssnitt för att ange sidområdet att skriva ut
Följande kodexempel illustrerar användningen av metoderna WorkbookRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) och SheetRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount). Den skriver ut sidorna 2-5 från arbetsboken och arbetsbladet.
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)) |