Building Excel Files with C#

Question

I need to create an excel file via C#. I have read a few places that creating an XML document is the easiest way to do this? I need to have multiple named tabs and be able to specify that particular cells are text, date time, numeric, etc... Any suggestions or good examples?

Answer 1

Take a look at NPOI:

http://www.codeplex.com/npoi

This has also been fairly well covered elsewhere on SO:

http://stackoverflow.com/search?q=create+excel+.net

Answer 2

You need the System.IO.Packaging API - this will allow you to generate .xlsx documents as described in Inserting Values into Excel 2007 Cells. The Excel 2007 format can also be used by Excel 2003 and XP with the free Microsoft Office Compatibility Pack installed.

Answer 3

you can chech this link

and spreadsheetgear

and CarlosAg Excel Xml Writer Library

Answer 4

check out this post: http://stackoverflow.com/questions/170652/whats-the-best-net-library-for-parsing-and-generating-excel-spreadsheets

Answer 5

We use a suite called Aspose at work. It has a large fully featured "Cells" component that works wonders for us.