Simplexcel 2.0.5
It's been a few month since I released Simplexcel 2.0.0, which was a major change in that it added .net Standard support, and can be used on .net Core, incl. ASP.net Core.
Since then, there have been a few further feature updates:
- Add
Worksheet.Populate<T>
method to fill a sheet with data. Caveats: Does not loot at inherited members, doesn't look at complex types. - Also add static
Worksheet.FromData<T>
method to create and populate the sheet in one. - Support for freezing panes. Right now, this is being kept simple: call either
Worksheet.FreezeTopRow
orWorksheet.FreezeLeftColumn
to freeze either the first row (1) or the leftmost column (A). - If a Stream is not seekable (e.g.,
HttpContext.Response.OutputStream
), Simplexcel automatically creates a temporary MemoryStream as an intermediate. - Add
Cell.FromObject
to make Cell creation easier by guessing the correct type - Support DateTime cells
- Add support for manual page breaks. Call
Worksheet.InsertManualPageBreakAfterRow
orWorksheet.InsertManualPageBreakAfterColumn
with either the zero-based index of the row/column after which to create the break, or with a cell address (e.g., B5) to create the break below or to the left of that cell.
Simplexcel is available on Nuget, and the source is on GitHub.