Results 1 to 4 of 4
  1. #1
    jonitopsg is offline Member
    Join Date
    Apr 2015
    Posts
    3
    Rep Power
    0

    Default read and select dropdown list on xlsm file.

    I have a xlsm file with multiples dropdown list.

    This is my first time i'm using java and apache poi.
    How can i read a dropdown list from cell and select the option?.

  2. #2
    gimbal2 is offline Just a guy
    Join Date
    Jun 2013
    Location
    Netherlands
    Posts
    5,114
    Rep Power
    12

    Default Re: read and select dropdown list on xlsm file.

    What do you mean "select the option" ? That would require not only reading the excel sheet but also somehow rendering it and all the components in it. POI is not an embedded Excel program you know, its only an API to be able to read and write Excel -documents-.
    "Syntactic sugar causes cancer of the semicolon." -- Alan Perlis

  3. #3
    jonitopsg is offline Member
    Join Date
    Apr 2015
    Posts
    3
    Rep Power
    0

    Default Re: read and select dropdown list on xlsm file.

    So, how can i read the dropdown just to see the list?

  4. #4
    SurfMan's Avatar
    SurfMan is offline Godlike
    Join Date
    Nov 2012
    Location
    The Netherlands
    Posts
    1,983
    Rep Power
    8

    Default Re: read and select dropdown list on xlsm file.

    "It's not fixed until you stop calling the problem weird and you understand what was wrong." - gimbal2 2013

Similar Threads

  1. Replies: 0
    Last Post: 08-19-2013, 09:00 AM
  2. read a csv file in an array list
    By dellacpa in forum New To Java
    Replies: 21
    Last Post: 06-24-2011, 07:52 PM
  3. Jtextbox with dropdown list
    By vijay_s in forum AWT / Swing
    Replies: 1
    Last Post: 05-08-2008, 10:17 PM
  4. Help with dropdown list
    By barney in forum AWT / Swing
    Replies: 1
    Last Post: 08-07-2007, 07:17 AM

Tags for this Thread

Posting Permissions

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