Edit: How do I pull Excel values and embed it in a webpage?

[Imaginer]

I have a list of names and addresses and years and I would like to sort it by year and output it to an HTML format with each page representing a year. How can I get a big excel worksheet to an HTML output in the most SIMPLEST way possible?

Edit: How can I get it to where I can pull excel values onto a webpage? Is there an XML code that allows me to do so? Like for instance, with the large single excel file, after I sorted the data, I would like to pull specific values based on how I sorted it and put those values only on a webpage.

I hope this does not seem too confusing.

 

[anxman69]

Do whatever data manipulation that you need to do (ie: sorting by year) and then click File -> Save As -> HTML Document. I believe every version of Office above Office 2000 has such a feature.

-Ankur

 

[Eli]

I've only used Excel a few times, and I knew about that menu option.

 

[yobarman]

Originally posted by: Eli
I've only used Excel a few times, and I knew about that menu option.

haha for real, it took me ONE time to figure this out when i was making my schedule for classes. geez people mess around with program for 5 minutes before you ask a newbie question!

RTFM!~

edit: didnt read the post so this probably doesnt apply anymore, but still RTFM!

 

[Imaginer]

Ok I guess I need to make myself a bit more clearer.

I know how to make an entire excel worksheet to a html page. Thats not hard. But I just want to pull specific values and embed it into an existing HTML page.

 

[Imaginer]

^

 

[Imaginer]

Someone on here must have an answer.

 

[notfred]

This can do it. But it's going to scare you and you're not gonig to try it, and you're going to end up copying and pasting from the excel file.

 

[rayray2]

Originally posted by: Tyler
This can do it. But it's going to scare you and you're not gonig to try it, and you're going to end up copying and pasting from the excel file.

:Q

 

[Imaginer]

Originally posted by: Tyler
This can do it. But it's going to scare you and you're not gonig to try it, and you're going to end up copying and pasting from the excel file.

heh going to read it now.

bring it on.

 

[Electric Amish]

Originally posted by: Tyler
This can do it. But it's going to scare you and you're not gonig to try it, and you're going to end up copying and pasting from the excel file.

Ahh, it takes Tyler to post for me to even think about Perl! DOH!

You could save the excel sheet as CSV then write a quick Perl script that will parse it and write it to a webpage.

amish

 

[loup garou]

What about importing it into an Access database and making data access pages?
I'm not really clear on what you want to do. Are these pages going to be dynamic at all?

 

[Imaginer]

It will be eventually dynamic.

But I do not have much experience with access, can anyone give some quick tips?

nm, I think i figured access. Its just now a matter of pulling values from access instead.

 

[silverpig]

Sorta...

 

[silverpig]

I'm actually looking for something sorta like this too... I've got a product list that has a column of empty values for the quantity wanted. I want to be able to read that column, and then print the row only if there is a value in the quantity column...

 

[Imaginer]

Ok, I figured what I really need.

I need a drop down menu where I select something like a year. Then from that, the page will display any information that has that year such as names and emails. It would pull the information from a database where if you edit the database, you can change what the page displays.

Is there a way to do this without reconverting the database everytime someone edits the information?