How can I create an Excel compatible Spreadsheets

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

try ExcelPackage at codeplex. its simple and efficient.

Answer 3

You could use the NPOI library.

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

Answer 4

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.