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.
Isn't it funny how there's always time and money enough to do it WRONG?
Artlicles by Winston can be found here