Thread: how to Read excel sheet and validate then save into database through java

dear professionals,

Please some one suggest me,how to read the excel sheet data and validate that null values are inserted or columns data exceeded with respected to header.and these validated data should be stored into 3 different tables...
my requirement is college data excel sheet with combination of all groups like mba,mca,and etc...then re ad the data and find the groups then 1. give entry in the UP_LOAD_DATA_HIST table with this excel data uploading with this user and this date,
2. find the group of the department and save data into CATAGIRY_TBL.
3. Finally save the All data into the students table.

please some one suggest me how to achieve this requirement...

Welcome to the forum! Please read this topic to learn how to post code in code or highlight tags and other useful info for new members.

Please some one suggest me,how to read the excel sheet data and validate that null values are inserted or columns data exceeded with respected to header.

I suggest you to use jxl to do that. jxl is capable of read and write through excel sheet.
Maven Repository: net.sourceforge.jexcelapi » jxl
you can download it here: https://www.versioneye.com/java/net....api:jxl/2.6.12

you can also use Apache POI to read and write to excel sheet.

Make sure to read and understand the jar file's dependencies so you won't have a problem.