Using Excel as a Content Management System

200 million people are proficient in Excel. Companies everywhere have data in Excel and many staffers who are comfortable in maintaining that data. Rather than force these people to learn how to create HTML pages, why not build a content management system to take their Excel data and write out custom Web pages?

Figure 14.13 shows a typical membership database. We had a Web designer offer to build an expensive php database on the Web to display the membership directory and allow maintenance of members.

The organization is already maintaining this data in Excel. Using the code from Figure 14.12, you pretty much know the top and bottom portions of the HTML needed to render the Web page.

Figure 14.13

Companies everywhere are maintaining all sorts of data in Excel and are comfortable updating the data in Excel.Why not marry Excel with a simple bit of VBA so that custom HTML can be produced from Excel?

E Microsoft Excel - SiteEngine.xls täj Els Edit View Insert Fafmät Iools Bäta ÜJrnfaw iiek

Was this article helpful?

0 -2

Post a comment