Results 1 to 8 of 8
  1. #1
    rajesh.cahed is offline Member
    Join Date
    Oct 2013
    Posts
    4
    Rep Power
    0

    Default Read Excel Form Control

    Hi,

    I want to read the value of checkbox from a excel worksheet using Apache POI. But not able to get the value.

    Regards,
    Rajesh

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,224
    Rep Power
    20

    Default Re: Read Excel Form Control

    (Moved from a staff only section)

    What does your code for reading a checkbox look like?
    What is it doing wrong?
    Do you have an example of the problem with the value you are getting?

    When posting code please wrap it in [code] tags [/code].
    Please do not ask for code as refusal often offends.

    ** This space for rent **

  3. #3
    rajesh.cahed is offline Member
    Join Date
    Oct 2013
    Posts
    4
    Rep Power
    0

    Default Re: Read Excel Form Control

    Hi ,
    I am trying to automate the data entry process, where the data is in excel format. In the excel sheet for fields like Gender they are showing checkboxes with ticking the appropriate value. I need to read the whole excell sheet and convet it to xml format for further processing. I am trying to find out the the code by whihc I can read that check box value.

    Thanks,

    Rajesh
    Last edited by rajesh.cahed; 10-29-2013 at 02:35 PM. Reason: typo errors

  4. #4
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,224
    Rep Power
    20

    Default Re: Read Excel Form Control

    So the cell has a checkbox in it?
    Debug your Excel code and see what type of cell POI thinks it is.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

  5. #5
    rajesh.cahed is offline Member
    Join Date
    Oct 2013
    Posts
    4
    Rep Power
    0

    Default Re: Read Excel Form Control

    Hi ,
    No the checkbox is independent of any cell, just like an activeX control. So POI is not reading it.


    Regards,

    Rajesh

  6. #6
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,224
    Rep Power
    20

    Default Re: Read Excel Form Control

    Ah right, a Form Control.

    I think they're one of these:
    CommonObjectDataSubRecord.

    But I have no idea how you get at them.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

  7. #7
    rajesh.cahed is offline Member
    Join Date
    Oct 2013
    Posts
    4
    Rep Power
    0

    Default Re: Read Excel Form Control

    Ohh... Ok :(
    Any thanks for your help.

    Regards,
    Rajesh

  8. #8
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,224
    Rep Power
    20

    Default Re: Read Excel Form Control

    I did find this from a couple of years ago.
    Might help, but it's a bit "hands on".
    Form controls article.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Similar Threads

  1. Replies: 0
    Last Post: 05-24-2013, 12:39 PM
  2. Read a control value from webpage
    By siddu in forum New To Java
    Replies: 0
    Last Post: 02-01-2013, 02:21 PM
  3. Delete a control from a java form
    By avatarmonkeykirby in forum NetBeans
    Replies: 3
    Last Post: 05-12-2011, 10:23 PM
  4. Replies: 8
    Last Post: 10-03-2010, 10:45 AM
  5. Excel macros to control Java application
    By musicgold in forum Advanced Java
    Replies: 8
    Last Post: 04-25-2009, 11:43 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
  •