Ask YC: Excel Generation (Server Side)?

https://news.ycombinator.com/item?id=298313

by erictobia • 18 years ago

9 14 18 years ago

news.ycombinator.com

I was curious to know if anyone could recommend a component for server side excel generation (both xls and xlsx) for an ASP.NET application. We cannot install Office on the server. We've been using this component from codeplex...

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.

mrtron• 18 years ago

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?

erictobia3• 18 years ago

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.

statictype• 18 years ago

Yes - COM Automation stuff is generally not recommended for non-interactive usage. Although I think many people do get away with it.

bradgessler• 18 years ago

Its not recommended but it does work! We managed to get MS Office to kick out around 10-15 documents per second on a single IIS server running ASP.net without much optimization. If you wanted to go crazy you could just load-balance the servers and kick out way more docs.

We tried to use a Java lib for Office docs but it was a pain in the neck. We had some very specific requirements for embedding an ActiveX control into a document and the OSS libs just weren't going to cut it. If your volume requirements aren't too high, I would just start with interoping with MS Office.

speby• 18 years ago

Have you looked at the Apache POI project? Not sure if it can do XLSX yet, though.

erictobia3• 18 years ago

I haven't had a look at that...looks promising. Right now I'd be looking for something I can use with C#.

Thanks for the suggestion.

andr• 18 years ago

XLSX is zipped XMLs, so you might try reverse-engineering. Also consider having a static XLS which imports data from a web-based CSV.

jasonkester• 18 years ago

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)

erictobia3• 18 years ago

(it only gets difficult if you need to start embedding charts and specifying fonts)

We do need to do some of this

PeterHammar• 18 years ago

I've used 2 methods:

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.

jharrison• 18 years ago

When I was at Bank of America I worked on an internal Project Management tool that used a ton of Excel spreadsheets. If you can start with some kind of template it becomes dead simple. Excel spreadsheets can be used as datasources without Excel being installed on the server (iirc). Our app just connected to the XLS and dumped the data into the existing columns. If you have charts based on those columns then you're good to go.

Of course if you can't start with a template or need to add columns on the fly...it might be a little more challenging.

ntoshev• 18 years ago

Doesn't CSV work for you? I think Excel even parses formulas in CSVs.

stsamuel• 18 years ago

We use FlexCel (http://www.tmssoftware.com/site/flexcel.asp) for some very complex .NET excel and PDF generation, and have been very happy with it. Nice clean interfaces and easy to customize.

keefe• 18 years ago

http://en.wikipedia.org/wiki/Office_Open_XML Generating files with this XML format should let you get something into excel. The only others I know of are Java based as I'm fairly anti-ms : http://poi.apache.org/ and http://jexcelapi.sourceforge.net/

Ask YC: Excel Generation (Server Side)?

Related Stories