Creating Excel or Excel compatible Spreadsheets on the server side in C#

Question

I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format.

I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed.

For this web project I'm building, the server doesn't have office installed (and they don't want to buy it).

What's the best library for me to use that allows me to generate office compatible spreadsheets from a windows server 2k8 using IIS7?

Some additional requirements

• Ideally, free
• Allows for simple cell formulas that can be inserted at runtime

Answer 1

You can try this library.

Or the Spreadsheetgear generator.

Answer 2

Microsoft published the OpenXML SDK.

Alternatively download the OpenXML schemas, generate simple examples with Office and use them as a foundation to write your own XML files - its not that complicated.

Answer 3

You could use the NPOI library.

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

Answer 4

Take a look at the Simple OOXML open source library.

Answer 5

I've used SmartXLS to create (and process) Excel sheets on the server.

Answer 6

try ExcelPackage at codeplex. its simple and efficient.

Answer 7

You can simply save your data into a comma separated values (CSV) file with .xls extension.

Example:

column1,column2,column3

value11,value12,value13

value21,value22,value23

value31,value32,value33

value41,value42,value43

value51,value52,value53

Answer 8

A very simple solution is:

You can build the content of the spreadsheet as a html table. Return the table to the browser with the appropriate headers set.

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

You can even add excel formulas and do simple formatting.

Answer 9

Checkout my post http://stackoverflow.com/questions/1273116/reading-excel-files-as-a-server-process for a list of some paid ones.

The one I opted for named FlexCel was very easy to use, allowed formulae to be used at run-time, was fully managed and low cost/royalty free.