Home

Welcome to the SejExcelExport wiki!

Just a bunch of C# (.Net 3.5+) classes for REALLY FAST exporting & importing of Excel OoXMl (2007+).

The library is totally self-contained, it does not require any other piece software is required (no Excel needed, no ODBC, ACE OLEDB, OpenXML ,....)

Although this is a .Net library and memory control is rather limited, memory consumption is kept as low as possible, and it doesn't depend on the number of rows being transferred.

---

Included is a sample that:

1. Open a XLSX template
2. Fills the template with 100,000 rows using a IDataReader as a source. Column ordered is decided by matching the template contents with the data source field names.
3. Saves the template with another name.
4. Opens the template
5. Reads 100,000 rows from the template

---