Importing Excel Table into MHB Forum

In summary: That is what I did to create the table above.You can't paste borders into a forum, you have to add them in the BB Code for the table. That is what I did to create the table above.Hello MarkFl I think i know you!:DThis the new setting in AdminCp as you saidand this the resul well allined but no bordersAlso in your forum i not able to paste bodersNORD15-gen-05FrankNORD17-gen-01AnnaNORD16-gen-08JoeSUD15-gen-11LuisSUD22-gen-09AnnaSUD18-gen-
  • #1
GerryZ
10
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
  • #2
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.

7 mag 201410:20:00 AM 1,3928
7 mag 201410:25:00 AM 1,3926
7 mag 201410:30:00 AM 1,3925
7 mag 201410:35:00 AM 1,3924
7 mag 201410:40:00 AM 1,3923
7 mag 201410:45:00 AM 1,3917
7 mag 201410:50:00 AM 1,3917
7 mag 201410:55:00 AM 1,3919
7 mag 201411:00:00 AM 1,3913
7 mag 201411:05:00 AM 1,3914
7 mag 201411:10:00 AM 1,3912
7 mag 201411:15:00 AM 1,3912
7 mag 201411:20:00 AM 1,3914
7 mag 201411:25:00 AM 1,3913
7 mag 201411:30:00 AM 1,3915
7 mag 201411:35:00 AM 1,3917
7 mag 201411:40:00 AM 1,3918
 
  • #3
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:
  • #4
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:
 
  • #5
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:

NOMEINCASSOTOTALE
Anna39
Anna48
Anna22
Anna37146

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
 
  • #6
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:

NOMEINCASSOTOTALE
Anna39
Anna48
Anna22
Anna37146

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
NORD15-gen-05Frank
NORD17-gen-01Anna
NORD16-gen-08Joe
SUD15-gen-11Luis
SUD22-gen-09Anna
SUD18-gen-17Pietro
SUD18-gen-14Luis
SUD21-gen-13Giorgia
EST7-giu-14Giulia
EST14-lug-12Anna
EST12-apr-19Giulia
EST13-feb-22Luis
EST11-mar-20Andrea
 
  • #7
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]
[/m]
 
  • #8
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]
[/m]


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

criteriodateNome
NORD15-gen-05Frank
NORD17-gen-01Anna
NORD16-gen-08Joe
SUD15-gen-11Luis
SUD22-gen-09Anna
SUD18-gen-17Pietro
SUD18-gen-14Luis
SUD21-gen-13Giorgia
EST7-giu-14Giulia
EST14-lug-12Anna
EST12-apr-19Giulia
EST13-feb-22Luis
EST11-mar-20Andrea
 
  • #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
 

FAQ: Importing Excel Table into MHB Forum

What is the process for importing an Excel table into MHB Forum?

The first step is to save your Excel table as a CSV (Comma Separated Values) file. Then, log into your MHB Forum account and navigate to the forum where you want to import the table. Click on the "Import" button and select the CSV file from your computer. Follow the prompts to map the columns of your table to the corresponding forum fields. Finally, click on "Import" to complete the process.

Can I import multiple sheets from an Excel workbook into MHB Forum?

Yes, MHB Forum allows you to import multiple sheets from an Excel workbook at once. When selecting the CSV file to import, choose the option to "Select multiple sheets" and then select the sheets you want to import. The columns from each sheet will be mapped separately during the import process.

What happens if there are errors during the import process?

If there are any errors during the import process, MHB Forum will display a message indicating which rows were not imported and the reason for the error. This could be due to missing or invalid data, or if there are duplicate entries in your table. You can make the necessary changes to your CSV file and re-import it.

Can I customize the appearance of the imported table in MHB Forum?

Yes, MHB Forum allows you to customize the appearance of the imported table by using HTML and CSS. You can add headers, adjust the column widths, and format the data to make it visually appealing. You can also add additional formatting options by using plugins or custom code.

What happens to the imported table if I make changes to the original Excel file?

The imported table in MHB Forum is a separate entity from the original Excel file. Any changes made to the original file will not be reflected in the imported table. If you want to update the table in MHB Forum, you will need to re-import the updated file.

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