Open Source Excel Engine

Question

Hi,

I am looking for an Open Source Excel Engine which can run excel on the server and return the values back for the specified cells(support Excel Functions).

I am evaluating the following solutions, but don't have deep understanding of whether they are good or bad solutions

• OpenXLS
• Gnumeric

Another non-opensource solution I am also looking into is SpreadsheetGear.

If any body has experience with these tools or know any open source tools that can be used to process and run Excel files server side, please post your comments here.

Answer 1

Andy Khan's JExcel is terrific, but I'm not sure if it supports Excel macros. It's a great Excel API in every other respect.

Answer 2

I don't know if this helps but Apache POI can process Excel .xls files without the need for MS Excel installed. It can also process formulae, as shown here.