java and excel question

Question

is it possible to create a java application that will import excel files . execute excel macros and give the output in java gui. please give any advice u can on creating such an application. i will start creating the application after your input

Answer 1

Take a look at http://poi.apache.org/

Answer 2

Does this API do what you need?

Answer 3

You can try java Excel automation,

Here is a useful link: http://www.jacozoom.com/en%5FjacoZoom.shtml

Answer 4

Apache POI can read Excel files and it should expose the code of the macros, too. To actually run the macros, you'll need a VBA interpreter and a COM server. I doubt that you'll be able to make this work for complex macros (see this discussion).

Instead, try JaCob which allows you to talk to Excel from Java. This way, you should be able to load a work sheet, have Excel run the macros for you and then, you can examine the results.