1.26.2006
Excel For Systematic HTML???
I recently discovered an simple nonconventional use for the ever popular Microsoft Excel. I was given a list of names in excel and was told to put them on a website I help administrate. What better way is there to do it than to just have the list of names using an unordered list (
Working with on my dad's political campaign, I knew how usful the concatenation formula in Microsoft Excel was. (For those of you who don't know the fancy term, concatenation is simply using the "&" symbol to combine the data of two cells). Using this knowledge I took a shortcut to my list making. Below are instructions for using Excel to create symbol systematic HTML tags around a list of whatever you wish. Microsoft Excel is not nessicarily needed, you could always use something as Open Office but the formula may be slightly different.
Step 1: Gather List In Excel
Enter, Paste, Type, SpeakType, Whatever method you wish input your data into excel in a single colum.
Step 2: Print the tag you want, in this case
Step 3: Copy down the tags through Copy-Paste to all the list items
Step 4: Use the Concatenation Forumla, start in an empty row below your list and type
Step 5: Paste the HTML into a notepad file (or whatever HTML editor you wish) and then add the rest of the HTML.
I have since found many other uses for this. For example, I was trying to syndicate an RSS feed from news articles in a mysql database. MyPHPAdmin convientently exported the database to excel but I needed to add the RSS tags. I used a complex form of the method explained about to create it.
Hope this Helps someone somewhere code HTML. Perhaps someone used to a WYSIWYG editor will use this to do what the editor can't.
-Eric
<ul>)? Seemed easy enough for me. Unfortunatly I'm very very lazy. Luckily, my mind was working that day. Instead of me typing in "<li>" in front of every item and closing each item with "</li>." I was going to take the easy way out.Working with on my dad's political campaign, I knew how usful the concatenation formula in Microsoft Excel was. (For those of you who don't know the fancy term, concatenation is simply using the "&" symbol to combine the data of two cells). Using this knowledge I took a shortcut to my list making. Below are instructions for using Excel to create symbol systematic HTML tags around a list of whatever you wish. Microsoft Excel is not nessicarily needed, you could always use something as Open Office but the formula may be slightly different.
Step 1: Gather List In Excel
Enter, Paste, Type, SpeakType, Whatever method you wish input your data into excel in a single colum.
Step 2: Print the tag you want, in this case
<li> at the top of one empty colum (in this case we inserted a colum by right-clicking)Step 3: Copy down the tags through Copy-Paste to all the list items
Step 4: Use the Concatenation Forumla, start in an empty row below your list and type
=(A1)&(B1)&(C1)...etc. Once you have that down press enter, the complete first row should appear in one cell. Now take the little box in the corner of the cell when highlighted and drag it down the appropriate number of rows.Step 5: Paste the HTML into a notepad file (or whatever HTML editor you wish) and then add the rest of the HTML.
I have since found many other uses for this. For example, I was trying to syndicate an RSS feed from news articles in a mysql database. MyPHPAdmin convientently exported the database to excel but I needed to add the RSS tags. I used a complex form of the method explained about to create it.
Hope this Helps someone somewhere code HTML. Perhaps someone used to a WYSIWYG editor will use this to do what the editor can't.
-Eric
