Impression de la plage de pages à l aide de SheetRender et WorkbookRender
Microsoft Excel vous permet d’imprimer une plage de pages du classeur ou de la feuille de calcul. La capture d’écran suivante montre l’interface de Microsoft Excel pour spécifier la plage de pages.
Aspose.Cells fournit les méthodes WorkbookRender.ToPrinter(nomImprimante, indexImpression, nombrePagesImpression) et SheetRender.ToPrinter(nomImprimante, indexImpression, nombrePagesImpression) à cet effet.
Interface de Microsoft Excel pour spécifier la plage de pages à imprimer
Le code d’exemple suivant illustre l’utilisation des méthodes WorkbookRender.ToPrinter(nomImprimante, indexImpression, nombrePagesImpression) et SheetRender.ToPrinter(nomImprimante, indexImpression, nombrePagesImpression). Il imprime les pages 2 à 5 du classeur et de la feuille de calcul.
// 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); | |
} |