How can I create an 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

try ExcelPackage at codeplex. its simple and efficient.