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

Discussion Overview

The discussion revolves around the possibility of importing Excel tables into the MHB forum, specifically focusing on formatting issues such as maintaining lines and borders when copying and pasting from Excel. Participants explore various methods and settings related to the forum's WYSIWYG editor and table formatting.

Discussion Character

  • Exploratory, Technical explanation, Debate/contested

Main Points Raised

  • Some participants inquire about the feasibility of importing Excel tables with formatting intact, expressing uncertainty about the correct method.
  • One participant reports success in copying and pasting a table from Excel, noting the need for WYSIWYG mode to be enabled for proper formatting.
  • Another participant suggests adding a grid class to the table code to achieve borders, indicating that this requires turning off WYSIWYG mode.
  • Some participants express frustration with formatting issues, stating that their attempts to create tables with borders have not worked as expected.
  • A suggestion is made to implement a button that would automatically add the grid class to tables, though concerns are raised about the implications for users who may want to post tables without grids.
  • One participant emphasizes the importance of maintaining WYSIWYG mode due to its connection with other forum modifications.
  • There is a discussion about whether modifications to the vBulletin template or the installation of a MOD plugin would be necessary to achieve the desired functionality.

Areas of Agreement / Disagreement

Participants express a mix of agreement and disagreement regarding the methods for importing and formatting tables. While some report success, others encounter issues, indicating that the discussion remains unresolved with multiple competing views on the best approach.

Contextual Notes

Limitations include uncertainty about the effectiveness of various methods for maintaining table formatting, as well as the potential need for additional modifications to the forum software.

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