java - Real-Time Excel Updates -


i have third party application updates cell values opening excel file, setting values in cells, , writing (saving) excel file. suppose have excel spreadsheet open @ times, how have spreadsheet reflect these changes in real-time?

every time there update, have re-open excel file see new changes.

ps. using apache poi.

thank you.

you cannot using apache poi. if have excel spreadsheet open in excel, filenotfoundexception if attempt write changes file. @ least on windows, this:

java.io.filenotfoundexception: myspreadsheet.xlsx (the process cannot access file because being used process) 

additionally, if worked, there nothing in apache poi api interacts excel application itself, cannot tell excel re-open spreadsheet.


Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -