Results 1 to 5 of 5
  1. #1
    anji2010 is offline Member
    Join Date
    Sep 2013
    Posts
    2
    Rep Power
    0

    Default Read/write to same excel file using Apache POI

    i want to read an excel and write to the same excel based on some conditions. for example

    Empno Name Salary
    1 jonh 2000
    2 Sam 3000
    3 Dean 7000

    Now my requrient is

    1) want to read the data based on column name say 'Name' and get all the data under that column

    2) in the same way based on the column name say 'Name' i want to add one more row of data ie data should be in the following way after adding new row to same excel file

    Empno Name Salary
    1 jonh 2000
    2 Sam 3000
    3 Dean 7000
    4 Smith 8000
    how to do this using Apache POI.

    can anybody provide me an example . i want to read/read to the same excel donot want to create a new excel.

    thanks in advance.

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,450
    Rep Power
    18

    Default Re: Read/write to same excel file using Apache POI

    Read it in, do the changes, write it out.
    Not sure what the problem is?
    Please do not ask for code as refusal often offends.

  3. #3
    anji2010 is offline Member
    Join Date
    Sep 2013
    Posts
    2
    Rep Power
    0

    Default Re: Read/write to same excel file using Apache POI

    Hi,

    Thanks for your quick and Simple anwser ( :) :)

    but i am very new to java and not that much into coding at all . i started learning recently only that don not have much idea to POI.

    i though that this forum will help me in solving my problem . hope understand

    thanks in advance

  4. #4
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    11,450
    Rep Power
    18

    Default Re: Read/write to same excel file using Apache POI

    POI is not something someone new to Java ought to be doing.
    There's lots of moving parts (eg IO) that you should have learned via something simpler.

    If it's just a case of learning POI, there are lots of examples on the Apache site for it.
    Please do not ask for code as refusal often offends.

  5. #5
    erdsingh is offline Member
    Join Date
    Jan 2014
    Posts
    4
    Rep Power
    0

    Default Re: Read/write to same excel file using Apache POI

    please refer javabestinfo.com/excel-poi-utils.html to get understand excel apache poi utility methods

Similar Threads

  1. Replies: 0
    Last Post: 08-19-2013, 09:00 AM
  2. Replies: 2
    Last Post: 03-12-2013, 10:17 AM
  3. Replies: 0
    Last Post: 07-18-2012, 12:44 PM
  4. Excel file read error
    By Asvin in forum New To Java
    Replies: 10
    Last Post: 04-28-2011, 10:01 PM
  5. How to Read Excel file??
    By spalax in forum New To Java
    Replies: 3
    Last Post: 08-15-2009, 05:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •