Get list of opened Excel files (workbooks) from Java

开发者_StackOverflow社区I have a problem with the integration of MS Excel into my java application. I use Jacob to talk to Excel via the COM API, which generally works fine. An XLS file can be opened from the application, and changes are properly stored.

But then I just noticed my code becomes buggy when Excel is already opened and at least one workbook was changed in memory but not already saved. A simple statement like this one fails with an exception:

excel.getProperty("Workbooks");

I do very little with the workbooks collection: just adding a new workbook or counting its size. This really should work somehow.

Do I miss something?