Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to export Excel spreadsheet to HTML table with INLINE CSS?
    primarykey
    data
    text
    <p>I'd like to know how to get the table in my spreadsheet into html format without all the microsoft specific code. Our webpage is hosted elsewhere which means I don't have access to the <code>&lt;head&gt;</code> part of our pages. We can only insert content into the <code>&lt;body&gt;</code>. I just want the table to retain the same fonts, borders and formatting with any and all CSS styling included directly in the table code not elsewhere.</p> <p><strong>EDIT:</strong></p> <p>It actually appears to work if I put the CSS classes in the <code>&lt;body&gt;</code> of my document. Is that legal? I thought those were supposed to be defined in the <code>&lt;head&gt;</code>???</p> <pre><code>&lt;body&gt; &lt;style type="text/css"&gt; table.mytable { border: 1px solid #CCC; font-family: Verdana, Verdana, Geneva, sans-serif font-size: 12px; } </code></pre> <p><strong>EDIT:</strong></p> <p>I have found that copying in Excel and pasting into the Live View in Dreamweaver creates much cleaner html than saving as html in your spreadsheet. You are still left with a bajillion CSS classes that you have to edit out but it's at least it's a step closer.</p> <p>If you get an error message whilst pasting a large table in Dream Weaver see <a href="http://www.jdhodges.com/blog/dreamweaver-document-too-large-copy-past/" rel="nofollow">this page</a>.</p> <p><strong>FINAL EDIT:</strong></p> <p>Before you export your table to any html editor go through ALL of the cells in your table with the format painter. Using this tool make sure you paint the format of every similarly formatted cell. That way you won't get a million different CSS classes for cells that should have a particular format. It will make your life a hell of a lot easier particularly if your table is large and detailed. </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload