wood burning stoves 2.0*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Java and MS Office" Watch "Java and MS Office" New topic
Author

Java and MS Office

Martin Krueger
Greenhorn

Joined: May 30, 2007
Posts: 7
Hello

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
Marshal

Joined: Mar 22, 2005
Posts: 41068
    
  43
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 ]

Ping & DNS - my free Android networking tools app
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: 14074
    
  16

"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 7 API documentation
Scala Notes - My blog about Scala
Martin Krueger
Greenhorn

Joined: May 30, 2007
Posts: 7
Hello

thank's for your help. i think i will have a look at jacob.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Java and MS Office
 
Similar Threads
Excel document created using HSSF POI API not opening in Windows7 but opening in Win XP
Java to Visual Studio or C# and back
How to produce multi-sheet excel output with XSLT
VB script, VB and MS office
Open Office classes