Excel Tables on Websites

[Reephdweller]

Is there an easy way to take a table with data created in Microsoft Excel and paste it within a webpage?

I created a employee list for work which has all the employees listed alphabetically, with their extensions, hours, etc which will be really useful for the office, but I can't paste the data into a webpage without all the data in the cells of the spreadsheet getting pasted into one cell on the webpage?

<center><IMG SRC="http://www.chaoticconcepts.com/randomizer/random.php?uid=3">
Reefy's website... (http://www.osirusonline.com/)</center>
<font size="1" color="red">
<center>Check out The Ron and Fez Show Logs...UPDATED!!!!! (http://www.osirusonline.com/ronfez.htm)</center>
<marquee behavior=alternate bgcolor="#FFFFFF">Right now you could care less about me...
but soon enough you will care, by the time I'm done</marquee> </font>

[JPMNICK]

Which program are you using?


http://home.comcast.net/~nickcontardo/jpm_sig.jpg
Thanks to Monsterone for my first sig.

[JPMNICK]

I can do it for you if you send me the table. I use Frontpage and you can import the excel table.

http://home.comcast.net/~nickcontardo/jpm_sig.jpg
Thanks to Monsterone for my first sig.

This message was edited by JPMNICK on 4-1-04 @ 3:00 PM

[angrymissy]

Go into excel and select

File -- Save as webpage

It will save it as html. you could then view the relevant code and paste it into your editor

<BR><img src="http://thereisnogod.faithweb.com/images/missy2.gif" width="300" height="100" border="1">

This message was edited by angrymissy on 4-1-04 @ 2:48 PM

[Reephdweller]

I was intially trying to do it in Dreamweaver, though Frontpage is a little more friendly with it.
But for some reason, some cells won't center or the formatting won't change no matter what I do
with it.

Also, I tried to save as a webpage, and while it does do that, I also get lots of trouble playing with the formatting in either Front Page or Dreamweaver.

<center><IMG SRC="http://www.chaoticconcepts.com/randomizer/random.php?uid=3">
Reefy's website... (http://www.osirusonline.com/)</center>
<font size="1" color="red">
<center>Check out The Ron and Fez Show Logs...UPDATED!!!!! (http://www.osirusonline.com/ronfez.htm)</center>
<marquee behavior=alternate bgcolor="#FFFFFF">Right now you could care less about me...
but soon enough you will care, by the time I'm done</marquee> </font>

[Reephdweller]

Also, in case it matters, I'm using Excel 2000 and Frontpage 2000. Is the 2003 version of these programs better for doing this?

<center><IMG SRC="http://www.chaoticconcepts.com/randomizer/random.php?uid=3">
Reefy's website... (http://www.osirusonline.com/)</center>
<font size="1" color="red">
<center>Check out The Ron and Fez Show Logs...UPDATED!!!!! (http://www.osirusonline.com/ronfez.htm)</center>
<marquee behavior=alternate bgcolor="#FFFFFF">Right now you could care less about me...
but soon enough you will care, by the time I'm done</marquee> </font>

[JPMNICK]

Have you ever used the paintbrush formatter in word or excel? You can try using a cell that works fine, and using the formatting paintbrush in the other cells that are giving you a problem. Maybe this will help. Sometimes is meta formatting that is the problem.

http://home.comcast.net/~nickcontardo/jpm_sig.jpg
Thanks to Monsterone for my first sig.

[JustJon]

The prob is any microsoft program will add lots of garbage html. Try to do all your formatting in Excel then save as webpage. I have Office XP at home that I've done it with.

<img src="http://www.chaoticconcepts.com/bans/rfjustjon11.gif"><BR><A href="http://www.chaoticconcepts.com">Chaotic Concepts</a>

[Reephdweller]

The prob is any microsoft program will add lots of garbage html. Try to do all your formatting in Excel then save as webpage. I have Office XP at home that I've done it with.


That's what I was doing, but I'm using Office2k at work. I may have to upgrade it Office XP.

<center><IMG SRC="http://www.chaoticconcepts.com/randomizer/random.php?uid=3">
Reefy's website... (http://www.osirusonline.com/)</center>
<font size="1" color="red">
<center>Check out The Ron and Fez Show Logs...UPDATED!!!!! (http://www.osirusonline.com/ronfez.htm)</center>
<marquee behavior=alternate bgcolor="#FFFFFF">Right now you could care less about me...
but soon enough you will care, by the time I'm done</marquee> </font>

[JPMNICK]

It can def. be done in 2k. Do not spend the money on the upgrade unless there are more reasons. Did the paintbrush thing work?

http://home.comcast.net/~nickcontardo/jpm_sig.jpg
Thanks to Monsterone for my first sig.