Java Code To Read Excel Files
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
public class ExcelReader
{
public static void main( String [] args )
{
Connection conObject = null;
Statement stmnt = null;
ResultSet resultSetObj=null;
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
conObject = DriverManager.getConnection( "jdbc:odbc:test");
stmnt = conObject.createStatement();
String query = "select * from [Book3$];";
resultSetObj = stmnt.executeQuery(query);
while( resultSetObj.next() )
{
System.out.println( resultSetObj.getString(1) );
}
}
catch( Exception excepObj )
{
System.err.println( excepObj );
}
finally
{
try
{
stmnt.close(...