Newer
Older
ClosedXML / ClosedXML_Examples / PageSetup / Margins.cs
@Francois Botha Francois Botha on 30 May 2017 824 bytes Unknown changes - something to do with line endings?
using System;
using ClosedXML.Excel;


namespace ClosedXML_Examples.PageSetup
{
    public class Margins : IXLExample
    {
        #region Methods

        // Public
        public void Create(String filePath)
        {
            var workbook = new XLWorkbook();
            var ws = workbook.Worksheets.Add("Margins");
            ws.PageSetup.Margins.Top = 1;
            ws.PageSetup.Margins.Bottom = 1.25;
            ws.PageSetup.Margins.Left = 0.5;
            ws.PageSetup.Margins.Right = 0.75;
            ws.PageSetup.Margins.Footer = 0.15;
            ws.PageSetup.Margins.Header = 0.30;

            ws.PageSetup.CenterHorizontally = true;
            ws.PageSetup.CenterVertically = true;

            workbook.SaveAs(filePath);
        }

        // Private

        // Override


        #endregion
    }
}