Automating tasks through java
<p>Here's the problem:</p>

<ol>
<li>Run a java client as a batch job on a unix box which will connect to Oracle and fetch some data.</li>
<li>Update an excel sheet (on a Windows machine) with the data fetched.</li>
<li>Create a chart/graph from the data in excel sheet.</li>
<li>Send the excel (with data &amp; graph) in an email.</li>
</ol>

<p>All the above steps must be performed without any manual intervention. </p>

<p>Could there be a better option to excel based solution? The main intent is to have a history of data fetched and have a chart created from that data. </p>

<p>I know there are many open source libraries available for creating charts like JFreeChart, but is there anything in the JDK that allows you to create charts? Could JavaFX be used for this problem? </p>

<p>In short, is it possible to do this with just jdk (without using any open source libraries)?</p>

<p>Any help/suggestion will be appreciated.</p>
