1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Update an excel file?

Discussion in 'HTML & JavaScript' started by openaidbh, Mar 16, 2012.

  1. openaidbh

    openaidbh BANNED BANNED

    Joined:
    Mar 3, 2012
    Messages:
    328
    Likes Received:
    320
    I need to update an excel file from my webpage; mainly because I don't feel like learning how to deal with SQL database nonsense. I figured it would be easier just to post to an excel spreadsheet hosted on a protected server. So I will need to be able to authenticate with the password-protected host, then edit the Excel spreadsheet, whenever a user registers, logs in, or completes an offer.

    Would I be doing this in HTML? JavaScript? CSS? I'm not new to programming but I'm new to web design so any advice would be greatly appreciated. Also, if anyone wants to do this job for a quick $20, let me know.
     
  2. jazzc

    jazzc Moderator Staff Member Moderator Jr. VIP

    Joined:
    Jan 27, 2009
    Messages:
    2,490
    Likes Received:
    10,270
    You figured wrong.
     
  3. openaidbh

    openaidbh BANNED BANNED

    Joined:
    Mar 3, 2012
    Messages:
    328
    Likes Received:
    320
    So a database would be easier?
     
  4. tripper_john_md

    tripper_john_md Newbie

    Joined:
    Feb 21, 2011
    Messages:
    40
    Likes Received:
    35
    Location:
    Southern Germany
    Best answer ever... :D

    Yeah, a database would be much easier. You don't need much knowledge to set up, read from and write to a database, neither in SQL nor in, for example, PHP.

    I've worked with excel files lately, but I only imported data from the spreadsheet to my database. I would never ever use it to store data the way you want it to do.
    If it's just for logging, you could use a text file. If you want to work comfortably with the data, use a database. It's not called "database" without reason. :)
     
    • Thanks Thanks x 1
  5. ADHD-Dude

    ADHD-Dude Power Member

    Joined:
    Apr 17, 2010
    Messages:
    592
    Likes Received:
    119
    Use mysql it is easier that updating a .xls on a server, you can do what you want with PHP an PEAR and on windows with COM object.

    Go with
    mysql is fast and easy
     
  6. kvmcable

    kvmcable Supreme Member

    Joined:
    Dec 28, 2010
    Messages:
    1,355
    Likes Received:
    2,818
    Occupation:
    24 year business owner - old school dude
    Location:
    KFC - BW3
    Just use phpMyAdmin or find a copy of Navicat. Allows you to import and export spreadsheets or just find tables you need data from and update in seconds.