Results 1 to 4 of 4
  1. 06-11-2012, 10:29 PM #1
    matt20687
    matt20687 is offline Member
    Join Date
    Jun 2012
    Posts
    2
    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
    Reply With Quote Reply With Quote
  2. 06-12-2012, 09:41 AM #2
    Tolls
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    10,481
    Rep Power
    16

    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.
    Reply With Quote Reply With Quote
  3. 06-12-2012, 04:05 PM #3
    matt20687
    matt20687 is offline Member
    Join Date
    Jun 2012
    Posts
    2
    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?
    Reply With Quote Reply With Quote
  4. 06-12-2012, 04:47 PM #4
    Tolls
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    10,481
    Rep Power
    16

    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.
    Reply With Quote Reply With Quote
« insert RTF file in DOCx document. | Subscript in POI - Power point slide »

Similar Threads

  1. copying a excel sheet from a workbook to another through java
    By siteregsam in forum Advanced Java
    Replies: 2
    Last Post: 04-06-2011, 04:38 PM
  2. Excel - (workbook.write();) in IF statement will not work.
    By Daedalus357 in forum New To Java
    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. Search a word(taken from one file) in another file and give the line as the output
    By SwapnaNaidu in forum New To Java
    Replies: 7
    Last Post: 11-19-2008, 02:09 PM
  5. Regarding retrieval of sheet names from a excel workbook
    By yuvaraj23 in forum New To Java
    Replies: 0
    Last Post: 03-11-2008, 02:20 PM

Bookmarks

Posting Permissions

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

Forum Rules