excel - How to call a Macro from Apache POI library in Java?

Question

I have :

• Macro named "process" that does all the processing work for my worksheets.

• I want my Java code that uses Apache POI, to call this macro so that it can process the sheets for me.

• How can I call a Macro in Apache POI in Java ?

:: Note ::

• I am using import org.apache.poi.ss.usermodel in Apache POI.

• Please, give sample code. (I am new to Apache POI and Java itself.)

Answer 1

I don't think this is possible. POI is a library to read/edit Office files, macros are a whole other beast. You would have to implement a Visual Basic for Applications Interpreter into POI to accomplish this. Macros that are already in your Excel workbook are preserved, but you cannot add new ones or call existing ones.