0

I have an excel with few macros in it. I want to run these macros from JAVA program using POI library.

I verified the available classes in POI library. But it seems there are no classes available in POI library to do this task.

Any suggestion to achieve this functionality would be greatly appreciated.

smriti
  • 1,124
  • 5
  • 14
  • 35
  • 1
    Since VBA is hosted, you need an instance of Excel to run these. POI is for reading and writing. – BigBen Sep 30 '22 at 15:59
  • Thanks Bigben, But how to get instance of an excel which has macros. Is there any way to get it from java code. And how to call macros from that instance – smriti Sep 30 '22 at 18:53
  • Possible duplicate of [_How to call an Excel VBA Macro from Java Code?_](https://stackoverflow.com/q/7789780/230513) – trashgod Oct 01 '22 at 12:40

0 Answers0