C# Export Data as XLSX

As I needed to export some data to an xlsx (Excel 2007+) file I first used the Microsoft OpenXML library called DocumentFormat.OpenXML.

At first it look good but had some major performance issued while using the object oriented style. I switched over to the OpenXMLWriter (SAX) but this introduces another class of problems like corrupted files. The Documentation is a pile of shit and after some while i gave up and reimplemented my export with NPOI.

To have it a little simpler i wrote some helper functions to do the cell and row injection. The result is as follows.



Kommentar verfassen