c# - So I really can't use Excel Object Model to be used server-side?

Question

I'm trying to develop a c#/asp.net application to extract data from a SQL server and have it formatted in an excel spreadsheet. I have been practicing with excel object model and recently stumbled upon this: http://support.microsoft.com/kb/257757 Considerations for server-side Automation of Office

From what I understand I really can't use Excel Object models? And if not what are other solutions/advice besides whats suggested in this article and 3rd party apps I can use?

Answer 1

I can recommend the SpreadsheetGear library, it has all the Excel functions in one managed dll:

http://www.spreadsheetgear.com/