Setting Margins
Setting Margins
Aspose.Cells provides a class, Workbook, that represents an Excel file. The Workbook class contains the Worksheets collection that allows access to each worksheet in the Excel file. A worksheet is represented by the Worksheet class.
The Worksheet class provides the PageSetup property used to set the page setup options for a worksheet. The PageSetup attribute is an object of the PageSetup class that enables developers to set different page layout options for a printed worksheet. The PageSetup class provides various properties and methods used to set page setup options.
Page Margins
Set page margins (left, right, top, bottom) using PageSetup class members. A few of the methods are listed below which are used to specify page margins:
// 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 a workbook object | |
Workbook workbook = new Workbook(); | |
// Get the worksheets in the workbook | |
WorksheetCollection worksheets = workbook.Worksheets; | |
// Get the first (default) worksheet | |
Worksheet worksheet = worksheets[0]; | |
// Get the pagesetup object | |
PageSetup pageSetup = worksheet.PageSetup; | |
// Set bottom,left,right and top page margins | |
pageSetup.BottomMargin = 2; | |
pageSetup.LeftMargin = 1; | |
pageSetup.RightMargin = 1; | |
pageSetup.TopMargin = 3; | |
// Save the Workbook. | |
workbook.Save(dataDir + "SetMargins_out.xls"); |
Center on Page
It is possible to center something on a page horizontally and vertically. For this, there are some useful members of the PageSetup class, CenterHorizontally and CenterVertically.
// 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 a workbook object | |
Workbook workbook = new Workbook(); | |
// Get the worksheets in the workbook | |
WorksheetCollection worksheets = workbook.Worksheets; | |
// Get the first (default) worksheet | |
Worksheet worksheet = worksheets[0]; | |
// Get the pagesetup object | |
PageSetup pageSetup = worksheet.PageSetup; | |
// Specify Center on page Horizontally and Vertically | |
pageSetup.CenterHorizontally = true; | |
pageSetup.CenterVertically = true; | |
// Save the Workbook. | |
workbook.Save(dataDir + "CenterOnPage_out.xls"); |
Header and Footer Margins
Set header and footer margins with the PageSetup class members such as HeaderMargin and FooterMargin.