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

tehvan · Accepted Answer · 2009-03-02 09:58:14Z

4

You can use the POI library for reading from excel files

answered Mar 2, 2009 at 9:58

tehvan

10.4k5 gold badges29 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Slartibartfast Over a year ago

We use POI as well in our shop, it's quirky, but it gets the job done.

JeeBee · Accepted Answer · 2009-03-02 09:55:37Z

3

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.

answered Mar 2, 2009 at 9:55

JeeBee

17.6k5 gold badges53 silver badges60 bronze badges

Comments

TofuBeer · Accepted Answer · 2009-03-02 10:06:49Z

1

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

answered Mar 2, 2009 at 10:06

TofuBeer

61.7k18 gold badges120 silver badges163 bronze badges

1 Comment

AGeek Over a year ago

Also, one more thing. This kind of connectivity will work only when u are using single PC.. But when you need to design a web-based application i.e. using Servlets or JSP than these settings won't work?? Does there exist any Java package? Please forward that...

Jeroen van Bergen · Accepted Answer · 2009-03-02 12:09:13Z

0

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.

answered Mar 2, 2009 at 12:09

Jeroen van Bergen

1,0466 silver badges7 bronze badges

Comments

MikO · Accepted Answer · 2013-04-23 17:03:55Z

0

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>

edited Apr 23, 2013 at 17:03

MikO

18.8k13 gold badges81 silver badges112 bronze badges

answered Apr 23, 2013 at 16:42

nitin pandey

11 bronze badge

Collectives™ on Stack Overflow

Import Data from MS Excel using Java Source Code

5 Answers 5

1 Comment

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related