Forums

Pasting Excel Into WGT Forum Page &/or Messages

• apollo18 140 Posts

  Thu, Aug 28 2014 6:08 AM

  I have used Excel 2003 to construct a league for our CC. I would like to paste the results directly into WGT messages or our forum page, but seem unable to. 

  Can anyone help this poor deluded soul please?

   

• ScottHope 10,607 Posts

  Thu, Aug 28 2014 11:34 AM

  Unfortunately due to this forum being rather antiquated, it is only possible to paste an image of your worksheet into your post. An interactive worksheet is currently only something we can dream about, (and to think I used to dream about girls, lol).

• alosso 21,087 Posts

  Thu, Aug 28 2014 12:02 PM

  You may want to upload and publish the spreadsheet on the document side of some provider. This has been done already in the community, e.g. in the Tough-It-Out tourneys.

• ScottHope 10,607 Posts

  Thu, Aug 28 2014 1:02 PM

  Nice one Alosso. Yes, you can upload your worksheet to Google docs or Microsofts one drive, post a link to it to the forum and people can interact with it that way.

  Here's an example.

• mightyred 3,139 Posts

  Thu, Aug 28 2014 2:41 PM

  you can paste simple stuff in the post  so people can see the state of play.... 

  name	Wk 1	Wk 2	Wk 3	Wk 4
  aaa	32	31
  bbb	36	32
  cccc	35	35
  dddd	35	34
  eeeee	38	33
  fffffff	32	33
  ggggg	31	32
  hhhhh	30	32
  iiiii	36	32
  jjjjjjjjj	35	32

• stevepsheehan 2,791 Posts

  Thu, Aug 28 2014 2:46 PM

  Very useful info :-)

  So, like this?

  Ah yes, that works! Excellent - tyvm :-)

   

   

• ScottHope 10,607 Posts

  Thu, Aug 28 2014 3:14 PM

  That doesn't work for me Steve, I had to sign in to my Microsoft account as well which wouldn't be much good to people who don't have an account. There is a link I believe which you can use so people can view the item without signing in to anything.

• stevepsheehan 2,791 Posts

  Thu, Aug 28 2014 3:21 PM

  OK, so what do I do? What is different about your link, allowing me to see the chart?

  Maybe this works?

• WigerToods2010 8,448 Posts

  Thu, Aug 28 2014 3:25 PM

  apollo18:

  I have used Excel 2003 to construct a league for our CC. I would like to paste the results directly into WGT messages or our forum page, but seem unable to. 

  Can anyone help this poor deluded soul please?

   

  I'm not too sure what exactly you are seeking to do. 

  Are you looking to merely display a league table with the results or manipulate the actual data on here?

  If it's the latter, then no, you can't. If it's purely for others to read, then yes, you can paste direct from Excel. It all depends on what browser you are using.

  Some browsers will keep your background colours etc intact whilst others (Chrome for example) will use the site's default settings.

  The table below was copied and pasted direct from Excel 2007 using Chrome - hence black and white - all I've did is make the top row bold, adjust the width to 450 to ensure table fits, and change the following from the default '0' to table width="450" cellspacing="1" cellpadding="1" border="1">

  You'll see the bit in bold above  if you click the HTML icon available when posting any message.

  Date	Course	Holes	Tier	9 Holes	18 Holes
  06.26.12	Best of Strokeplay Front 9 Ready Go	Front 9	All Players	32	64
  06.27.12	Legend Kiawah Back 9 Ready Go	Back 9	Legend	35	70
  06.27.12	NKF Cadillac Golf Classic	Full 18	All Players	59	59
  06.27.12	Bethpage Back 9 Ready Go	Back 9	All Players	32	64
  06.27.12	WGT Best of Famous Holes	Back 9	Legend	32	64
  06.27.12	Elcc June Handicap 04	Full 18	All Players	70	70
  06.28.12	Kiawah Island: The Ocean Course	Front 9	Legend	31	62
  06.28.12	Royal St Georges Back 9 Ready Go	Back 9	All Players	32	64
  06.28.12	Bethpage Back 9 Ready Go	Back 9	All Players	33	66
  06.28.12	The Olympic Club	Front 9	Legend	28	56
  			Last 10 games average:		63.90

   

  More to follow............................ brb 

  :)

• WigerToods2010 8,448 Posts

  Thu, Aug 28 2014 3:29 PM

  Here's the EXACT same table, again,  just copied and pasted direct from Excel 2007.

  This time I'm on Firefox as I post.

  I've edited as previously with a slight change ;

  <table border="1" cellpadding="0" cellspacing="0" width="450">

   

  Date	Course	Holes	Tier	9 Holes	18 Holes
  06.26.12	Best of Strokeplay Front 9 Ready Go	Front 9	All Players	32	64
  06.27.12	Legend Kiawah Back 9 Ready Go	Back 9	Legend	35	70
  06.27.12	NKF Cadillac Golf Classic	Full 18	All Players	59	59
  06.27.12	Bethpage Back 9 Ready Go	Back 9	All Players	32	64
  06.27.12	WGT Best of Famous Holes	Back 9	Legend	32	64
  06.27.12	Elcc June Handicap 04	Full 18	All Players	70	70
  06.28.12	Kiawah Island: The Ocean Course	Front 9	Legend	31	62
  06.28.12	Royal St Georges Back 9 Ready Go	Back 9	All Players	32	64
  06.28.12	Bethpage Back 9 Ready Go	Back 9	All Players	33	66
  06.28.12	The Olympic Club	Front 9	Legend	28	56
  			Last 10 games average:		63.90