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: consolidate all the excel sheets in to one excel sheet

  1. #1
    Junior Member
    Join Date
    Jul 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post consolidate all the excel sheets in to one excel sheet

    hi to all,
    I am new to java and need help to develop a solution for my requirement. And the requirement is as follows

    File is given as excel sheet.
    File contains all the "MECODE" consolidated into a one pivot table.
    By clicking the "Count of MECODE" column of in each row we get individual MECODE sheets.
    Based on MECODE consolidate all the sheets into one excel sheet.


  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: consolidate all the excel sheets in to one excel sheet

    Welcome to the Forum! Please read this topic to learn how to post code correctly and other useful tips for newcomers.

    And what do you want to do with Java? Is Java the right tool?

  3. #3
    Junior Member
    Join Date
    Jul 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Re: consolidate all the excel sheets in to one excel sheet

    I want to automate the requirement using the java
    as I have a column in the excel file, if I double click on that column, one new sheet with data will come. I want to take that sheet and write it into a new excel file

Similar Threads

  1. extract wsdl parameters to excel sheet
    By hussainmonowar in forum Member Introductions
    Replies: 1
    Last Post: January 24th, 2014, 06:09 AM
  2. read excel sheet into database
    By shri in forum JDBC & Databases
    Replies: 7
    Last Post: March 8th, 2013, 12:51 AM
  3. export result into excel sheets
    By punith in forum Java Theory & Questions
    Replies: 2
    Last Post: December 1st, 2012, 03:53 PM
  4. appending from shell script to excel sheet
    By krishnamohan in forum Java Theory & Questions
    Replies: 1
    Last Post: August 16th, 2010, 10:01 AM
  5. how to copy cells to a new sheet of excel with JexcelAPI??
    By 19world in forum File I/O & Other I/O Streams
    Replies: 0
    Last Post: June 15th, 2010, 03:49 AM