Implement Custom Paper Size of Worksheet for Rendering
Possible Usage Scenarios
There is no direct option available to create custom paper sizes in MS Excel, however, you can set custom paper size of your desired worksheets when rendering Excel file to PDF file format. This document explains how to set a custom paper size of a worksheet using Aspose.Cells APIs.
Implement Custom Paper Size of Worksheet for Rendering
Aspose.Cells allows you to implement your desired paper size of the worksheet. You may use the CustomPaperSize method of the PageSetup class to specify a custom page size. The following sample code illustrates how to specify a custom paper size for the first worksheet in the workbook. Please also see the output PDF generated with the following code for a reference.
Screenshot
Sample Code
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
//Create workbook object | |
Workbook wb = new Workbook(); | |
//Access first worksheet | |
Worksheet ws = wb.Worksheets[0]; | |
//Set custom paper size in unit of inches | |
ws.PageSetup.CustomPaperSize(6, 4); | |
//Access cell B4 | |
Cell b4 = ws.Cells["B4"]; | |
//Add the message in cell B4 | |
b4.PutValue("Pdf Page Dimensions: 6.00 x 4.00 in"); | |
//Save the workbook in pdf format | |
wb.Save(outputDir + "outputCustomPaperSize.pdf"); |