MHB Importing Excel Table into MHB Forum

AI Thread Summary
The discussion revolves around the ability to import Excel tables into a forum using copy and paste while retaining formatting such as lines and borders. Users express a need for a straightforward method to achieve this, particularly for new users on forums focused on Excel. It is confirmed that using the WYSIWYG editor allows for easy copying from Excel, as the necessary table codes are generated automatically. However, to add borders to the tables, users must switch off WYSIWYG mode and manually edit the BBCode to include a class for grid formatting. Suggestions are made to create a button that would automate this process, ensuring all users can post tables with borders easily. The importance of maintaining WYSIWYG mode for compatibility with other forum modifications is emphasized, along with the need for potential adjustments in the vBulletin template or the installation of additional plugins to enhance functionality.
GerryZ
Messages
10
Reaction score
0
Hello MHB Gurus
I'm writing this section but I'm not sure if is the right one
I wonder if is possible to import an Excel Table (with copy and paste) from excel into the forum with line and boarders
Thank you for your help

7 mag 2014 10:20 1,3928
7 mag 2014 10:25 1,3926
7 mag 2014 10:30 1,3925
7 mag 2014 10:35 1,3924
7 mag 2014 10:40 1,3923
7 mag 2014 10:45 1,3917
7 mag 2014 10:50 1,3917
7 mag 2014 10:55 1,3919
7 mag 2014 11:00 1,3913
7 mag 2014 11:05 1,3914
7 mag 2014 11:10 1,3912
7 mag 2014 11:15 1,3912
7 mag 2014 11:20 1,3914
7 mag 2014 11:25 1,3913
7 mag 2014 11:30 1,3915
7 mag 2014 11:35 1,3917
7 mag 2014 11:40 1,3918
 
Last edited:
Physics news on Phys.org
GerryZ said:
Hello MHB Gurus
I'm writing this section but I'm not sure if is the right one
I wonder if is possible to import an Excel Table (with copy and paste) from excel into the forum with line and boarders
Thank you for your help

7 mag 2014 10:20 1,3928
7 mag 2014 10:25 1,3926
7 mag 2014 10:30 1,3925
7 mag 2014 10:35 1,3924
7 mag 2014 10:40 1,3923
7 mag 2014 10:45 1,3917
7 mag 2014 10:50 1,3917
7 mag 2014 10:55 1,3919
7 mag 2014 11:00 1,3913
7 mag 2014 11:05 1,3914
7 mag 2014 11:10 1,3912
7 mag 2014 11:15 1,3912
7 mag 2014 11:20 1,3914
7 mag 2014 11:25 1,3913
7 mag 2014 11:30 1,3915
7 mag 2014 11:35 1,3917
7 mag 2014 11:40 1,3918

Hi GerryZ! Welcome to MBH! ;)

It works out of the box for me.
I've converted your table back to Excel, and then copied and pasted it here.
We do need to have WYSIWYG mode on (top left speed button).
To improve the appearance I've added [M]="class: grid"[/M] (in non-WYSIWYG mode) to get a full grid around the cells.

[TABLE="class: grid"]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]10:20:00 AM[/TD]
[TD="align: left"] 1,3928[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]10:25:00 AM[/TD]
[TD="align: left"] 1,3926[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]10:30:00 AM[/TD]
[TD="align: left"] 1,3925[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]10:35:00 AM[/TD]
[TD="align: left"] 1,3924[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]10:40:00 AM[/TD]
[TD="align: left"] 1,3923[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]10:45:00 AM[/TD]
[TD="align: left"] 1,3917[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]10:50:00 AM[/TD]
[TD="align: left"] 1,3917[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]10:55:00 AM[/TD]
[TD="align: left"] 1,3919[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]11:00:00 AM[/TD]
[TD="align: left"] 1,3913[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]11:05:00 AM[/TD]
[TD="align: left"] 1,3914[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]11:10:00 AM[/TD]
[TD="align: left"] 1,3912[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]11:15:00 AM[/TD]
[TD="align: left"] 1,3912[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]11:20:00 AM[/TD]
[TD="align: left"] 1,3914[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]11:25:00 AM[/TD]
[TD="align: left"] 1,3913[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]11:30:00 AM[/TD]
[TD="align: left"] 1,3915[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]11:35:00 AM[/TD]
[TD="align: left"] 1,3917[/TD]
[/TR]
[TR]
[TD="align: left"]7 mag 2014[/TD]
[TD="align: right"]11:40:00 AM[/TD]
[TD="align: left"] 1,3918[/TD]
[/TR]
[/TABLE]
 
It works out of the box for me.
I've converted your table back to Excel, and then copied and pasted it here.
We do need to have WYSIWYG mode on (top left speed button).
To improve the appearance I've added [M]="class: grid"[/M] (in non-WYSIWYG mode) to get a full grid around the cells.

Wooowww Beautiful!
So I want to tell my story, I'm Italian (sorry if i dn't speak good iEnglish) and I' am a founder and owner of ForumExcel.it (vB 4.2.2) italian forum that treat excel , so for me is very important that all of my users (expecially newbie) tha are able tu post a nice table like you did, so I wnat to do a setting directly in AdminCp for all forum
Is this possible..
Thank you
 
Last edited:
GerryZ said:
Wooowww Beautiful!
So I want to tell my story, I'm Italian (sorry if i dn't speak good iEnglish) and I' am a founder and owner of ForumExcel.it (vB 4.2.2) italian forum that treat excel , so for me is very important that all of my users (expecially newbie) tha are able tu post a nice table like you did, so I wnat to do a setting directly in AdminCp for all forum
Is this possible..
Thank you
NOME INCASSO TOTALE
Anna 39
Anna 48
Anna 22
Anna 37 146
Giorgia 50
Giorgia 46
Giorgia 50
Giorgia 40
Giorgia 38 224
Giulia 42
Giulia 39
Giulia 32 113
Luisa 41
Luisa 25
Luisa 40 106

hummm! not working:mad:
 
GerryZ said:
NOME INCASSO TOTALE
Anna 39
Anna 48
Anna 22
Anna 37 146
Giorgia 50
Giorgia 46
Giorgia 50
Giorgia 40
Giorgia 38 224
Giulia 42
Giulia 39
Giulia 32 113
Luisa 41
Luisa 25
Luisa 40 106

hummm! not working:mad:

You need to wrap your data in the table-associated BBCodes...for example the following code:

Code: 
[table="width: 500, class: grid"]
[tr]
	[td]NOME[/td]
	[td]INCASSO[/td]
	[td]TOTALE[/td]
[/tr]
[tr]
	[td]Anna[/td]
	[td]39[/td]
	[td][/td]
[/tr]
[tr]
	[td]Anna[/td]
	[td]48[/td]
	[td][/td]
[/tr]
[tr]
	[td]Anna[/td]
	[td]22[/td]
	[td][/td]
[/tr]
[tr]
	[td]Anna[/td]
	[td]37[/td]
	[td]146[/td]
[/tr]
[/table]

produces:

[table="width: 500, class: grid"]
[tr]
[td]NOME[/td]
[td]INCASSO[/td]
[td]TOTALE[/td]
[/tr]
[tr]
[td]Anna[/td]
[td]39[/td]
[td][/td]
[/tr]
[tr]
[td]Anna[/td]
[td]48[/td]
[td][/td]
[/tr]
[tr]
[td]Anna[/td]
[td]22[/td]
[td][/td]
[/tr]
[tr]
[td]Anna[/td]
[td]37[/td]
[td]146[/td]
[/tr]
[/table]

However, as I like Serena stated (which I didn't know), if you copy/paste directly from Excel into a vBulletin post where the WYSIWYG editor is being used, the table codes will be created for you. :D
 
MarkFL said:
You need to wrap your data in the table-associated BBCodes...for example the following code:

Code: 
[table="width: 500, class: grid"]
[tr]
    [td]NOME[/td]
    [td]INCASSO[/td]
    [td]TOTALE[/td]
[/tr]
[tr]
    [td]Anna[/td]
    [td]39[/td]
    [td][/td]
[/tr]
[tr]
    [td]Anna[/td]
    [td]48[/td]
    [td][/td]
[/tr]
[tr]
    [td]Anna[/td]
    [td]22[/td]
    [td][/td]
[/tr]
[tr]
    [td]Anna[/td]
    [td]37[/td]
    [td]146[/td]
[/tr]
[/table]

produces:

[TABLE="class: grid, width: 500"]
[TR]
[TD]NOME[/TD]
[TD]INCASSO[/TD]
[TD]TOTALE[/TD]
[/TR]
[TR]
[TD]Anna[/TD]
[TD]39[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Anna[/TD]
[TD]48[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Anna[/TD]
[TD]22[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Anna[/TD]
[TD]37[/TD]
[TD]146[/TD]
[/TR]
[/TABLE]

However, as I like Serena stated (which I didn't know), if you copy/paste directly from Excel into a vBulletin post where the WYSIWYG editor is being used, the table codes will be created for you. :D

Hello MarkFl I think i know you!:D

This the new setting in AdminCp as you said

qAdiVcB.png


and this the resul well allined but no borders

7H6Pz2Y.png
Also in your forum i not able to paste boders
[TABLE="width: 293"]
[TR]
[TD]NORD[/TD]
[TD="align: right"]15-gen-05[/TD]
[TD]Frank[/TD]
[/TR]
[TR]
[TD]NORD[/TD]
[TD="align: right"]17-gen-01[/TD]
[TD]Anna[/TD]
[/TR]
[TR]
[TD]NORD[/TD]
[TD="align: right"]16-gen-08[/TD]
[TD]Joe[/TD]
[/TR]
[TR]
[TD]SUD[/TD]
[TD="align: right"]15-gen-11[/TD]
[TD]Luis[/TD]
[/TR]
[TR]
[TD]SUD[/TD]
[TD="align: right"]22-gen-09[/TD]
[TD]Anna[/TD]
[/TR]
[TR]
[TD]SUD[/TD]
[TD="align: right"]18-gen-17[/TD]
[TD]Pietro[/TD]
[/TR]
[TR]
[TD]SUD[/TD]
[TD="align: right"]18-gen-14[/TD]
[TD]Luis[/TD]
[/TR]
[TR]
[TD]SUD[/TD]
[TD="align: right"]21-gen-13[/TD]
[TD]Giorgia[/TD]
[/TR]
[TR]
[TD]EST[/TD]
[TD="align: right"]7-giu-14[/TD]
[TD]Giulia[/TD]
[/TR]
[TR]
[TD]EST[/TD]
[TD="align: right"]14-lug-12[/TD]
[TD]Anna[/TD]
[/TR]
[TR]
[TD]EST[/TD]
[TD="align: right"]12-apr-19[/TD]
[TD]Giulia[/TD]
[/TR]
[TR]
[TD]EST[/TD]
[TD="align: right"]13-feb-22[/TD]
[TD]Luis[/TD]
[/TR]
[TR]
[TD]EST[/TD]
[TD="align: right"]11-mar-20[/TD]
[TD]Andrea[/TD]
[/TR]
[/TABLE]
 
Yes, we are conversing both here and at vBorg about separate issues. :D

In order to get borders, you will have to turn off WYSIWG mode, and edit the BB Code to add [M]="class: grid"[/M] inside the opening TABLE tag. In other words, change:

[m]
[/m]

to:

[m][TABLE="class: grid"][/m]
 
MarkFL said:
Yes, we are conversing both here and at vBorg about separate issues. :D

In order to get borders, you will have to turn off WYSIWG mode, and edit the BB Code to add [M]="class: grid"[/M] inside the opening TABLE tag. In other words, change:

[m]
[/m]

to:

[m][TABLE="class: grid"][/m]


Not workin
is possible to add a botton to add the grid?
 
I think I did it
Have a look

[TABLE="class: grid"]
[TR]
[TD]criterio[/TD]
[TD]date[/TD]
[TD]Nome[/TD]
[/TR]
[TR]
[TD]NORD[/TD]
[TD="align: right"]15-gen-05[/TD]
[TD]Frank[/TD]
[/TR]
[TR]
[TD]NORD[/TD]
[TD="align: right"]17-gen-01[/TD]
[TD]Anna[/TD]
[/TR]
[TR]
[TD]NORD[/TD]
[TD="align: right"]16-gen-08[/TD]
[TD]Joe[/TD]
[/TR]
[TR]
[TD]SUD[/TD]
[TD="align: right"]15-gen-11[/TD]
[TD]Luis[/TD]
[/TR]
[TR]
[TD]SUD[/TD]
[TD="align: right"]22-gen-09[/TD]
[TD]Anna[/TD]
[/TR]
[TR]
[TD]SUD[/TD]
[TD="align: right"]18-gen-17[/TD]
[TD]Pietro[/TD]
[/TR]
[TR]
[TD]SUD[/TD]
[TD="align: right"]18-gen-14[/TD]
[TD]Luis[/TD]
[/TR]
[TR]
[TD]SUD[/TD]
[TD="align: right"]21-gen-13[/TD]
[TD]Giorgia[/TD]
[/TR]
[TR]
[TD]EST[/TD]
[TD="align: right"]7-giu-14[/TD]
[TD]Giulia[/TD]
[/TR]
[TR]
[TD]EST[/TD]
[TD="align: right"]14-lug-12[/TD]
[TD]Anna[/TD]
[/TR]
[TR]
[TD]EST[/TD]
[TD="align: right"]12-apr-19[/TD]
[TD]Giulia[/TD]
[/TR]
[TR]
[TD]EST[/TD]
[TD="align: right"]13-feb-22[/TD]
[TD]Luis[/TD]
[/TR]
[TR]
[TD]EST[/TD]
[TD="align: right"]11-mar-20[/TD]
[TD]Andrea[/TD]
[/TR]
[/TABLE]
 
  • #10
GerryZ said:
Not workin
is possible to add a botton to add the grid?

Yes, a button could be added somewhere that would execute javascript to use regex to make the replacement to add the grid class, or it could be automatically added on preview/submit (but then no one would be able to post tables without grids). :)
 
  • #11
MarkFL said:
or it could be automatically added on preview/submit (but then no one would be able to post tables without grids). :)
Beautiful, Your words are so professional...
I think the best way do to, is your second suggestion and doesn't mutter if no one is no longer able to post table without grids, my forum talk about excel my users will understand the grid
I don't know how you are going to fix the border, but important is tha any user can copy and paste a table with borders from excel to the formu
One more thing I prefere to keep WYSIWYG mode becouse is connected with another MOD( [vBFoster Lite] With Attachments in Quick reply and Advanced Editor ) that i need to keep it because is very important for my users

Thank You fo now and see you later
 
Last edited:
  • #12
Hello I'm back again
I wonder if I need to make a modificantion into the vB bullettin template or istall a MOD plugins?
Yhank you for your answer but for me is very important
Ciao
 

Similar threads

Is the Dart Throwing Data a Gaussian Distribution?
Replies
2
Views
2K
MHB The World Chess Championship 2012 ....
Replies
10
Views
4K
MHB In memory of Svetozar Gligoric....
Replies
4
Views
2K
Was the Early Universe Truly Homogeneous?
Replies
23
Views
6K

Hot Threads

Recent Insights

Back
Top