The attached image is the example of .xls file that I want to import those data to mysql database using Java. Any help I get will be very much appreciated.
javaNooblet 0 Junior Poster
I just started recently working with java and excel files(still learning), but I have not incorporated mySQL in it.
But here are a couple basic sites for getting started with java and excel that I have found useful:
http://www.vogella.de/articles/JavaExcel/article.html#createexcel
http://www.andykhan.com/jexcelapi/tutorial.html
Hope these help, I found them great for learning how to deal with java and excel. Also, if you want to work with excel in java you will need to import this excel library, which can be found here:
pote86 0 Newbie Poster
Thanks a lot for your help. :)
androidf 0 Newbie Poster
Hi pote86, so did you manage to import data from excel to sql in java?
If so, how did you go about doing it? Im currently trying to do it, any help will be much appreciated.(:
pote86 0 Newbie Poster
I used PHP to import the data. I am not able manage to do this with Java. :)
androidf 0 Newbie Poster
I used PHP to import the data. I am not able manage to do this with Java. :)
Okay, will look for other methods then. I've already exported the data into excel spreadsheet using java and now have to transfer the data into sql db. Thanks for your reply tho:)
peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster
androidf 0 Newbie Poster
Time to look into Apache POI HSSF+XSSF that is Java API To Access Microsoft Excel Format Files
Instead of importing from excel, would it be better if i saved all the data directly to the database? And just use SQL insert statements. My work is regarding android forensics.(platform: Eclipse/SQL db) Thanks.
peter_budo 2,532 Code tags enforcer Team Colleague Featured Poster
@androidf sorry my reply was to original poster failing to find library capable of handle excel data extraction with Java. As for you please create new thread in Mobile Development section, since you work on Android, and please provide more in detail info of what you trying to do.
androidf 0 Newbie Poster
@androidf sorry my reply was to original poster failing to find library capable of handle excel data extraction with Java. As for you please create new thread in Mobile Development section, since you work on Android, and please provide more in detail info of what you trying to do.
Okay thanks, new thread created: "Android: Import data in excel to mySQL database using java".
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.