javaexcelapache-poi

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

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.)

Solution

  • 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.