Importing Excel Table into MHB Forum

  • Context: MHB 
  • Thread starter Thread starter GerryZ
  • Start date Start date
  • Tags Tags
    Excel Forum Table
Click For Summary
SUMMARY

This discussion focuses on importing Excel tables into the MHB forum using copy and paste functionality. Users confirmed that the process works seamlessly when the WYSIWYG mode is enabled in vBulletin. To enhance the appearance of tables, it is necessary to add the attribute class: grid to the opening TABLE tag when in non-WYSIWYG mode. Additionally, users expressed the need for a feature that automatically applies this grid class to ensure all pasted tables maintain a consistent format.

PREREQUISITES
  • Familiarity with vBulletin 4.2.2 forum software
  • Understanding of WYSIWYG editors and their functionalities
  • Basic knowledge of BBCode for formatting tables
  • Experience with JavaScript for potential customization of forum features
NEXT STEPS
  • Research how to implement custom BBCode in vBulletin for table formatting
  • Learn about JavaScript integration in vBulletin for enhancing user experience
  • Explore vBulletin plugins that facilitate Excel table imports
  • Investigate user interface design for adding buttons to automate formatting tasks
USEFUL FOR

This discussion is beneficial for forum administrators, web developers, and users interested in enhancing the functionality of vBulletin forums, particularly those focused on Excel-related content.

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 ·
Replies
2
Views
3K
MHB The World Chess Championship 2012 ....
  • · Replies 10 ·
Replies
10
Views
4K
MHB In memory of Svetozar Gligoric....
  • · Replies 4 ·
Replies
4
Views
2K
Graduate Was the Early Universe Truly Homogeneous?
  • · Replies 23 ·
Replies
23
Views
6K