java - 如何从 Java 中的 Apache POI 库调用宏？

Question

我有:

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

::注意::

• 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

我认为这是不可能的。 POI 是一个用于读取/编辑 Office 文件的库，而宏则是另一回事。您必须在 POI 中实现 Visual Basic for Applications 解释器才能完成此操作。 Excel 工作簿中已有的宏会保留，但您不能添加新宏或调用现有宏。