Simplexcel .xlsx library

A 100% managed code library to generate Excel .xlsx Workbooks. Can be safely used on a server, no COM Interop or other unsafe/unsupported operations.

Install-Package simplexcel -Version
dotnet add package simplexcel --version
paket add simplexcel --version
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

2.1.0 (2017-09-25)

* Functional Change: Numbers with more than 11 digits are forced as Text by Default, because of a limitation in Excel. To restore the previous functionality, you can set Worksheet.LargeNumberHandlingMode to LargeNumberHandlingMode.None. You can also use Cell.IsLargeNumber to check if a given number would be affected by this.

* Functional Change: Worksheet.Populate/Worksheet.FromData now also reads properties from base classes.
Worksheet.Populate/Worksheet.FromData accept a new argument, cacheTypeColumns which defaults to false. If set to true, then Simplexcel will cache the Reflection-based lookup of object properties. This is useful for if you have a few types that you create sheets from a lot.

* You can add [XlsxColumn] to a Property so that Worksheet.Populate/Worksheet.FromData can set the column name and a given column order. Caveat: If you set ColumnIndex on some, but not all Properties, the properties without a ColumnIndex will be on the right of the last assigned column, even if that means gaps. I recommend that you either set ColumnIndex on all properties or none.

* You can add [XlsxIgnoreColumn] to a Property so that Worksheet.Populate/Worksheet.FromData ignores it.

* Added Cell.HorizontalAlignment and Cell.VerticalAlignment to allow setting the alignment of a cell (left/center/right/justify, top/middle/bottom/justify).

* Added XmlDoc to Nuget package, so you should get Intellisense with proper comments now.

Version History

Version Downloads Last updated (current version) 93 9/25/2017 27 9/24/2017 47 9/17/2017 93 9/7/2017
2.0.1 147 5/18/2017
2.0.0 63 4/22/2017
1.0.5 1,082 1/30/2014
1.0.4 186 1/21/2014
1.0.3 255 8/20/2013
1.0.2 367 1/10/2013