File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Java in General and the fly likes Excel file validation Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Excel file validation" Watch "Excel file validation" New topic
Author

Excel file validation

rambabu desina
Ranch Hand

Joined: May 26, 2012
Posts: 35

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

Joined: Mar 17, 2011
Posts: 8419
    
  23

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


Isn't it funny how there's always time and money enough to do it WRONG?
Articles by Winston can be found here
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Excel file validation