Page Setup and Printing Options
Sometimes, developers need to configure page setup and print settings to control the printing process. Page setup and print settings offer various options and are fully supported in Aspose.Cells.
This article shows how to create a console application in Visual Studio.Net, and apply page setup and printing options to a worksheet with a few simple lines of code using the Aspose.Cells API.
Working with Page and Print Settings
For this example, we created a workbook in Microsoft Excel and use Aspose.Cells to set page setup and print options.
Using Aspose.Cells to set Page Setup Options
First create a simple worksheet in Microsoft Excel. Then apply page setup options to it. Executing the code changes the Page Setup options as in the screenshot below.
Output file. |
---|
![]() |
- Create a worksheet with some data in Microsoft Excel:
- Open a new workbook in Microsoft Excel.
- Add some data.
- Set page setup options: Apply page setup options to the file. Below is a screenshot of the default options, before the new options are applied.
Default page setup options. |
---|
![]() |
- Download and install Aspose.Cells:
- Download Aspose.Cells for .Net.
- Install it on your development computer. All Aspose components, when installed, work in evaluation mode. The evaluation mode has no time limit and it only injects watermarks into produced documents.
- Create a project:
- Start Visual Studio. Net.
- Create a new console application. This example will show a C# console application, but you can use VB.NET too.
- Add references:
- This example uses Aspose.Cells so add a reference to that component to the project. For example: …\Program Files\Aspose\Aspose.Cells\Bin\Net1.0\Aspose.Cells.dll
- Write the application that invokes the API:
// 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); | |
// Open the template workbook | |
Workbook workbook = new Workbook(dataDir + "CustomerReport.xlsx"); | |
// Accessing the first worksheet in the Excel file | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Setting the orientation to Portrait | |
worksheet.PageSetup.Orientation = PageOrientationType.Portrait; | |
// Setting the scaling factor to 100 | |
// worksheet.PageSetup.Zoom = 100; | |
// OR Alternately you can use Fit to Page Options as under | |
// Setting the number of pages to which the length of the worksheet will be spanned | |
worksheet.PageSetup.FitToPagesTall = 1; | |
// Setting the number of pages to which the width of the worksheet will be spanned | |
worksheet.PageSetup.FitToPagesWide = 1; | |
// Setting the paper size to A4 | |
worksheet.PageSetup.PaperSize = PaperSizeType.PaperA4; | |
// Setting the print quality of the worksheet to 1200 dpi | |
worksheet.PageSetup.PrintQuality = 1200; | |
//Setting the first page number of the worksheet pages | |
worksheet.PageSetup.FirstPageNumber = 2; | |
// Save the workbook | |
workbook.Save(dataDir + "PageSetup_out.xlsx"); |
Setting Print options
Page setup settings also provide several print options (also called sheet options) that allow users to control how worksheet pages are printed. They allow users to:
- Select a specific print area of a worksheet.
- Print titles.
- Print gridlines.
- Print row/column headings.
- Achieve draft quality.
- Print comments.
- Print cell errors.
- Define page ordering.
The example that follows applies print options to the file created in the example above (PageSetup.xls). The screenshot below shows the default print options before new options are applied.
Input document |
---|
![]() |
Executing the code changes the print options. |
Output file |
---|
![]() |
// 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); | |
// Open the template workbook | |
Workbook workbook = new Workbook(dataDir + "PageSetup.xlsx"); | |
// Accessing the first worksheet in the Excel file | |
Worksheet worksheet = workbook.Worksheets[0]; | |
PageSetup pageSetup = worksheet.PageSetup; | |
// Specifying the cells range (from A1 cell to E30 cell) of the print area | |
pageSetup.PrintArea = "A1:E30"; | |
// Defining column numbers A & E as title columns | |
pageSetup.PrintTitleColumns = "$A:$E"; | |
// Defining row numbers 1 as title rows | |
pageSetup.PrintTitleRows = "$1:$2"; | |
// Allowing to print gridlines | |
pageSetup.PrintGridlines = true; | |
// Allowing to print row/column headings | |
pageSetup.PrintHeadings = true; | |
// Allowing to print worksheet in black & white mode | |
pageSetup.BlackAndWhite = true; | |
// Allowing to print comments as displayed on worksheet | |
pageSetup.PrintComments = PrintCommentsType.PrintInPlace; | |
// Allowing to print worksheet with draft quality | |
pageSetup.PrintDraft = true; | |
// Allowing to print cell errors as N/A | |
pageSetup.PrintErrors = PrintErrorsType.PrintErrorsNA; | |
// Setting the printing order of the pages to over then down | |
pageSetup.Order = PrintOrderType.OverThenDown; | |
// Save the workbook | |
workbook.Save(dataDir + "PageSetup_Print_out.xlsx"); |