Library to write excel file

Question

I am using the Microsoft Excel Interop library to export an Excel file. However, the limit of this library is as follows:

• Require that the user's computer must have Microsoft Excel.
• When writing content, Microsoft Automation must be open for automation.
• To save a file, the user must do this manually: click File → Save.

I need a library:

• Writing contents to memory in Excel format.
• Save this content to a file programmatically.

Notes: I am using .net 2.0 and C #.

Thank.

Answer 1

I used EPPlus to read / write .xlsx and it worked great

Answer 2

, Excel - . Microsoft . http://msdn.microsoft.com/en-us/library/cc313118.aspx.

EPPlus. http://epplus.codeplex.com/

Answer 3

ODBC OLE Excel. , , , .

. , @Joel Gauvreau excel.

: http://support.microsoft.com/kb/257819

http://www.codeguru.com/cpp/data/mfc_database/microsoftexcel/article.php/c1131