EPPlus.Core.Extensions Versions Save

An extensions library for EPPlus package to generate and manipulate Excel files easily.

v2.0.0

6 years ago

v2.0.0-preview1

6 years ago

# ATTENTION! Breaking changes! #

  • Lots of API changes, and bug fixes,
  • Fluent configuration, and more fluent syntax.
  • Separated configuration interfaces as read and create.
  • Changed exception types.

v1.2.8

6 years ago

Package updates, and minor bug fixes

v1.2.7

6 years ago
  • Fixed some datetime parsing issues.

v1.2.6

6 years ago
  • Implemented OnCaught delegate. So, now you can intercept ToList() action and modify converted item.

Thanks @osoykan

v1.2.5

6 years ago
  • Added extension methods for ExcelWorkbook to create named styles,
  • Some performance consolidations,
  • Now, you can convert a stream into ExcelPackage, directly.

v1.2.4

6 years ago

Implemented DeleteColumns() and CheckHeadersAndThrow() methods

v1.2.3

6 years ago
  • Implemented DeleteColum(headerText) method for ExcelWorksheet object,
  • Implemented BorderAround(style), SetBorderColor(color), BorderAround(style, color) methods for ExcelRangeBase object
  • And, some consolidations.

v1.2.2

6 years ago

Implemented GetValuedDimension() method on ExcelWorksheet object

v1.2.1

6 years ago

# ATTENTION! Breaking changes! #

  1. Removed configuration parameters from methods, and added 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...