Creating Excel or Excel compatible Spreadsheets on the server side in C#
- by CVertex
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