Specificera jobb eller dokumentnamn vid utskrift med Aspose.Cells
Contents
[
Hide
]
Du kan specificera jobb- eller dokumentnamn vid utskrift av din arbetsbok eller arbetsblad med hjälp av objekten WorkbookRender eller SheetRender. Aspose.Cells tillhandahåller metoderna WorkbookRender.ToPrinter(printerName, jobName) och SheetRender.ToPrinter(printerName, jobName) som du kan använda för att ange jobbnamn vid utskrift av din arbetsbok eller arbetsblad
Specificera jobb- eller dokumentnamn vid utskrift med Aspose.Cells
Kodexemplet laddar den käll-Excel-filen och skickar den sedan till skrivaren genom att ange jobb- eller dokumentnamnet med metoderna WorkbookRender.ToPrinter(printerName, jobName) och SheetRender.ToPrinter(printerName, jobName).
Exempelkod
This file contains 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
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// Create workbook object from source Excel file | |
Workbook workbook = new Workbook(dataDir + "SampleBook.xlsx"); | |
string printerName = ""; | |
while (string.IsNullOrEmpty(printerName) && string.IsNullOrWhiteSpace(printerName)) | |
{ | |
Console.WriteLine("Please Enter Your Printer Name:"); | |
printerName = Console.ReadLine(); | |
} | |
string jobName = "Job Name while Printing with Aspose.Cells"; | |
// Print workbook using WorkbookRender | |
WorkbookRender wr = new WorkbookRender(workbook, new ImageOrPrintOptions()); | |
try | |
{ | |
wr.ToPrinter(printerName, jobName); | |
} | |
catch (Exception ex) | |
{ | |
Console.WriteLine(ex.Message); | |
} | |
// Access first worksheet | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Print worksheet using SheetRender | |
SheetRender sr = new SheetRender(worksheet, new ImageOrPrintOptions()); | |
try | |
{ | |
sr.ToPrinter(printerName, jobName); | |
} | |
catch (Exception ex) | |
{ | |
Console.WriteLine(ex.Message); | |
} |