使用 SheetRender 和 WorkbookRender 打印页面范围
Microsoft Excel 允许您打印工作簿或工作表的页面范围。以下截图显示了指定页面范围的 Microsoft Excel 界面。
Aspose.Cells 提供了用于此目的的 WorkbookRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) 和 SheetRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) 方法。
指定要打印的页面范围的 Microsoft Excel 界面
以下示例代码演示了使用 WorkbookRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) 和 SheetRender.ToPrinter(string PrinterName, int PrintPageIndex, int PrintPageCount) 方法。它打印工作簿和工作表的第 2-5 页。
// 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 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(); | |
} | |
ImageOrPrintOptions bookRenderOptions = new ImageOrPrintOptions(); | |
bookRenderOptions.PageIndex = 1; | |
bookRenderOptions.PageCount = 2; | |
// Print the worbook specifying the range of pages. Here we are printing pages 2-3 | |
WorkbookRender wr = new WorkbookRender(workbook, new ImageOrPrintOptions()); | |
try | |
{ | |
wr.ToPrinter(printerName); | |
} | |
catch (Exception ex) | |
{ | |
Console.WriteLine(ex.Message); | |
} | |
// Access first worksheet | |
Worksheet worksheet = workbook.Worksheets[0]; | |
ImageOrPrintOptions sheetRenderOptions = new ImageOrPrintOptions(); | |
sheetRenderOptions.PageIndex = 1; | |
sheetRenderOptions.PageCount = 2; | |
// Print the worksheet specifying the range of pages. Here we are printing pages 2-3 | |
SheetRender sr = new SheetRender(worksheet, new ImageOrPrintOptions()); | |
try | |
{ | |
sr.ToPrinter(printerName); | |
} | |
catch (Exception ex) | |
{ | |
Console.WriteLine(ex.Message); | |
} |