Simplexcel
Simplexcel copied to clipboard
A 100% managed code (.net Standard 2.0/2.1/Core/.net Framework 4.5+) library to generate Excel .xlsx Workbooks. Can be safely used on a server, no COM Interop or other unsafe/unsupported operations.
There is an attribute that allows to have Excel automatically size columns.
I see no way in defining a cell as a currency cell. Would be nice if there was a way.
If charts can be done without OLE, these might be useful, especially for the common ones (Bar, Line, Pie).
Merges can be done to the right and down. Problem: CellCollection needs to know when I'm trying to edit a cell that's part of a merge and either modify the...
When i want to do ``` sheet.Cells["B2"].Bold = true; ``` this throws a NullReferenceException because the B2 Cell isn't created yet. CellCollection should implicitly create an empty cell. Two problems:...
```cs var ws = new Worksheet("Testing"); ws.Cells[0,0] = "Foo"; ws.Cells[1,1] = null; var wb = new Workbook(); wb.Add(ws); wb.Save(@"test.xlsx"); ``` NullReferenceException: ``` at Simplexcel.XlsxInternal.XlsxWriter.XlsxWriterInternal.HandleLargeNumbers(Worksheet sheet) at Simplexcel.XlsxInternal.XlsxWriter.XlsxWriterInternal.Save(Workbook workbook, Stream outputStream,...
For me, it is somehow annoying that Sheet.Cells(0, 0) is the upper left cell instead of Sheet.Cells(1, 1). Feels counterintuitive. Maybe you could have some workbook flag where you can...
Hey Folks! I've decided to archive this repository because I won't have time to really look after it anymore. I started Simplexcel back in 2013 because I needed to reliably...
Record types have a compiler generated `EqualityContract` property that we want to ignore when populating a worksheet.