Results 1 to 3 of 3
  1. #1
    jainmayank33 is offline Member
    Join Date
    Sep 2010
    Posts
    1
    Rep Power
    0

    Default problem in reading data from excel sheet

    hello friends i am facing problem in reading data from excel sheet for only some spacific cells.
    cells which contain some formula, that cell's value i am not able to retrive.
    i tried with org.apache.poi and jxl both. but in both cases output is same. It is giving me value
    only for that cell which doesn't contain any formula.can anybody give me solution?
    Thank you

  2. #2
    kevinn205 is offline Member
    Join Date
    Nov 2011
    Posts
    65
    Rep Power
    0

    Default Re: problem in reading data from excel sheet

    This isn't the brightest of solutions but have u tried copying all of the cells and pasting them as a value ex// 123?

    it will lose the functionality of your excel sheet but you can could save it as a duplicate and use the value only one to upload data

  3. #3
    Junky's Avatar
    Junky is offline Grand Poobah
    Join Date
    Jan 2011
    Location
    Dystopia
    Posts
    3,755
    Rep Power
    7

    Default Re: problem in reading data from excel sheet

    You said you tried Apache POI, so I will assume you used the HSSFCell class. Did you read the API to see what methods that class has?

Similar Threads

  1. How can i store a data from Excel sheet to an array.
    By deshmukh.niraj04 in forum New To Java
    Replies: 0
    Last Post: 05-03-2011, 06:33 AM
  2. Replies: 0
    Last Post: 03-23-2011, 03:46 AM
  3. Replies: 3
    Last Post: 09-24-2010, 08:53 PM
  4. Replies: 5
    Last Post: 08-21-2009, 11:03 AM
  5. Save data from Excel sheet to servlet
    By chandu.v in forum Java Servlet
    Replies: 2
    Last Post: 04-10-2008, 01:51 PM

Posting Permissions

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