File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Excel file validation

 
rambabu desina
Ranch Hand
Posts: 42
Hibernate Java Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear ranchers,

In my project there is need to validate excel file(to be uploaded ) against the some existed template(according to some format) .after validating i have to store it in the Database using Some API.

for this flow please suggest me better flow.

Thanks and regards
Ram
 
Winston Gutkowski
Bartender
Pie
Posts: 9477
50
Eclipse IDE Hibernate Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
rambabu desina wrote:In my project there is need to validate excel file(to be uploaded ) against the some existed template(according to some format) .after validating i have to store it in the Database using Some API.

1. Excel is a proprietary format, closely guarded by Microsoft, so the available freeware products for dealing with it are thin on the ground. The only one I know of that deals with it natively is Apache POI, but whether it does what you want you'll have to find out for yourself.
2. The basic API for dealing with databases in Java is JDBC.
3. Storing Excel files in a database strikes me as the height of redundancy, since there's already a perfectly good way of doing it: a filesystem.

Winston
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic