BuzzJack
Entertainment Discussion

Welcome Guest ( Log In | Register | Help )

Latest Site News
 
Reply to this topicStart new topic
> Creating a table
Track this topic - Email this topic - Print this topic - Download this topic - Subscribe to this forum
Dannyboy
post Jul 3 2016, 11:50 AM
Post #1
BuzzJack Legend
*******
Group: Members
Posts: 21,541
Member No.: 632
Joined: 26-May 06
 


How can I take Spreadsheet data and put it into a table format so its easier to read -

Pos Act Song Pos Weeks Points

484 Akon Right Now 6 31 1873
485 Akon Beautiful 8 35 1869
486 Katy Perry California Girls 1 35 1868
487 Bruno Mars Billionaire 3 32 1868
488 Olly Murs Troublemaker 1 35 1864
489 Sinitta So Macho 2 30 1864
490 Boyz II men End of the road 1 26 1864
491 Leona Lewis Run 1 44 1861
492 Platters Smoke gets in your eyes 1 20 1860
493 Madonna Crazy for you 2 23 1857
494 Naughty Boy Runnin 4 27 1855
495 One Direction Drag me down 1 31 1852
496 David Guetta Play Hard 6 29 1849
497 Ellie Goulding Your Song 2 33 1846
498 Calvin Harris I need your love 4 29 1845
499 Pat Boone Friendly Persuassion 3 21 1843
500 Lorde Royals 1 34 1839


This post has been edited by Dannyboy: Jul 3 2016, 05:26 PM
Go to the top of the page
 
+Quote Post
Rudolph
post Jul 3 2016, 12:30 PM
Post #2
Infamy Infamy they all got it in for me
********
Group: Chart Mod
Posts: 122,802
Member No.: 2
Joined: 5-March 06
 


The only way I can think of... is to screen shot it, and import it as a image through photobucket or other photo sites. Unless anyone else can shed more light on it.
Go to the top of the page
 
+Quote Post
Dannyboy
post Jul 3 2016, 12:34 PM
Post #3
BuzzJack Legend
*******
Group: Members
Posts: 21,541
Member No.: 632
Joined: 26-May 06
 


QUOTE(Mart!n @ Jul 3 2016, 01:30 PM) *
The only way I can think of... is to screen shot it, and import it as a image through photobucket or other photo sites. Unless anyone else can shed more light on it.


I know someone showed me the coding for it years ago but I cant remember now
Go to the top of the page
 
+Quote Post
t=SpunderfulXmas
post Jul 3 2016, 02:41 PM
Post #4
Hang in when the world counts you out and youíre gonna be fine
*******
Group: Members
Posts: 20,536
Member No.: 21,005
Joined: 20-June 14
 


QUOTE(Mart!n @ Jul 3 2016, 01:30 PM) *
The only way I can think of... is to screen shot it, and import it as a image through photobucket or other photo sites. Unless anyone else can shed more light on it.

Yeah this is the best way that I'm aware of. If you use Excel I know you can select part of the spreadsheet you want to post, copy and then paste it into Paint, save it as an image then upload on imgur.com/whatever image upload site and paste the link to it in your post wink.gif
QUOTE(Dannyboy @ Jul 3 2016, 01:34 PM) *
I know someone showed me the coding for it years ago but I cant remember now

On this forum? That's quite interesting. I've not seen a non-screenshotted table on here before. It's always been image tables I've seen in the major BJSC results at least.
Go to the top of the page
 
+Quote Post
mdh
post Jul 3 2016, 02:47 PM
Post #5
it doesn't matter, we're all together
******
Group: Moderator
Posts: 18,138
Member No.: 22,776
Joined: 19-December 15
   No Gallery Pics
 


I use a screenshot tool where you select your screen part to copy, press enter and it gives you a url that you can paste into a post. It takes seconds, and saves time uploading it to a website.
Go to the top of the page
 
+Quote Post
Dannyboy
post Jul 3 2016, 03:01 PM
Post #6
BuzzJack Legend
*******
Group: Members
Posts: 21,541
Member No.: 632
Joined: 26-May 06
 


QUOTE(BASTILLEmdh @ Jul 3 2016, 03:47 PM) *
I use a screenshot tool where you select your screen part to copy, press enter and it gives you a url that you can paste into a post. It takes seconds, and saves time uploading it to a website.


Hi, whats the screenshot tool ?
Go to the top of the page
 
+Quote Post
mdh
post Jul 3 2016, 05:09 PM
Post #7
it doesn't matter, we're all together
******
Group: Moderator
Posts: 18,138
Member No.: 22,776
Joined: 19-December 15
   No Gallery Pics
 


Lightshot I believe.
Go to the top of the page
 
+Quote Post
Dannyboy
post Jul 3 2016, 05:22 PM
Post #8
BuzzJack Legend
*******
Group: Members
Posts: 21,541
Member No.: 632
Joined: 26-May 06
 


It doesn't even have to be a table, just coding that will put things into more organised columns
Go to the top of the page
 
+Quote Post
richie
post Jul 4 2016, 08:44 AM
Post #9
Poet and Storyteller
******
Group: Members
Posts: 6,751
Member No.: 166
Joined: 11-March 06
   No Gallery Pics
 


CODE
<table><tr><th>Heading 1</th><th>Heading 2</th></tr><tr><td>Data 1</td><td>Data 2</td></tr></table>


That's the HTML above, but the code option doesn't seem to support it.

Does anyone know a way for this to accept HTML?


This post has been edited by richie: Jul 4 2016, 08:46 AM
Go to the top of the page
 
+Quote Post
Phil
post Jul 4 2016, 01:37 PM
Post #10
Creator/
******
Group: Admin.
Posts: 7,828
Member No.: 1
Joined: 2-March 06
 


pre currently is the best way, if your tabs are well defined (they are columns in Excel) then you can copy/ paste into here and add the pre tags:
Test1	Title1	Name1
Test2 Title2 Name2
Test3 Title3 Name3
Test4 Title4 Name4
Test5 Title5 Name5
Test6 Title6 Name6
Test7 Title7 Name7
Test8 Title8 Name8
Test9 Title9 Name9
Test10 Title10 Name10
Test11 Title11 Name11
Test12 Title12 Name12
Test13 Title13 Name13
Test14 Title14 Name14
Test15 Title15 Name15
Test16 Title16 Name16
Test17 Title17 Name17
Test18 Title18 Name18


new site will have the ability to add a table either immediately or in phase 2, but certainly on the plan.
Go to the top of the page
 
+Quote Post
Dannyboy
post Jul 4 2016, 05:18 PM
Post #11
BuzzJack Legend
*******
Group: Members
Posts: 21,541
Member No.: 632
Joined: 26-May 06
 


QUOTE(Phil @ Jul 4 2016, 02:37 PM) *
pre currently is the best way, if your tabs are well defined (they are columns in Excel) then you can copy/ paste into here and add the pre tags:
Test1	Title1	Name1
Test2 Title2 Name2
Test3 Title3 Name3
Test4 Title4 Name4
Test5 Title5 Name5
Test6 Title6 Name6
Test7 Title7 Name7
Test8 Title8 Name8
Test9 Title9 Name9
Test10 Title10 Name10
Test11 Title11 Name11
Test12 Title12 Name12
Test13 Title13 Name13
Test14 Title14 Name14
Test15 Title15 Name15
Test16 Title16 Name16
Test17 Title17 Name17
Test18 Title18 Name18


new site will have the ability to add a table either immediately or in phase 2, but certainly on the plan.


I use Excel but when I use Pre, I get this -


Baha Men Who let the dogs out 2 29 1952
One Direction History 6 32 1951
Tom Jones Help Myself 5 26 1951
Savage Garden Truly Madly Deeply 4 32 1949
Jimmy Young Unchained Melody 1 22 1948
Frankie Laine A woman in love 1 21 1946
Kenny Rogers Ruby donít take your love to town 2 23 1943
Julie Rodgers Wedding 3 24 1938
Dean Martin Return to me 2 22 1935
Tinie Tempah Written in the stars 1 38 1932
Aqua Barbie Girl 1 27 1930
Del Shannon Runaway 1 22 1923
Route 94 My Love 1 34 1919
Tom Jones Green green grass of home 1 22 1916
D:Ream Things can only get better 1 27 1915
Roy Orbison In dreams 6 23 1910
Gerry & the pacemakers Youll never walk alone 1 22 1907
Martin Solveig Hello 13 31 1902
Glee Donít stop believin 2 37 1901
Beatles I want to hold your hand 1 25 1899
Maroon 5 Payphone 1 30 1897
Spice Girls Wannabe 1 26 1897
Dean Martin Gentle on my mind 2 24 1893
Wombles Wombling Song 4 26 1892
Chris Brown Ayo 6 29 1885
Mark Morrison Return of the mack 1 27 1885
Kay Starr Rock and roll waltz 1 20 1882
Bluebells Young at heart 1 24 1881
Sigma Changing 1 30 1879
Shirley Bassey For all we know 6 24 1874
Seekers Ill never find another you 1 23 1874
Akon Right Now 6 31 1873
Akon Beautiful 8 35 1869
Katy Perry California Girls 1 35 1868
Bruno Mars Billionaire 3 32 1868
Olly Murs Troublemaker 1 35 1864
Sinitta So Macho 2 30 1864
Boyz II men End of the road 1 26 1864
Taylor Swift Black Space 4 32 1862
Leona Lewis Run 1 44 1861
Platters Smoke gets in your eyes 1 20 1860
Madonna Crazy for you 2 23 1857
Naughty Boy Runnin 4 27 1855
One Direction Drag me down 1 31 1852
David Guetta Play Hard 6 29 1849
Ellie Goulding Your Song 2 33 1846
Calvin Harris I need your love 4 29 1845
Pat Boone Friendly Persuassion 3 21 1843
Lorde Royals 1 34 1839
Slim Whitman Rose Marie 1 19 1839

Go to the top of the page
 
+Quote Post
Phil
post Jul 5 2016, 10:35 AM
Post #12
Creator/
******
Group: Admin.
Posts: 7,828
Member No.: 1
Joined: 2-March 06
 


yes this is annoying, will be sorted in the new site (either initial or second release). In the mean time you have to add the extra tabs yourself to lineup the data..
Go to the top of the page
 
+Quote Post
Dannyboy
post Jul 5 2016, 12:08 PM
Post #13
BuzzJack Legend
*******
Group: Members
Posts: 21,541
Member No.: 632
Joined: 26-May 06
 


QUOTE(Phil @ Jul 5 2016, 11:35 AM) *
yes this is annoying, will be sorted in the new site (either initial or second release). In the mean time you have to add the extra tabs yourself to lineup the data..


Extra tabs ?

I wasn't aware there was gonna be a new site to be honest
Go to the top of the page
 
+Quote Post
Phil
post Jul 5 2016, 07:59 PM
Post #14
Creator/
******
Group: Admin.
Posts: 7,828
Member No.: 1
Joined: 2-March 06
 


QUOTE(Dannyboy @ Jul 5 2016, 01:08 PM) *
Extra tabs ?

I wasn't aware there was gonna be a new site to be honest

where the alignment is off just add/remove a tab in the correct place. It is due to the length of the text pushing the column out.
Go to the top of the page
 
+Quote Post


Reply to this topicStart new topic

1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


 

Lo-Fi Version Time is now: 16th December 2017 - 11:17 AM