Is there a way to update an excel which is already open on my system using Apache POI and also through vba code running on some other excel?
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
The Apache POI library does not support reading, writing, or executing macros in an Excel document.
Apache stores an internal representation of the worksheet in its memory model. You will have data concurrency issues if you try to have two different applications writing to the same Excel file.
