/    Sign up×
Community /Pin to ProfileBookmark

Pull data from Excel into an HTML table

Copy linkTweet thisAlerts:
Jun 29.2012

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.

to post a comment
HTML

8 Comments(s) ↴

Copy linkTweet thisAlerts:
@jedaisoulJun 29.2012 — 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?
Copy linkTweet thisAlerts:
@NeedHTMLhelpauthorJun 29.2012 — 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.
Copy linkTweet thisAlerts:
@jedaisoulJun 29.2012 — 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.
Copy linkTweet thisAlerts:
@CharlesJun 29.2012 — 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.
Copy linkTweet thisAlerts:
@collins_hallNov 20.2012 — An Excel Web query allows you to bring data from a Web site into an Excel worksheet.
Copy linkTweet thisAlerts:
@nagarajhubliFeb 01.2013 — Mr. Data Converter will help you out here - http://www.shancarter.com/data_converter/index.html
Copy linkTweet thisAlerts:
@waxdocFeb 01.2013 — 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. [/quote]
Copy linkTweet thisAlerts:
@seoproFeb 02.2013 — Well, I can put data HTML table but can not move data from excel sheet to HTML table.
×

Success!

Help @NeedHTMLhelp spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.5,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,

tipper: @Samric24,
tipped: article
amount: 1000 SATS,
)...