WordPress.com is an easy way to start blogging. Get a blog, check out our features, read the latest announcements, choose from great themes, or learn about the team behind it.
Need help? Check out our Support site, then
Hi,
Does anyone know how to get an MS Excel generated table into a post with the layout and formatting intact.
I've tried all sorts of things, including converting the table Word, then to tab-delimited text, and even an HTML file. Nothing works yet.
Thanks
George
(a.k.a. Allocator)
this is my newbie trick. show the print preview of the table, press the print screen button on your keyboard, copy it to paint, save it as a jpeg, and upload it to your post as a picture. when you copy it to paint, you can also adjust the size so that you can have it as large as you want or shrink it to fit the layout of your blog.
Actually I would think the HTMl tab should work. Unless excell is putting in style tags and javascripts.
Did you put a BORDER="1" tag in the first line of the code?
Eg. <table BORDER="1" CELLPADDING="4" ALIGN="center" BGCOLOR="#ff0000">
If you don't include the BORDER tag, the table framing lines will not appear, only the contents of the table.
The other tags are optional: CELLPADDING, ALIGN, BGCOLOR.
If you want a white background, leave out the BGCOLOR tag altogether. The default is white or whatever background color you normally have (I think).
Copying the HTML code is the best way if you can get the HTML source page. You might have to add BORDER="1" tag to the table tag though if frame lines don't appear.
Eg. <table BORDER="1">
If you can't access the source code and have to make the tables from scratch, use the <tr> (row) and <td> (column) tags to make as many rows and columns as you want. Enclose them within the table tag. Nest the td tags within the tr tags.
Essential tags are <table BORDER="1">, <tr>, and <td> tags. Everything else is optional including background color, cell padding and alignment.
Just for clarification:
In html, <table>, <tr> and <td> are all tags, for example. However, BORDER, CELLPADDING, CELLSPACING, ALIGN and so on are all called attributes, and some of these attributes shouldn't really be used, especially if styles within a theme are already in place.
This may be useful if you start looking around on other websites/forums for further help.
That didn't work exactly how I wanted, but it helped. :)
My situation is:
I need to type in a list of irregular verbs.. hehe.
I got it ready in Word. But simply copying and pasting it won't work.
I am having to retype it all.... number by number, word by word... following this structure:
<table style="font-size: 10pt; font-family: 'Lucida Sans Unicode'; color: navy" border="1" cellpadding="1" cellspacing="0" width="400">
<tr>
<th>#</th>
<th>TITLE 1</th>
<th>TITLE 2</th>
<th>TITLE 3</th>
</tr>
<tr>
<td>#.</td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
If anyone has a better, more practical solution, please, let us know. ^^
Kindly,
Lilli Zen.
since you've mentioned MS Word, chances you'd like to download from MS their Windows Live Writer.
copy/paste from Word into WLW.
alternatively, search for the 'Post2Blog' (also freeware), it can do tables (and many more) as well, and even has the Word toolbar, AFAIR. so you won't even need a copy-pasting fest.
HTH
Click these and scroll down for the download links
post2blog
Windows Live Writer
I've had to create a couple tables and did so easily in WLW, then copied the code from there and pasted it into the code tab in our editor. Works well.
One way to create tables or use certain html is to switch the editor off.
Users > My Profile > uncheck the visual editor.
Now do what you need (with the tags we allow)
Save, preview, publish until you are happy.
After you publish though you cannot edit that post with the visual edit on.
It will break it, really it will.
Using the Code tab does not give the same result.
This topic has been closed to new replies.
allocator
drmike
bobtailcat
zephyravictrix
lillizen
mark