Post new topic Reply to topic  [ 8 posts ] 
Author Message
 Post subject: Posting Tables from Excel
PostPosted: Wed Dec 01, 2010 12:22 am 
Offline
Under CAB Investigation

Joined: Feb 9, 2007
Posts: 2358
Location: Still Awaiting The Pearly Gates
How does one do this?

Advice appreciated


Top
 Profile  
 
 Post subject: Re: Posting Tables from Excel
PostPosted: Wed Dec 01, 2010 10:30 am 
Offline
IMF'd

Joined: Sep 13, 2007
Posts: 31690
Location: Tullamore
Two options:
Take a picture capture and put it on an image site and link to it using [ img ] tags.

Copy and paste the data into a notepad type program (I use context programmers editor, free to download).

Adjust as required so everything lines up.
Convert tabs to spaces.

Cut and paste onto the 'pin and enclose in [ code ] tags.

_________________
"It is impossible to design a system so perfect that no one needs to be good."

So long and thanks for all the fish.


Top
 Profile  
 
 Post subject: Re: Posting Tables from Excel
PostPosted: Wed Dec 03, 2014 10:54 pm 
Offline
Of Systemic Importance
User avatar

Joined: Aug 20, 2009
Posts: 5103
Bump.

Any further options on this?

Every month I haver a few Excel tables which I end up manually re-writing in a post and they don't look as good.

I've tried the Code version above, which works but only one font type and colour, not as easy to read, etc

I've googled it and going to File>Web Page Preview>then right click and select View Source.

This gives you the html code if it's allowed on the message board and know what you're doing. Answer is No to both of them for me!


Top
 Profile  
 
 Post subject: Re: Posting Tables from Excel
PostPosted: Thu Dec 04, 2014 3:27 am 
Offline
Nationalised
User avatar

Joined: Apr 1, 2010
Posts: 10550
TheJackal wrote:
Bump.

Any further options on this?

Every month I haver a few Excel tables which I end up manually re-writing in a post and they don't look as good.


Try the image hosting approach:

Image

(You can always provide a separate link to the raw data on PasteBin or G.Drive etc. if you want)

_________________
"Prediction is very difficult, especially about the future" – Niels Bohr


Top
 Profile  
 
 Post subject: Re: Posting Tables from Excel
PostPosted: Thu Dec 04, 2014 8:36 am 
Offline
Too Big to Fail

Joined: Aug 23, 2008
Posts: 3540
Location: Bogtrotterland!
ps200306 wrote:
TheJackal wrote:
Bump.

Any further options on this?

Every month I haver a few Excel tables which I end up manually re-writing in a post and they don't look as good.


Try the image hosting approach:

Image

(You can always provide a separate link to the raw data on PasteBin or G.Drive etc. if you want)

Nice summary there. ;)

_________________
"Democracy is like sausage, you want it, but you don't want to know how it is made". [John Godfrey Saxe]
Ronald Coase, Nobel Economic Sciences, said in 1991 “If we torture the data long enough, it will confess.”
"Give me control of a nation's money and I care not who makes it's laws" — Mayer Amschel Bauer Rothschild
"To be precise, my mistake. Humans are underrated": Elon Musk


Top
 Profile  
 
 Post subject: Re: Posting Tables from Excel
PostPosted: Thu Dec 04, 2014 9:03 am 
Offline
Of Systemic Importance
User avatar

Joined: Apr 1, 2009
Posts: 5311
Location: Utopia
If you think you need it, somebody has probably thought the same:

http://theenemy.dk/table/ paste from a spreadsheet, output bbcode
http://tokyo3.org/bbtable/ table to bbcode, again paste from a spreadsheet
http://forum.tribalwars.net/showthread.php?234015-Make-BBCode-Table-from-Excel-%28VBA%29 VBA macro (Excel 2007) output bbcode


Top
 Profile  
 
 Post subject: Re: Posting Tables from Excel
PostPosted: Thu Dec 04, 2014 9:26 am 
Offline
Speculator

Joined: Apr 27, 2014
Posts: 431
File, Save As

Select Formatted Text (Space delimited) (*.prn)

This will save the current worksheet only as a text file. Be careful to save your spreadsheet as XLS/XLSX before you do this and then close the file after saving as .PRN after without saving the spreadsheet.

The resulting text file can be opened using Notepad or similar, copied and posted within [code/ ... [/code] tags. This will make the information at least partially legible.

You may need to adjust the column widths to ensure columns are displayed correctly. Generaly if you have some clear space between columns in Excel, it will display correctly.

Try it a few times to get used to it.

Avoid long column names. Data that extends between column boundaries or that wraps or cells that contain multiple lines of data will not display correctly.


Top
 Profile  
 
 Post subject: Re: Posting Tables from Excel
PostPosted: Thu Dec 04, 2014 10:27 am 
Offline
Of Systemic Importance
User avatar

Joined: Aug 20, 2009
Posts: 5103
ps200306 wrote:
TheJackal wrote:
Bump.

Any further options on this?

Every month I haver a few Excel tables which I end up manually re-writing in a post and they don't look as good.


Try the image hosting approach:

Image

(You can always provide a separate link to the raw data on PasteBin or G.Drive etc. if you want)


Just did a test of that and it's working. I'll play around and see how I get on


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Jump to:  

Follow, Retweet @dailypinster



Click for Latest Posts LATEST POSTS Click for Forum List FORUMS


Pyramid Built, Is Better Built!