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.
"Leadership is nature's way of removing morons from the productive flow" - Dogbert
Articles by Winston can be found here
Every snowflake is perfect and unique. And every snowflake contains a very tiny ad.