4 ms·
The first "dynamic" website I ever built, circa 1998, was powered by an Excel spreadsheet. It was for an online gaming league, and I needed a fast way to create
by simonw 11y ago
The first "dynamic" website I ever built, circa 1998, was powered by an Excel spreadsheet. It was for an online gaming league, and I needed a fast way to create HTML pages with the various league tables on them.
The way I built it was to represent my information in spreadsheet cells, then add a final column with a formula that concatenated together a string of HTML using the content of the cells in that row to create a <tr><td>...</td><td>...</td></tr> chunk of HTML.
Then I just had to "fill down" the formula, then copy and paste the resulting lines into the "PASTE HTML HERE" section of my HTML page and FTP it up to the server.
It worked surprisingly well. So much so in fact that I reused the same technique with a Google Sheet for a small internal web page just a few weeks ago.