Is it possible to automate excel from a java applet running in full trust?
<p>I'm looking at all possible languages to solve a particular business case problem. </p>

<p>Basically need a way to allow user to browse for an excel file locally, then using Microsoft Excel COM automation, read in the cell contents and from this point on perform some actions. </p>

<p>I have no experience with Java, but I know this type of thing is "almost" possible using Silverlight 4.0. Here is a line of code that demonstates how you begin automation in silverlight using c#:</p>

<pre><code>dynamic objExcel = AutomationFactory.CreateObject("Excel.Application");
</code></pre>

<p>Problem is Silverlight only opens files from "My Documents", and it seems there is nothing you can do to allow the app full access to the file system to read in any file. So I'm investigating if Java is capable of this task?</p>

<p>I don't need a big explanation on how to do it, mainly I just need your experience as a Java developer to say - Yes in principle its certainly possible, or not. I need to open this xls file from any location the user specifies.</p>

<p>So 2 things really:</p>

<ol>
<li>Can you browse and open any file using a trusted java applet? And get access to the files path from the open dialog?</li>
<li>Can you automate MS Word / Excel from a Java applet. </li>
</ol>

<p>Thanks</p>
