Tutorial :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..


You can use the POI library for reading from excel files


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.


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


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.


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>  

Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Next Post »