How to Refresh Excel Data Source Via Java

Question

I have an excel file that pulls in data via data connection from bunch of CSV files. The CSV files are generated every now so often by a JAVA program.

Is it possible to refresh the data too via. JAVA program? I see JXCELAPI and JOI are there, but briefly looking at their documentation doesn't indicate my use case is even possible.

In short, I need API that could achieve this effect: clicking on menu Data->Refresh All.

Thanks, _Madhu

Answer 1

This tutorial sounds like it might help: Accessing Excel from Java

Answer 2

You could try XLLoop. This lets your spreadsheet talk directly to a java server (or a number of other languages) via function calls.

So you can have your spreadsheet call eg GetMyData("somedata") and it will load the data directly from your server whenever you re-calc (ie. Shift-F9).

BTW, I work on the project so let me know if you have any questions.

Answer 3

Thanks for the replies. It does not help me much however. My problem is that I do not want to keep excel open in some windows box.

I could write a simple macro for refreshing then since my data is obtained from bunch of CSV files stored in same directory.

I want to eliminate human-in-the-loop. Any suggestions in this regard would be appreciated.