SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Addict
    Join Date
    Nov 2005
    Posts
    396
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    connecting to excel

    Hi, anyone who can teach me how to connect on my excel file. Using excel reader would read all the rows, but main concern is how am I going to get a data in a particular row. And so, I created an ODBC connection, this http://www.webdeveloper.com/forum/sh...d.php?t=154259 provides an example but it is not clear to me. Please help and thanks in advance.

  2. #2
    SitePoint Guru
    Join Date
    Jan 2005
    Location
    heaven
    Posts
    953
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you know the data is on row 101 that create a variable and increment it until it's value it is 101 then break out of the loop.
    Creativity knows no other restraint than the
    confines of a small mind.
    - Me
    Geekly Humor
    Oh baby! Check out the design patterns on that framework!

  3. #3
    SitePoint Evangelist
    Join Date
    Jun 2006
    Location
    Wigan, Lancashire. UK
    Posts
    523
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    PHPExcel allows you to read data from any individual cell in any worksheet within an Excel file by identifying that cell by name (e.g. "B101")
    No need to loop through all the rows until you get to the one you want
    ---
    Development Projects:
    PHPExcel
    PHPPowerPoint


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
  •