fetching data from excel

Discussion in 'Java' started by swaeded, Apr 26, 2007.

  1. swaeded

    swaeded New Member

    Joined:
    Apr 26, 2007
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    0
    My Problem is:

    I am having some datas in excel sheet...

    I want to fetch each row then i have to enter those values in the html page to the respective boxes...

    this i have to code in java...

    How to link java & excel...
     
  2. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,645
    Likes Received:
    87
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    http://blog.pradeep.net.in
    Save the excel sheet as CSV and read it line by line!
     
  3. wrecker

    wrecker New Member

    Joined:
    Mar 12, 2007
    Messages:
    40
    Likes Received:
    0
    Trophy Points:
    0
    Try using datbase connectivity. Execute query to read data from excel sheet and then i hope tat you will get idea to add to html pages...
     
  4. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,645
    Likes Received:
    87
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    http://blog.pradeep.net.in
    If u r on a windows system, then add a DSN using the MS Excel drive and point to your Excel workbook. Using a ODBC connection, you can import the excel data to anywhere you want!
     
  5. AppleMan

    AppleMan New Member

    Joined:
    Jun 25, 2007
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice