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.
Thanks,
Mike
greyisgood
Member
Posted 1 year 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.
clockworkoranje
Member
Posted 11 months 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.