Forums Register Login

accessdata using excel

+Pie Number of slices to send: Send
Hi All

How to access data from excel sheet.

I have created a datasource and pointed that to excel sheet.

But when i try to access that i gives me error stating that it didnot find the name of excel sheet.

Here is my code:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Date;


public class TestExcelData {

public static Connection getConnection() throws Exception {
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc dbc:excelDB";
String username = "";
String password = "";
Class.forName(driver);
return DriverManager.getConnection(url, username, password);
}

public static void main(String args[]) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = getConnection();
stmt = conn.createStatement();
String excelQuery = "select * from Book1";
rs = stmt.executeQuery(excelQuery);

while (rs.next()) {
System.out.println(rs.getString("name") + " " + rs.getString("no"));

}
} catch (Exception e) {
System.err.println(e.getMessage());
} finally {
try {
rs.close();
stmt.close();
conn.close();

} catch (SQLException e) {
e.printStackTrace();
}
}
}
}


my excel sheet name is book1.xsl it has two columns

name and no.

thanks

Jetendra
+Pie Number of slices to send: Send
Hi,

Take a look at Apache POI.

John
Warning! Way too comfortable! Do not sit! Try reading this tiny ad instead:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1034 times.
Similar Threads
nullpointerexception
jsf and database connection problem
JDBC/Oracle access problem
Passing ResultSet to JSP
Invalid Descriptor Index
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 19, 2024 00:32:42.