News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Making excel tables on smf

Started by Blackphoenixz, February 18, 2017, 08:33:53 AM

Previous topic - Next topic

Blackphoenixz

Hi
i wanna ask if there is anyway to copy excel tables(with boards) on smf topics?or any program which can do it

i want make something like this on topics (this one has no boards)

Kindred

you can use the table, tr and td BBCodes


[table]
[tr]
[td][/td]
[/tr]
[/table]


that's all... otherwise, no....


You could TRY this... but no guarantees... I've never used it.
http://theenemy.dk/table/
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Blackphoenixz

#2
well...i use it,but cells wont sort correctly...look this


nametypetime
blackphoenixgiveawayunlimit
rizzmonthly donatetill end of jan



table]
nametypetime
blackphoenixgiveawayunlimit
rizzmonthly donatetill end of jan





how can i fix this?if names be long....they stack to each other & even cut some parts

Kindred

#3
??  I am confused... it seems to display correctly to me...



[table]
[tr] [td]name[/td] [td]type[/td][td]time[/td][/tr]
[tr] [td]blackphoenix[/td] [td]giveaway[/td][td]unlimit[/td][/tr]
[tr] [td]rizz[/td] [td]monthly donate[/td][td]till end of jan[/td][/tr]
[/table]



nametypetime
blackphoenixgiveawayunlimit
rizzmonthly donatetill end of jan


[edit] fixed bbc - Illori
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

lntit

Not sure, but this (example from OP) should work:

Hour | Wind dir | Force | Bar Height | Ther Attached | Dry | Wet | Water | Weather Code | Cloud Code | Clear Sky
1SE329.64484746ocfnimb0
2 - 329.64454343 - -0
3 - 329.62454646 - -0
4 - 329.62454646 - -0
5 - 429.64454646 - -0
6E329.6849525244 - -0
7 - 329.7049525244bcf -7
8 - 329.7149535344 - -5
9ESE329.7149535353 -Cir Str8
10 - 429.7159555344 - -8




[table][tr][td][b]Hour[/b] | [/td][td][b]Wind dir[/b] | [/td][td][b]Force[/b] | [/td][td][b]Bar Height[/b] | [/td][td][b]Ther Attached[/b] | [/td][td][b]Dry[/b] | [/td][td][b]Wet[/b] | [/td][td][b]Water[/b] | [/td][td][b]Weather Code[/b] | [/td][td][b]Cloud Code[/b] | [/td][td][b]Clear Sky[/b][/td][/tr]
[tr][td]1[/td][td]SE[/td][td]3[/td][td]29.64[/td][td]48[/td][td]47[/td][td]46[/td][td][/td][td]ocf[/td][td]nimb[/td][td]0[/td][/tr]
[tr][td]2[/td][td] - [/td][td]3[/td][td]29.64[/td][td]45[/td][td]43[/td][td]43[/td][td][/td][td] -[/td][td] -[/td][td]0[/td][/tr]
[tr][td]3[/td][td] - [/td][td]3[/td][td]29.62[/td][td]45[/td][td]46[/td][td]46[/td][td][/td][td] -[/td][td] -[/td][td]0[/td][/tr]
[tr][td]4[/td][td] - [/td][td]3[/td][td]29.62[/td][td]45[/td][td]46[/td][td]46[/td][td][/td][td] -[/td][td] -[/td][td]0[/td][/tr]
[tr][td]5[/td][td] - [/td][td]4[/td][td]29.64[/td][td]45[/td][td]46[/td][td]46[/td][td][/td][td] -[/td][td] -[/td][td]0[/td][/tr]
[tr][td]6[/td][td]E[/td][td]3[/td][td]29.68[/td][td]49[/td][td]52[/td][td]52[/td][td]44[/td][td] -[/td][td] -[/td][td]0[/td][/tr]
[tr][td]7[/td][td] - [/td][td]3[/td][td]29.70[/td][td]49[/td][td]52[/td][td]52[/td][td]44[/td][td]bcf[/td][td] -[/td][td]7[/td][/tr]
[tr][td]8[/td][td] - [/td][td]3[/td][td]29.71[/td][td]49[/td][td]53[/td][td]53[/td][td]44[/td][td] -[/td][td] -[/td][td]5[/td][/tr]
[tr][td]9[/td][td]ESE[/td][td]3[/td][td]29.71[/td][td]49[/td][td]53[/td][td]53[/td][td]53[/td][td] -[/td][td]Cir Str[/td][td]8[/td][/tr]
[tr][td]10[/td][td] - [/td][td]4[/td][td]29.71[/td][td]59[/td][td]55[/td][td]53[/td][td]44[/td][td] -[/td][td] -[/td][td]8[/td][/tr][/table]


Edit: Ninjad ;D

Chen Zhen


Have you tried searching for a tool that does it automatically on Google?

ie.
http://tableizer.journalistopia.com/


My SMF Mods & Plug-Ins

WebDev

"Either you repeat the same conventional doctrines everybody is saying, or else you say something true, and it will sound like it's from Neptune." - Noam Chomsky

Steve

Except that when I tried that tool my table came out looking nothing like the spreadsheet one, as far as what goes in what cells, etc.
DO NOT pm me for support!

lntit

I've used Excel for creating that table. :)
I had to remove only the tab spaces.

Advertisement: