<div>
<br />
<a href="http://www.andykhan.com/excelread/" rel="ugc">http://www.andykhan.com/excelread/</a>&nbsp;works for excel 97<br />
<br />

</div>



http://www.andykhan.com/excelread/ [http://www.andykhan.com/excelread/] works for excel 97



<div>
Getting SQLExceptions like the following<br />
<br />
java.sql.SQLException: [Microsoft][ODBC Excel Driver] The INSERT INTO statement contains the following unknown field name:<br />
<br />
java.sql.SQLException: [Microsoft][ODBC Excel Driver] Number of query values and destination fields are not the same.<br />
<br />
<br />
Is there any other configuration that needs to be done
</div>


Getting SQLExceptions like the following

java.sql.SQLException: [Microsoft][ODBC Excel Driver] The INSERT INTO statement contains the following unknown field name:

java.sql.SQLException: [Microsoft][ODBC Excel Driver] Number of query values and destination fields are not the same.


Is there any other configuration that needs to be done

<div>
<div class="content wysiwyg-content">
I need the code to export data to an MS Excel file and open the file up from a Java app. The data would be contained in say for example a 2d array.<br />
Does anyone have this?
</div>
</div>


I need the code to export data to an MS Excel file and open the file up from a Java app. The data would be contained in say for example a 2d array.
Does anyone have this?

Java App - how export data to MS Excel

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.