1–10 of 15 posts
http://www.codeplex.com/ExcelPackage
...and we haven't been thrilled with it. We're open to a commercial solution - we're just not sure what the best option is.
Thanks in advance for any suggestions.
http://sourceforge.net/projects/pyexcelerator
If you are using ASP.NET why can't you install Office on the server?
Have you looked at the Apache POI project? Not sure if it can do XLSX yet, though.
Thanks for the suggestion.
I know of a lib for Python but it only produces xls. http://sourceforge.net/projects/pyexcelerator If you are using ASP.NET why can't you install Office on the server?
Thanks for the link to the Python framework though.
- change your response mime-type to application/excel
- supply a filename ending with .xls
- output comma-separated text.
done.
(it only gets difficult if you need to start embedding charts and specifying fonts)
You haven't said what you're trying to put into that Excel spreadsheet. If it's just rows of text, numbers, and formulas, then it's dead simple. - change your response mime-type to application/excel - supply a filename ending with .xls - output comma-separated text. done. (it only gets difficult if you need to start embedding charts and specifying fonts)
We do need to do some of this
1: SpreadsheetML: You can output XML which is understood by excel, here is an introduction: http://msdn.microsoft.com/en-us/library/bb226687(office.11).aspx
2: Insert values into an existing template.xls which is accessed with sql using an Oledbconnection. The template can have existing charts which will get updated with the new values.
I know of a lib for Python but it only produces xls. http://sourceforge.net/projects/pyexcelerator If you are using ASP.NET why can't you install Office on the server?
The latest (licensed) version of Office we have is 2003. As far as we know using Office 2003 for server side Excel generation is not recommended. Thanks for the link to the Python framework though.