How to create Excel compatible table tables on server side in C #?

Question

I would like to make server tables excel compatible with OpenXML compatible or structured data formats.

I previously used Office Interop to create Excel spreadsheets, but these applications ran on the PC on which the office is installed.

For this web project that I am creating, there is no Office installed on the server (and they do not want to buy it).

What is the best library for me to use so that I can create Office compatible tables from a Windows 2k8 server using IIS7?

Some additional requirements:

• Ideally, free
• Allows the use of simple cell formulas that can be inserted at run time.

Answer 1

try ExcelPackage in codeplex. its simple and efficient.

Answer 2

You can try this library.

Or the Spreadsheetgear generator.

Answer 3

Microsoft has published the OpenXML SDK .

Alternatively, download OpenXML schemas, create simple examples from Office and use them as a basis for writing your own XML files — it's not that difficult.

Answer 4

You can use the NPOI library.

Free, open source and supports reading and writing Excel, Word and Powerpoint documents

Answer 5

A very simple solution:

You can create the contents of the table as an html table. Return the table to the browser with the appropriate header sets.

Response.ContentType = "application/vnd.ms-excel" 

You can even add excel formulas and do simple formatting.

Answer 6

Take a look at the OOXML Simple Open Source Library .

Answer 7

I used SmartXLS to create (and process) Excel worksheets on the server.

Answer 8

You can simply save your data in a comma-delimited (CSV) file with the extension .xls.

Example:

column1, column2, column3

value11, value12, value13

value21, value22, value23

value31, value32, value33

value41, value42, value43

value51, value52, value53

Answer 9

We found SpreadsheetLight to be both excellent and open source.

Answer 10

Checkout my Reading Excel files as a server process to get a list of paid ones.

The one I chose for the named FlexCel was very easy to use, allowed the use of formulas at runtime, was fully manageable and inexpensive / without royalties.