Tutorial :Import Data from MS Excel using Java Source Code



Question:

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


Solution:1

You can use the POI library for reading from excel files


Solution:2

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.


Solution:3

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


Solution:4

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.


Solution:5

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
Previous
Next Post »