Results 1 to 3 of 3

Thread: Entering data in html table

  1. #1
    Join Date
    Jan 2011

    Entering data in html table

    Hi all. I'm trying to write an online application which will take user data and plot a simple histogram. I've decided that the best way to do this is via html5's canvas element (for the histogram drawing), but I'm not sure how best to accept the user's data. Ideally, an excel-like table would be good. It'd be awesome if the user could copy data from an excel file (or .ods spreadsheet) into the webpage, then using javascript, I could update the histogram based on that data. I think this would be the best user interface for the project. I know I could set up a table with <input> fields in each cell, but I don't think that would accept copying from excel.

    I know it's possible, cause google docs' spreadsheet app does it. I just don't know how difficult it will be. Does anyone have any ideas?

  2. #2
    Join Date
    Nov 2002
    Baltimore, Maryland
    If you really want to read from Excel then there are two not so bad ways to go. If you really want to do this client side then use an HTA (HTML Application). That will only run in MSIE but with all the security down so it can read files. Better would be to have them upload the Excel to a server side script. As long as your server is running Windows and has the Jet and Excel installed then reading the files would be a snap.
    “The power of the Web is in its universality. Access by everyone regardless of disability is an essential aspect.”
    —Tim Berners-Lee, W3C Director and inventor of the World Wide Web

  3. #3
    Join Date
    Jan 2011
    Hi Charles, thanks for the reply! I'm trying to keep this as platform independent as possible, so I don't really like any of your suggestions (sorry). I also want it to be as drag 'n' drop friendly and copy/paste friendly as possible.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

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