使用 SheetRender 和 WorkbookRender 打印页面范围

Microsoft Excel 允许您打印工作簿或工作表的页面范围。以下截图显示了指定页面范围的 Microsoft Excel 界面。

Aspose.Cells for Python via .NET 为此提供了 WorkbookRender.ToPrinter（字符串打印机名称，整型打印页索引，整型打印页数）和 SheetRender.ToPrinter（字符串打印机名称，整型打印页索引，整型打印页数）方法。

指定要打印的页面范围的 Microsoft Excel 界面

以下示例代码演示了使用 WorkbookRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) 和 SheetRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) 方法。它打印工作簿和工作表的第 2-5 页。

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))