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