XLS JDBC

XlS JDBC driver is used to access xls file from java application. It is read only JDBC driver. You can only do a SELECT * FROM xls file statement. The other SQL command or option is not supported in this driver, even a single WHERE clause.

Example-

At First make an Excel Sheet of name 'student' as given below-

Since excel comes with ODBC driver therefore you should use JDBC - ODBC bridge driver to connect your excel spreadsheet . The name of the worksheet is equivalent to the database table name. Now Create a Data Source Name using Microsoft  Excel Driver. Give Data Source Name 'datasource'. 

XLSJDBCExample.java

package roseindia.net;

import java.sql.*;

public class XLSJDBCExample {
	XLSJDBCExample() {
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		} catch (Exception e) {
			System.out.println(e.toString());
		}
	}

	public static void main(String args[]) throws SQLException {
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		try {
			conn = DriverManager.getConnection("jdbc:odbc:datasource", "", "");
			stmt = conn.createStatement();
			String query = "select * from [Sheet1$]";
			rs = stmt.executeQuery(query);
			while (rs.next()) {
				System.out.println("Roll No:- " + rs.getInt("RollNo")
						+ ", Name:- " + rs.getString("Name") + ", Course:- "
						+ rs.getString("Course") + ", Age:- "
						+ rs.getInt("Age"));
			}
		} catch (Exception e) {
			System.out.println(e.toString());
		} finally {
			rs.close();
			stmt.close();
			conn.close();
		}
	}
}

Download this example code

Related Tags for XLS JDBC Example: