Impresión de rango de páginas usando SheetRender y WorkbookRender
Microsoft Excel te permite imprimir un rango de páginas de un libro o una hoja de trabajo. La siguiente captura de pantalla muestra la interfaz de Microsoft Excel para especificar el rango de páginas.
Aspose.Cells proporciona los métodos WorkbookRender.ToPrinter (string PrinterName, int PrintPageIndex, int PrintPageCount) y SheetRender.TePrinter (string PrinterName, int PrintPageIndex, int PrintPageCount) con este propósito.
Interfaz de Microsoft Excel para especificar el rango de páginas a imprimir
El siguiente código de ejemplo ilustra el uso de los métodos WorkbookRender.ToPrinter (string PrinterName, int PrintPageIndex, int PrintPageCount) y SheetRender.ToPrinter (string PrinterName, int PrintPageIndex, int PrintPageCount). Imprime las páginas 2-5 del libro y la hoja de trabajo.
// 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); | |
} |