Welcome to European Tribune. It's gone a bit quiet around here these days, but it's still going.
What's the best way to convert an Excel table for use here?

paul spencer
by paul spencer (paulgspencer@gmail.com) on Sun Mar 16th, 2008 at 10:09:08 PM EST
do you want to use the data or is it ok as a graphic?

Any idiot can face a crisis - it's day to day living that wears you out.
by ceebs (ceebs (at) eurotrib (dot) com) on Sun Mar 16th, 2008 at 11:01:25 PM EST
[ Parent ]
Excel 2003 can save as a web page ; open the resulting file with notepad, and copy/paste everything within the table tags.

Un roi sans divertissement est un homme plein de misères
by linca (antonin POINT lucas AROBASE gmail.com) on Mon Mar 17th, 2008 at 04:32:56 AM EST
[ Parent ]
In Excel:
  1. Select the bit of your spreadsheet you would like to post.
  2. File->Save As...
  3. In the drop down list at the bottom of the dialog labeled Save as type:, select Web page(*.htm; *.html)
  4. Two radio buttons will appear, Entire Workbook and Selection. Choose Selection. Name your file and save.
In Firefox (or other webbrowser):
  1. Open the file you just saved
  2. select the table
  3. If you have TribExt installed, press Ctrl+Shift+C
  4. Else, right-click, and View selection source, expand your selection to include the first <tr...> and last </tr>, be sure not to include the <tbody>,then copy with Ctrl+C
  5. Past into EuroTrib posting textbox
  6. Cleanup time! The output from TribExt may include a x: in the <td...> elements. (fixed in next version...) Remove them.
  7. If you copied from the selection source, you may have to remove some x:num="" from the <td...> elements. Also, add <table style="border-collapse: collapse; font-size: 100%;" border="1px" cellpadding="0" > and </table> tags around your table elements. If you don't want borders, set border="0px" in the <table...> tag.
  8. Preview and post!
And you get something like:

n 1 2
m 2 2
by someone (s0me1smail(a)gmail(d)com) on Mon Mar 17th, 2008 at 04:59:37 AM EST
[ Parent ]
I reformatted your table using the HTML <pre> tags for pre-formatted text, which displays in single-width font and respects explicit whitespace...

I suggest saving the Excel table as "comma separated values" with "tabs" as separators and "fixed width" fields (to be padded with spaces). That will produce a text file which will be easiest to copy and paste into the <pre> block.

It'd be nice if the battle were only against the right wingers, not half of the left on top of that — François in Paris

by Carrie (migeru at eurotrib dot com) on Mon Mar 17th, 2008 at 05:49:52 AM EST
[ Parent ]
I'm afraid I don't have the money/time combination (esp. time.  I'm tied up most weekends) working in sync for any extra trips away from my home base for the next year.  I would come if I could, though!

Don't fight forces, use them R. Buckminster Fuller.
by rg (leopold dot lepster at google mail dot com) on Mon Mar 17th, 2008 at 06:26:30 AM EST
[ Parent ]
(oops!  Attached this to the Excel comment by mistake.)

Don't fight forces, use them R. Buckminster Fuller.
by rg (leopold dot lepster at google mail dot com) on Mon Mar 17th, 2008 at 06:26:58 AM EST
[ Parent ]


Occasional Series