Welcome to the Java Programming Forums


The professional, friendly Java community. 21,500 members and growing!


The Java Programming Forums are a community of Java programmers from all around the World. Our members have a wide range of skills and they all have one thing in common: A passion to learn and code Java. We invite beginner Java programmers right through to Java professionals to post here and share your knowledge. Become a part of the community, help others, expand your knowledge of Java and enjoy talking with like minded people. Registration is quick and best of all free. We look forward to meeting you.


>> REGISTER NOW TO START POSTING


Members have full access to the forums. Advertisements are removed for registered users.

Results 1 to 3 of 3

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

  1. #1
    Junior Member
    Join Date
    May 2014
    Posts
    1
    My Mood
    Confused
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post 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...


  2. #2
    Super Moderator
    Join Date
    Jun 2013
    Location
    So. Maryland, USA
    Posts
    5,520
    My Mood
    Mellow
    Thanks
    215
    Thanked 698 Times in 680 Posts

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

    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.

  3. #3
    Member
    Join Date
    Oct 2013
    Location
    Manila, Philippines
    Posts
    285
    My Mood
    Amused
    Thanks
    6
    Thanked 64 Times in 61 Posts

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

    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.

Similar Threads

  1. How to Read data from Datasheet of an Excel sheet using Java?
    By Umasri in forum What's Wrong With My Code?
    Replies: 1
    Last Post: October 22nd, 2013, 11:13 AM
  2. Replies: 7
    Last Post: May 28th, 2013, 09:03 AM
  3. exprot data from excel sheet to DataBase
    By chiranjeevireddy in forum What's Wrong With My Code?
    Replies: 0
    Last Post: May 20th, 2013, 07:58 AM
  4. read excel sheet into database
    By shri in forum JDBC & Databases
    Replies: 7
    Last Post: March 8th, 2013, 12:51 AM
  5. Replies: 1
    Last Post: August 3rd, 2011, 02:28 PM