How do I generate excel reports with rich formatting including charts with a ASP.Net application?
As per http://support.microsoft.com/kb/257757 server-side automation of office is advisable and also our admin does not allow installation of office on the server
Customer is not ready to spend a lot on 3rd party components
A must requirement is to retain the formatting used by the end user already and also use ONLY excel 2003.
Thanks
Update: We are using ExcelXmlWriter from http://www.carlosag.net/Tools/ExcelXmlWriter/Generator.aspx as it was the most fit.