CODEWITHSUNDEEP
javaexcel
AGeek
AGeek

Reputation: 5225

Import Data from MS Excel using Java Source Code

I want to Import data placed in MS Excel and print it using Java Application Program. I am newbie in Java. So Please guide, is it possible.

If yes, how? Any website/tutorial will be of great help..

Thanks in advance..

Upvotes: 3

Views: 10285

Answers (5)

nitin pandey
nitin pandey

Reputation: 1

This JSP page connects the Excel sheet to the database .

.<%@ page import="java.sql.*" %><br/>
.<% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); %>

<BODY>               

.<%
  Connection con=DriverManager.getConnection("jdbc:odbc:DsnName");<br/>
  Statement stm=con.createStatement();<br/>
  ResultSet rs=stm.executeQuery("select * from [Sheet1$]");       
%>

.<% if(!rs.next()) {
    out.println("Sorry, could not find data");
 }
 else { %>
  .<%=rs.getString(1)%>
.<%}%>

</BODY>

Upvotes: 0

Jeroen van Bergen
Jeroen van Bergen

Reputation: 1046

Why not export it from Excel in some format that is not proprietary? If the data is not too complex, even CSV might do the trick.

Upvotes: 0

TofuBeer
TofuBeer

Reputation: 61526

Here is an article on using JDBC using Excel as a data source

Upvotes: 1

tehvan
tehvan

Reputation: 10369

You can use the POI library for reading from excel files

Upvotes: 4

JeeBee
JeeBee

Reputation: 17546

You can use the jexcel APIs. They're quite simple overall. http://jexcelapi.sourceforge.net/

I also think that Apache POI is working on this area as well.

Upvotes: 3

Related Questions