I've been hosting a Lava Orange MSM registry on my website for a while. My whole website was done via Notepad (yes, I am a dinosaur) with the exception of the registry. I've been using MS Excel for that. It has been a pain in the *** but I learned to deal with it. Since upgrading to Win8.1 and MS Office 10 (or maybe it was something with GoDaddy) I've been having tons of problems with the page and would like to try something else. So, does anyone here know how to make something that looks like this (see link below) with simple html commands. I'd rather not start using new software just for one page. Thanks!

http://www.lightweightmiata.com/kiki/registry/








...

 

continue editing in notepad for the table instead of excel.

you can see the format for a row in your table looks like this:

<tr height=28 style='mso-height-source:userset;height:21.0pt'> \\TR indicates a new row
. <td height=28 class=xl72 width=63 style='height:21.0pt;width:47pt'>470</td> \\TD indicates a new cell
. <td class=xl73>Frank</td>
. <td class=xl73>CDM, CA</td>
. <td class=xl73>SOCALM</td>
. <td class=xl74><a href="http://www.cardomain.com/ride/3038774"
target="_parent">http://www.cardomain.com/ride/3038774</a></td>
</tr>
\\I added the periods (.) in front of the <td> tags to show the spacing

Those rows are obviously Production Number, Name, Location, Club, and "other". Just add a new row underneath an old row.

 

Scary html is scary.

All you need is a simple table:
https://developer.mozilla.org/en-US/.../Element/table

It sounds like you don't want anything dynamic.. you are just looking for an easy way to transform your excel data into an HTML page?

One quick and dirty way to do this is to set up a formula in your excel sheet to build the HTML for the row (the TR tag). Assuming your spreadsheet has two columns, you would enter a formula in the third column that looks something like this:

= CONCATENATE("<tr><td>", A1, "</td><td>", A2, "</td></tr>")

Then fill down, select all cells in that column, copy, and paste into a table tag in your html document in notepad.

Of course, only a crazy person would actually maintain a web page this way in 2014....

 

A little CSS can make a simple table look much nicer

Also, black backgrounds are not cool, imo.

 

this should be created in wordpress with a plugin to allow "members" to sign up and add the info of their cars in a dynamic, non-shitty, way.

 

I am not familiar with Wordpress. Any idea which plugin would give me a similar format to what I have? As it is now, I get data from a thread on miata.net. No hassle of user signup (people are lazy, they won't sign up) and no hassle of people putting VAGINA, CA for their location. Yes, I have to type everything in but we are only talking about 5 minutes a month work on it (not many LO MSM owners out there).

 

<style>
#html {-moz-border-radius: 25px;
-webkit-border-radius: 25px;
border-radius: 25px;
-moz-box-shadow: 0px 0px 7px #000000;
-webkit-box-shadow: 0px 0px 7px #000000;
box-shadow: 0px 0px 7px #000000;
filter: progid:DXImageTransform.Microsoft.gradient(startCo lorstr = '#fff71a', endColorstr = '#ff08bc');
-ms-filter: "progid:DXImageTransform.Microsoft.gradient(startC olorstr = '#fff71a', endColorstr = '#ff08bc')";
background-image: -moz-linear-gradient(top, #fff71a, #ff08bc);
background-image: -ms-linear-gradient(top, #fff71a, #ff08bc);
background-image: -o-linear-gradient(top, #fff71a, #ff08bc);
background-image: -webkit-gradient(linear, center top, center bottom, from(#fff71a), to(#ff08bc));
background-image: -webkit-linear-gradient(top, #fff71a, #ff08bc);
background-image: linear-gradient(top, #fff71a, #ff08bc);
-moz-background-clip: padding;
-webkit-background-clip: padding-box;
background-clip: padding-box;
text-align: center;
font-family: verdana;
padding: 10px;
width: 100px;}
</style>


<div id="html"><span>**** html.</span></div>


please publish this.

 

Will do. Woke up this afternoon (working weird hours) and laptop was dead. Doing backups, etc now. Will put the code up today and take a look. Thanks!

 

lol.

 

Post a reaction video of when you first publish it.

 

it's not that great, i just made a pretty rounded edge box for my text.

Edit fiddle - JSFiddle

 

Thats a neat little tool

I need to stop being a masochist when writing html/css

 

This is not an upgrade, HTH