使用Aspose.Cells在打印时指定作业或文档名称
Contents
[
Hide
]
你可以在打印工作簿或工作表时,使用WorkbookRender或SheetRender对象指定作业或文档名称。Aspose.Cells for Python via .NET 提供了WorkbookRender.ToPrinter(打印机名称,作业名称)和SheetRender.ToPrinter(打印机名称,作业名称)方法,可以在打印时指定作业名称。
在使用 Aspose.Cells for Python via .NET 打印时,指定作业或文档名称
示例代码加载源Excel文件,然后使用WorkbookRender.ToPrinter(printerName, jobName)和SheetRender.ToPrinter(printerName, jobName)方法将其发送到打印机并指定作业或文档名称。
示例代码
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 object from source Excel file | |
workbook = Workbook(dataDir + "SampleBook.xlsx") | |
printerName = "" | |
while null == printerName or "" == printerName: | |
print("Please Enter Your Printer Name:") | |
printerName = input() | |
jobName = "Job Name while Printing with Aspose.Cells" | |
# Print workbook using WorkbookRender | |
wr = WorkbookRender(workbook, ImageOrPrintOptions()) | |
try: | |
wr.to_printer(printerName, jobName) | |
except Exception as ex: | |
print(str(ex)) | |
# Access first worksheet | |
worksheet = workbook.worksheets[0] | |
# Print worksheet using SheetRender | |
sr = SheetRender(worksheet, ImageOrPrintOptions()) | |
try: | |
sr.to_printer(printerName, jobName) | |
except Exception as ex: | |
print(str(ex)) |