wood burning stoves 2.0*
The moose likes JSP and the fly likes importing data from excel to Mysql database using jsp code Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "importing data from excel to Mysql database using jsp code" Watch "importing data from excel to Mysql database using jsp code" New topic
Author

importing data from excel to Mysql database using jsp code

shyamkumar bopannachengalaiah
Ranch Hand

Joined: Dec 30, 2008
Posts: 100
i need to import data from excel to mysql database using jsp. How can i achieve this? Kindly help me.if there is any sample code kindly give me.
Brijesh Sah
Greenhorn

Joined: Jan 22, 2009
Posts: 9
You can use java's poi jar functionality. It will work for you i guess.
Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
To be more precise: Apache POI HSSF/XSSF. It isn't part of Sun Java or so as you seem to think.

You can use Apache POI to read Excel files and convert them to useable Java objects.

That said, you shouldn't be doing this in a JSP. Writing raw Java code in a JSP file instead of Java classes is receipt for trouble. JSP is a presentation technology, use it where it is for. Use taglibs and EL only, no scriptlets.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: importing data from excel to Mysql database using jsp code
 
Similar Threads
Inserting data into Mysql from excel files using jdbc
how to fetch data from excel sheet and dump to Mysql database
Java MySQL MS Excel
Excel File opening
web app. using MySQL 4.0, JSP, Tomcat & Jexcel