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
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: 7059
    
  16

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?
Artlicles by Winston can be found here
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Excel file validation
 
Similar Threads
Synchronization approach
excel page not opening in a browser
Record Export?
excel file opening,editing and saving
read a excel file into java array list