Results 1 to 4 of 4
  1. #1
    matt20687 is offline Member
    Join Date
    Jun 2012
    Posts
    5
    Rep Power
    0

    Default Read Excel File (.xls), search for a word in the workbook which is set as a varible

    Hello,

    At present i have created a form which is laid out as below:

    Site: [Text Field]

    Username: [Text Field]

    Password: [Text Field]


    [Submit] [Clear]

    The submit and clear are clickable buttons. Basically the user will enter a Site name in the top field, click submit and i want the code to search the .xls to find the name of the site on the sheet. I think if i can get that far i will be able to figure the rest out myself.

    The site is always included in column A (or 0) and only occurs once throughout the workbook, is there anything anyone can suggest or provide?

    Do ask if you need any more info.

    Thanks,
    Matt

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

    Default Re: Read Excel File (.xls), search for a word in the workbook which is set as a varib

    So loop through the rows looking at the first element (get(0)).
    Not sure what your exact problem is.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

  3. #3
    matt20687 is offline Member
    Join Date
    Jun 2012
    Posts
    5
    Rep Power
    0

    Default Re: Read Excel File (.xls), search for a word in the workbook which is set as a varib

    Hello,

    The problem i have is that i am quite new to this and cannot find the code/examples anywhere. Are you able to give me some sample code?

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

    Default Re: Read Excel File (.xls), search for a word in the workbook which is set as a varib

    API.
    Quick guide.
    How To.

    All from the Apache POI website.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Similar Threads

  1. Replies: 2
    Last Post: 04-06-2011, 04:38 PM
  2. Replies: 3
    Last Post: 02-23-2011, 07:25 PM
  3. Open an Excel workbook
    By ch7787 in forum New To Java
    Replies: 5
    Last Post: 07-20-2010, 05:20 PM
  4. Replies: 7
    Last Post: 11-19-2008, 02:09 PM
  5. Replies: 0
    Last Post: 03-11-2008, 02:20 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
  •