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.

There is a newer version of this package available.
See the version list below for details.
Install-Package simplexcel -Version
dotnet add package simplexcel --version
<PackageReference Include="simplexcel" Version="" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
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.

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated 924 9/19/2018 3,915 2/24/2018 684 9/25/2017 258 9/24/2017 358 9/17/2017 424 9/7/2017
2.0.1 367 5/18/2017
2.0.0 304 4/22/2017
1.0.5 4,890 1/30/2014
1.0.4 397 1/21/2014
1.0.3 477 8/20/2013
1.0.2 666 1/10/2013