An extensions library for EPPlus package to generate and manipulate Excel files easily.
Package updates, and minor bug fixes
Thanks @osoykan
Implemented DeleteColumns() and CheckHeadersAndThrow() methods
Implemented GetValuedDimension() method on ExcelWorksheet object
Action<IExcelConfiguration>
as only one parameter. So, you can fluently pass your configurations.ToList example;
IList<StocksDto> list = package.ToList<StocksDto>(1, configuration =>
{
configuration.HasHeaderRow = false;
configuration.SkipCastingErrors = true;
});
ToExcelPackage example;
ExcelPackage package = personsList
.ToWorksheet("Persons List", configuration =>
{
configuration.ConfigureColumn = x => { x.SetFontColor(Color.Purple); };
configuration.ConfigureHeader = x =>
{
x.SetFont(new Font("Arial", 13, FontStyle.Bold));
x.SetFontColor(Color.White);
x.SetBackgroundColor(Color.Black);
};
}).ToExcelPackage();
```
2) Implemented basic style functions for _ExcelWorksheet_, _ExcelColumn_, _ExcelRow_, and _ExcelRange_ objects. These methods; _SetFont()_, _SetFontColor()_, _SetBackgroundColor()_, _SetHorizontalAlignment()_ and _SetVerticalAlignment()_.
3) Implemented _CheckAndThrowColumn()_ and _CheckColumnValueIsNullOrEmpty()_ methods on _ExcelWorksheet_ object
4) Bug fixes, minor performance improvements, and so on...