using System;
using ClosedXML.Excel;
namespace ClosedXML_Examples.Columns
{
public class ColumnSettings : IXLExample
{
#region Variables
// Public
// Private
#endregion
#region Properties
// Public
// Private
// Override
#endregion
#region Constructors
// Public
public ColumnSettings()
{
}
// Private
#endregion
#region Events
// Public
// Private
// Override
#endregion
#region Methods
// Public
public void Create(String filePath)
{
var workbook = new XLWorkbook();
var ws = workbook.Worksheets.Add("Column Settings");
var col1 = ws.Column("B");
col1.Style.Fill.BackgroundColor = XLColor.Red;
col1.Width = 20;
var col2 = ws.Column(4);
col2.Style.Fill.BackgroundColor = XLColor.DarkOrange;
col2.Width = 5;
workbook.SaveAs(filePath);
}
// Private
// Override
#endregion
}
}