• Post Reply Bookmark Topic Watch Topic
  • New Topic

Excel file Clean Up and Save to Database  RSS feed

 
Luke Zechariah
Ranch Hand
Posts: 142
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Hello I have Java Project, a database and an Excel file. I have to write a Java file to clean up the Excel file. Most of the data is not in proper order.  The goal is to clean up the excel file either programatically or any means into a proper order such as identifying which is LastName FirstName, Licenses, Occupation, Address, Product Owner etc. Then using Java or Groovy, I have write a code to save the Excel file to the database. Basically I want to do a Text mining in Excel

Can any one suggest me ideas?
Thank you,
Luke.
 
Jesper de Jong
Java Cowboy
Sheriff
Posts: 16060
88
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Probably the most well-known library for working with Microsoft Office files such as Excel files is Apache POI.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!