I have several excel tables I want to put onto some of my pages, displayed as a table. I do not want to hand jam all the records or do hundreds of copy paste operations. I am not looking for a database solution.
Solved! Go to Solution.
Well found my answer messing around.
I saved the excel spreadsheet as a web page. I was able to play with formatting in excel and save most of the changes to html. I opened the web page saved to my local system in chrome and viewed the frame source. I selected from the first table tag to the end table tag. I used the html code option from the website builder menu and then pasted my table code from the frame source. Bingo a nicely formatted table in my page with minimal effort.
I applaud your elegant solution. I was appalled when I discovered upon upgrading for 6 to 7 that my ability to simply drop an excel spreadsheet into a content box no longer worked.
Now I did have to edit the HTML in the settings to get column widths set, borders to show, and make column headers bold but that's not such a big deal.
I think Go-Daddy owes you money because without your council they would have lost a customer.
I too applaud the solution. I tried it, and it worked great. I saved my table in Excel as an *htm, opened in in Chrome, right clicked to view the pop-up "view page source" and then copied and pasted all the html coding, from top-to-bottom. Bingo. And whew, what a relief! Thanks for the help!
I went through the process of saving my Excel File as htm.
I then copied from the first instance of table ( <table border=0 cellpadding=0 ) until the last instance ( </tr>
I pasted that in the HTML block but nothing at all happens.
Any ideas please?
I fixed the problem by saving my excel file as HTML. I had to do some clean up using a text editor and some internet study of HTML coding to get it formatted the way I wanted. Then, in the GoDaddy editor, I would insert a HTML widget on the page and then copy the HTML text from the text editor and then paste it into the widget. This is a more trouble than it used to be but it works. Hope this helps to get you going in the right direction.