1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Parssing a spreadsheet

Discussion in 'PHP' started by JEET, Nov 22, 2006.

  1. #1
    Hi,
    Is it possible to parss a "excel" spreadsheet using PHP?
    Currently, I am saving the excel file as a "tab delimited text file", and then uploading the text file. Then using php rebuilding the table structure. Will it be possible to directly parss the excel file itself?

    Secondly, while uploading, I am not using FTP, but a "browser" based PHP uploader. What extension should I add in order to allow uploading of excel file?

    Thankyou for any help in this matter. :)
    Bye
    jeet
     
    JEET, Nov 22, 2006 IP
  2. frankcow

    frankcow Well-Known Member

    Messages:
    4,859
    Likes Received:
    265
    Best Answers:
    0
    Trophy Points:
    180
    #2
    frankcow, Nov 22, 2006 IP
  3. TwistMyArm

    TwistMyArm Peon

    Messages:
    931
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Search pear.php.net for 'excel'. There's a few packages there that may help...
     
    TwistMyArm, Nov 22, 2006 IP
  4. JEET

    JEET Notable Member

    Messages:
    3,825
    Likes Received:
    502
    Best Answers:
    19
    Trophy Points:
    265
    #4
    Thanks, that looks promising, but also sounds very tough to use. I downloaded the binary, will try to install, but I am not sure if I can do that. ;)
    Anything else that might help?
    Thanks :)
    jeet
     
    JEET, Nov 22, 2006 IP
  5. frankcow

    frankcow Well-Known Member

    Messages:
    4,859
    Likes Received:
    265
    Best Answers:
    0
    Trophy Points:
    180
    #5
    frankcow, Nov 22, 2006 IP
    JEET likes this.
  6. JEET

    JEET Notable Member

    Messages:
    3,825
    Likes Received:
    502
    Best Answers:
    19
    Trophy Points:
    265
    #6
    Hi,
    I found these 3 packages:
    http://pear.php.net/search.php?q=excel&in=packages
    Which of these would be suited for reading from the spreadsheet file?
    Thanks :)
    jeet

     
    JEET, Nov 22, 2006 IP
  7. JEET

    JEET Notable Member

    Messages:
    3,825
    Likes Received:
    502
    Best Answers:
    19
    Trophy Points:
    265
    #7
    JEET, Nov 22, 2006 IP