I am working on an old web ASP application which needs a temporary solution (before upgrade to .NET) for some Excel reports with a high number of records (more than 65600). It generates some reports now in Excel 2003 (or earlier, whatever versions the users have installed on their machines); however the number of reccords is estimated to increase and it will have to be moved to Excel 2007; there are issues when generating the report from ASP page as HTML and convert to Excel 2007 using content-type; since Excel is not installed on the Web server, one solution would be to use OPEN HML SDK to generate a spreadsheed (assuming that .NET 3.5) will be instaled on the web server. Question: does anyone has any solution on how to integrate ASP pages with Open XML SDK? Is that possible?
Thanks