www.webdeveloper.com
Results 1 to 9 of 9

Thread: Pull data from Excel into an HTML table

  1. #1
    Join Date
    Jun 2012
    Posts
    2

    Pull data from Excel into an HTML table

    I am pretty new to HTML, so I'd appreciate any answers to be well explained.

    I created an HTML table on my company's website and am trying to populate one of the columns with numbers from specific cells in an Excel worksheet. For example, I would like the bottom right value in the HTML table to display the number in cell C3 from "Sheet1" in the Excel document.

    I know how to create an HTML table already, so I really only need the script that would be placed in betweed the <TD></TD> tags.

    Does anybody know how to do this?

    Thanks.

  2. #2
    Join Date
    Mar 2012
    Posts
    917
    There is no such function in HTML. You might use JavaScript or PSP, but the problem is accessing the data from Excel. You could export it in CSV format, and read that in, but I suspect you were looking for a slicker solution?
    Last edited by jedaisoul; 06-29-2012 at 02:58 PM.

  3. #3
    Join Date
    Jun 2012
    Posts
    2
    You could say that. I was not sure what the limits of HTML were. Do you have any recommendations in particular? Or, if you happen to have any outside sources I could look at, those would both be very helpful.

    Thanks again.

  4. #4
    Join Date
    Mar 2012
    Posts
    917
    The only way I know of doing this is via a csv file. That said, there may well be a better solution, I've just never had the need of one.

  5. #5
    Join Date
    Nov 2002
    Location
    Baltimore, Maryland
    Posts
    12,270
    I do this all the time. Excel is often the only way that I can get people to send me data. If your server is running on a windows box and it has Microsoft Office installed and i you have some server side scripting that can communicate with Office, PHP does a nice job, then it's 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

  6. #6
    Join Date
    Nov 2012
    Posts
    4
    An Excel Web query allows you to bring data from a Web site into an Excel worksheet.

  7. #7
    Join Date
    Feb 2013
    Posts
    1
    Mr. Data Converter will help you out here - http://www.shancarter.com/data_converter/index.html

  8. #8
    Join Date
    Feb 2007
    Location
    New York, NY
    Posts
    27
    Learn something new: CSV?

    Found http://8help.osu.edu/1701.html
    What Is CSV? / Converting Spreadsheet Data To CSV Format

    CSV stands for Comma Separated Values, sometimes also called Comma Delimited. A CSV file is a specially formatted plain text file which stores spreadsheet or basic database-style information in a very simple format, with one record on each line, and each field within that record separated by a comma. It's important that the individual "records" within a CSV file NOT contain commas, as this may break the simple formatting when using the file in another application.

    CSV files are often used as a simple way to transfer a large volume of spreadsheet or database information between programs, without worring about special file types. For example, transferring a home-made address book from Excel into a database program such as Filemaker Pro could be done by exporting the file as a CSV from Excel, then importing that CSV into Filemaker.

    Creating a CSV file from spreadsheet data is very simple to do using Microsoft Excel.

    Open your spreadsheet document and go to the File pull-down menu (or the Windows/Office round button menu in Office 2007), and choose Save As....
    Change the "Save as type" or "Format" field to read: "CSV (Comma delimited)".
    Enter a name for the document and click Save.
    To check the validity of your CSV file, open the new file from a plain-text reading program such as Notepad or TextEdit. Check to make sure there are no extra commas, other than between fields. Depending on what program you're going to use the CSV file with, you may need to also remove any extra quotation marks or other formatting which Excel may have inserted.

  9. #9
    Join Date
    Jan 2013
    Location
    Zurich
    Posts
    5
    Well, I can put data HTML table but can not move data from excel sheet to HTML table.

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



Recent Articles