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:
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.FreezeLeftColumnto 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.
Cell.FromObjectto make Cell creation easier by guessing the correct type
- Support DateTime cells
- Add support for manual page breaks. Call
Worksheet.InsertManualPageBreakAfterColumnwith 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.