For many months I have been wanting to add a large table to my site. It would have well over 100 rows, six columns and include hyperlinks to pdf documents. It is a reference table and I'd need four versions of it in different sequences and it must have universal access. I was not looking forward to maintaining this as an HTML table.
My first thought was a Google docs spreadsheet and I completed a working version only to find that Google docs does not allow universal access to .pdf's. Back to the drawing board!
The table I need is easy to create in Excel but saving it as an HTML file did not work although the approach was promising. I then found a set of Excel tools which solved the problem. The solution, http://www.asap-utilities.com/ is a collection of a couple of hundred tools to manipulate data in an Excel worksheet. It appears as a button on the Excel toolbar and it's free to the non-commercial user.
One of the tools (Export -> HTML file) converts part or all of a worksheet to a perfect HTML table and places the HTML code in the windows clipboard. Then by using the Snippet or HTML tools in the Wild Apricot Edit web page you can paste the entire table into the web page. .
This process is so good and so quick that I'm moving all my tables back to Excel and maintaining them there and just port the HTML code to Wild Apricot as needed. There is no need to maintain or even look at the HTML code. When modifying a table, I do have to delete the old HTML version, but that's a small price to pay. I've not found any Excel feature that is not faithfully reproduced in the HTML table.
You can see the tables I created this way are at www.srcc.memberlodge.com/archive . This has satisfied my need for a table maintenance tool.
Gordon