This is not the case for all scenarios, but it is for mine.

However, what matters most to me are your comments and opinions.ĮDIT: Ironically, in my opinion and following the answer with the most votes, the best Excel import&export library is no export at all. Given Excel 2007 is an xml-based (and zipped) file format, I am guessing this kind of library should be easy to find. I can work with CSV directly, if I had a tool to convert to and from Excel. I am thinking of flat CSV files, but Excel is a customer requirement. I don't need to generate charts or anything like that, just export raw data. Right now, I am using a simple tool that generates HTML that is loaded by Excel later on, but I am losing some capabilities, plus Excel complains when we load it. What library do you recommend? Have you used it for large quantities of data? Are there other solutions? Free is always great, but can be a commercial library.

Does not cost a crapload of money (no enterprise library like aspose).

Works well with large files (100k to 10M) - fast enough.

Takes a typed collection and, if it can, tries to put numeric fields as numeric in Excel.

Excel 2007 files (Does Excel 2003 support over 64k rows? I need more than that.).

I'm looking for a library I can use for this purpose. We also want to import Excel files in a specific format.

In one of our ASP.NET applications in C#, we take a certain data collection (SubSonic collection) and export it to Excel.

Export calibre library to excel