It's not a secret anymore!
The moose likes Java in General and the fly likes Java and MS Office Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Java and MS Office" Watch "Java and MS Office" New topic

Java and MS Office

Martin Krueger

Joined: May 30, 2007
Posts: 7

In the application (JSF) i want to develop i need to do a lot of MS-Office stuff. From my point of view it would be easy to do this in Visual Studio or C#.
Is there a possibility for Java to talk to Vb and get an answer back (for ex. I'm ready or an exception)?

I've found something for Outlook. But i still need a solution for Word and Excel

kind regards<br /> <br />Martin
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
Old versions of BSF (2.2 and 2.3rc1) used to include a VBScript connector. That would allow you to run scripts (and pass parameters back and forth). At a quick glance, those versions seem to be gone from the download area, and even from the archive, though. Maybe the BSF folks can still provide you with a version.

Or is it actually COM objects/DLLs you are trying to talk to? In that case, a library like Jacob can take the pain out of using JNI to do this.
[ September 06, 2007: Message edited by: Ulf Dittmer ]
Shane W
Ranch Hand

Joined: Aug 31, 2007
Posts: 30
For excel, you can use POI
Apple Man
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 15092

"Apple Man", please check your private messages. You can see them by clicking My Profile.

Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 8 API documentation
Martin Krueger

Joined: May 30, 2007
Posts: 7

thank's for your help. i think i will have a look at jacob.
I agree. Here's the link:
subject: Java and MS Office
It's not a secret anymore!