How to copy Excel Tables with formatting/colors? (3 posts)

  1. gariben
    Posted 8 years ago #

    I have a bunch of Excel with colorful headers/color rows and columns.

    Whenever I copy and paste the table to WordPress page or post, it loses all of the formatting. Only the data gets copied over.

    Does anyone know how to copy the data AND the formatting?

    To show an example, Ideally, I want the tables/values to look something like the "Tabular Data" as in http://wpremix.com/demo/?page_id=188

    Any help is greatly appreciated.


  2. noname1
    Posted 8 years ago #

    it is correct that happens.

    tables in html are either constructed in html or via CSS

    you may be able to export from excel to html and paste that code into the html pane on wp. certainly not the best way to do it.

  3. clockworkoranje
    Posted 7 years ago #

    I've been trying to do this as well. I've had a lot more luck by using Open Office instead of Excel. Turn your Visual Editor on and paste from Open Office into the WordPress post window (set to Visual). Keeps font, size, background colour, only thing missing appears to be cell borders.

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.