Excel has the option to save a workbook as a web page and it builds the table with datawhich you can paste right into an html page:
Here's the original xls:
They aren't very different in layout at all.
There are also third party programs to do the conversion. I found one here: http://www.softinterface.com/Convert-XLS%5CFeatures%5CConvert-XLS-To-HTML-XML.htm
Here's a page where I did just that. I can't do any formatting or border changes. It just flows as it wants to with a lot of extraneous cells as I see yours does as well.
Thanks for the link. Its says windows only and I'm on a Mac. I could do a search for similar that works on Mac.
I just tried using Cushy CMS to see if updates on the table would take and they don't. They just destroy the formatting. So I really need to get the info into proper table cells. He needs to add and delete info on his own.
It exports with Style information. You can set borders for the table and choose cell background colors from there.
As far as the Cushy CMS.. Have you thought about using ICE (In Contect Editing) through Dreamweaver?
Once it's set up. your client(s) can access their own pages and make changes "on the fly".
I just played with several methods including creating the table in DW and CushyCMS isn't going to work. I need to allow him to add or subtract rows as well as edit what's there.
I'm not familiar with ICE. Is it simply for non tech clients to edit with that?
I'm on old DW4 and do coding by hand until I can upgrade to a later version.
You can use Excel as datasource for a dynamic site. It's not a good idea to use live as it has serious concurency problems. But what you can do is run the dynamic page locally and use the plain html it generates as your page html. I know you can use ASP or ASP.NET as your scripting language - not sure how easy this would be with PHP.
Unfortunately I don't know how to code for dynamically updated sites. Wish I did.