How to run Excel from a java app?

[Lefty Gomez]

Urgent!!! PLease!!

[kate damond]

app- lication or app- let ?

[Dave Donohoe]

Check out Java2COM at http://www.nevaobject.com/java/java2com/java2commain.htm
You should be able to use this with an App-lication or an App-let
!
D

[Cindy Glass]

You can treat excel just like an ODBC database. Go to the JDBC forum and search on Excel and you will get some code examples.

[Lefty Gomez]

I just want to run an *.exe file from my application.

[Cindy Glass]

Oh - try this:

try
{
   Runtime r = Runtime.getRuntime();
   //where ever your excel is at
   Process p = r.exec( "C:\\Program Files\\Microsoft Office\\Office\\EXCEL.EXE" );
}
catch( IOException ioe )
{
   System.out.println( "Exception" );
}

[Michael Ernest]

On a related thread, I had several email requests asking whether I knew how to read CSV files from multi-page worksheets and the like into Java. Nope, I didn't. Still don't.
However, I was made aware yesterday of a tool, built on top of JNI, that allows COM programmers to integrate Java code with MS-style objects. It's called Jawin, it's open-source, and most important, free. Slaves to Microsoft(tm) Empire, rejoice!
The most impressive thing to me, who will not code to the MS platform if I can help it, is the author's understanding of what the JNI (Java Native Interface) is and isn't good for. And I quote:

JNI is best when it is used to build a higher level marshalling layer that provides a transparent, or near transparent, mapping
between Java objects and objects on a particular native platform.

Sage words indeed.
By the way, if you are one of the very few that have emailed problematic source code to me with 'please fix' subject lines, please don't wait on a response. I understand frustration, not knowing what else to try, looming deadlines; they visit my hoouse too. I'm sympathetic, but trying to help as many people as I can by posting publicly.