This week's giveaway is in the EJB and other Java EE Technologies forum. We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line! See this thread for details.
Requirements: 1) Read data from Excel File : Suppose the File contains: Empnumber, Empname, and Salary columuns.. There will be thousands of rows.
-> we have to read data from Excel file and validate the data( i.e, the Empnumber must be varchar, Empname must be character, and Salary must be numeric). -> if the data is valid then store the data in the database table1.
-> if the data is not valid then find out the location of the invalid data with index number and the column which is invalid and store the invalid data with index number in a database table2.