Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Senior Coder jcdevelopment's Avatar
    Join Date
    Oct 2007
    Location
    Cowboy Nation
    Posts
    2,179
    Thanks
    174
    Thanked 257 Times in 257 Posts

    Updating an Excel sheet through a web page

    I have a client who wants to have an excel sheet updated through the web page.

    He has a form where there are "20 seats" available to users. Once one person signs up that seat is filled, and the persons name needs to be updated to the excel sheet.

    What is the best way to approach this?

    Is there a program that can achieve this or will this be a PHP thing?

    Thanks for any help!

  • #2
    Regular Coder
    Join Date
    Oct 2008
    Posts
    214
    Thanks
    5
    Thanked 22 Times in 22 Posts
    I don't think PHP can handle XLS out of the box but I'm sure there is a lib somewhere that can add this functionnality.

    What I know is that PHP can easily handle CSV files (see http://docs.php.net/manual/en/function.fputcsv.php). CSV can then been handled in Exel pretty much like an XLS...

  • #3
    Senior Coder tomws's Avatar
    Join Date
    Nov 2007
    Location
    Arkansas
    Posts
    2,644
    Thanks
    29
    Thanked 330 Times in 326 Posts
    Didn't you have something else with PHP and Excel a few months back? You need to start running away from the Windows clients.

    Bottom half of page 2 might help: http://www.theregister.co.uk/2007/12...orts_with_php/

    EDIT: Actually, that's the writer. Here's a link to the Excel reader. http://sourceforge.net/docman/displa...group_id=99160


  •  

    Posting Permissions

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