java and excel 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 t开发者_如何学Pythonhe application after your input

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.

Does this API do what you need?

You can try java Excel automation,

Here is a useful link: http://www.jacozoom.com/en_jacoZoom.shtml