This project has moved. For the latest updates, please go here.

Using Default Styles

The XLWorkbook class has the following read-only static properties with the default information. Right now these options are hard coded, but in a future release I'll allow them to be defined in a config file.

        public static IXLStyle DefaultStyle { get; }
        public static Double DefaultRowHeight { get; }
        public static Double DefaultColumnWidth { get; }
        public static IXLPageSetup DefaultPageOptions { get; }


The XLWorkbook and worksheet instances also have a similar set of properties which you can modify. In the case of a workbook these properties will be set to their defaults when you create a new workbook. All new worksheets will be initialized the style of the workbook.

        public IXLStyle Style { get; set; }
        public Double RowHeight { get; set; }
        public Double ColumnWidth { get; set; }
        public IXLPageSetup PageOptions { get; set; }


Example:

            // The static default values are read-only so even if 
            // you try to change a referenced type, the changes will be discarded.
            var style = XLWorkbook.DefaultStyle;
            style.Border.DiagonalUp = true;
            style.Border.DiagonalDown = true;
            style.Border.DiagonalBorder = XLBorderStyleValues.Thick;
            style.Border.DiagonalBorderColor = XLColor.Red;

            // Create our workbook
            var workbook = new XLWorkbook();

            // This worksheet will have the default style, row height, column width, and page setup
            var ws1 = workbook.Worksheets.Add("Default Style");

            // Change the default row height for all new worksheets in this workbook
            workbook.RowHeight = 30;

            var ws2 = workbook.Worksheets.Add("Tall Rows");

            // Create a worksheet and change the default row height
            var ws3 = workbook.Worksheets.Add("Short Rows");
            ws3.RowHeight = 7.5;

            workbook.SaveAs("DefaultStyles.xlsx");

Last edited Dec 22, 2010 at 3:31 AM by MDeLeon, version 3