Excel xls/csv to Table

Do not post support requests, bug reports or feature requests. Discuss phpBB here. Non-phpBB related discussion goes in General Discussion!
Suggested Hosts
vk3ymml
Registered User
Posts: 7
Joined: Tue Jan 30, 2024 10:35 pm

Excel xls/csv to Table

Post by vk3ymml »

Support Request Template
What version of phpBB are you using?: phpBB 3.3.11
What is your board's URL?: https://vicscan.com/
Who do you host your board with?: HostGator
How did you install your board? I used a tool provided by my host
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? Yes
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What version of phpBB3 did you update from? phpBB 3.3.10
What MODs do you have installed?: No Mods Installed
What extensions do you have installed?: Auto Database Backup, Google Analytics, Tables

Hi all

I have a large collection of radio frequencies and relevant details that I am trying to import to a forum post with no success. I have googled the subject at large however I have not been able to arrive at a solution.

Attempts to use BBcode via https://tableconvert.com/excel-to-bbcode and paste into the forum post just give text, no table is created. I have checked the BBCode via ACP and all is in order. The data is two columns wide with approximately 60 rows.

If needed I am happy to install a plugin that will assist with the solution.

Any assistance would be appreciated
User avatar
ssl
Registered User
Posts: 1813
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: Excel xls/csv to Table

Post by ssl »

Try to add this BBCode

Using BBCode

Code: Select all

[excel]{URL}[/excel]
HTML

Code: Select all

<iframe src='https://view.officeapps.live.com/op/embed.aspx?src={URL}' width='100%' height='500px' frameborder='0' style='resize: vertical'></iframe>
Help

Code: Select all

[excel]file_URL[/excel]

Place your xls files in a xlsfiles/ folder on your server with a CHMOD 0775, each xls file will have a CHMOD 0664
Sorry for my English ... I do my best!

phpBB: 3.3.12 | PHP: 8.3.7
[Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 5963
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.

Re: Excel xls/csv to Table

Post by thecoalman »

This won't get it into a post but you can use HTML in the pages extension.

https://www.phpbb.com/customise/db/extension/pages/
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison
User avatar
warmweer
Jr. Extension Validator
Posts: 11383
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: Excel xls/csv to Table

Post by warmweer »

vk3ymml wrote: Wed Jan 31, 2024 8:06 pm
If needed I am happy to install a plugin that will assist with the solution.
3 BBcode extensions providing a table BBcode

There's ABBcodeBox that has a simple BBcode for tables

There's also CKEditor (better looking tables, but less intuitive to configure).

It's been quite a while since I last used tables with more than 6 records and 2 columns but I remember it being straightforward but time consuming.
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
vk3ymml
Registered User
Posts: 7
Joined: Tue Jan 30, 2024 10:35 pm

Re: Excel xls/csv to Table

Post by vk3ymml »

ssl wrote: Wed Jan 31, 2024 8:53 pm Place your xls files in a xlsfiles/ folder on your server with a CHMOD 0775, each xls file will have a CHMOD 0664
I have added the BBcode however I dont have a xlsfiles/ directory, where does that need to be created?
vk3ymml
Registered User
Posts: 7
Joined: Tue Jan 30, 2024 10:35 pm

Re: Excel xls/csv to Table

Post by vk3ymml »

warmweer wrote: Wed Jan 31, 2024 9:09 pm
vk3ymml wrote: Wed Jan 31, 2024 8:06 pm
If needed I am happy to install a plugin that will assist with the solution.
ABBcodeBox CKEditor

I have tried ABBcodeBox, however the same result, the BBcode just came up as text even though its all been inserted into the ACP - BBcode
User avatar
warmweer
Jr. Extension Validator
Posts: 11383
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Bel ... gium

Re: Excel xls/csv to Table

Post by warmweer »

vk3ymml wrote: Wed Jan 31, 2024 9:29 pm I have tried ABBcodeBox, however the same result, the BBcode just came up as text even though its all been inserted into the ACP - BBcode
Just did a quick search and came up with: Convert a CSV, EXCEL, WORD, OPEN OFFICE, FIREFOX table into BBCODE for PHPBB forums

I haven't tried it but will one of these days.

But if this works as advertised, it would make it a lot easier to show nicely formatted tables (even allowing some custom formatting).
Spelling is freeware, which means you can use it for free.
On the other hand, it is not open source, which means you cannot change it or publish it in a modified form.


Time flies like an arrow, but fruit flies like a banana.
vk3ymml
Registered User
Posts: 7
Joined: Tue Jan 30, 2024 10:35 pm

Re: Excel xls/csv to Table

Post by vk3ymml »

I have installed CKEditor, it seems great however when I post either BBcode and or html neither provide the end resulting table
when previewed.

All I get is just raw code that I posted but in the preview area, I gather there is something simple that I am missing
vk3ymml
Registered User
Posts: 7
Joined: Tue Jan 30, 2024 10:35 pm

Re: Excel xls/csv to Table

Post by vk3ymml »

After a lot of research and maybe a few curse words, I have found a solution.

Install the Plugin: phpBB Media Embed PlugIn - https://www.phpbb.com/customise/db/exte ... ediaembed/

Create a Spreadsheet file under Google Docs, you can then embed the file into a posting
on your forum!!

Ref: https://www.phpbb.com/customise/db/exte ... pic/229501
User avatar
ssl
Registered User
Posts: 1813
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: Excel xls/csv to Table

Post by ssl »

vk3ymml wrote: Wed Jan 31, 2024 9:10 pm
ssl wrote: Wed Jan 31, 2024 8:53 pm Place your xls files in a xlsfiles/ folder on your server with a CHMOD 0775, each xls file will have a CHMOD 0664
I have added the BBcode however I dont have a xlsfiles/ directory, where does that need to be created?
Creat it on your server
Sorry for my English ... I do my best!

phpBB: 3.3.12 | PHP: 8.3.7
[Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
vk3ymml
Registered User
Posts: 7
Joined: Tue Jan 30, 2024 10:35 pm

Re: Excel xls/csv to Table

Post by vk3ymml »

ssl wrote: Thu Feb 01, 2024 5:52 am
vk3ymml wrote: Wed Jan 31, 2024 9:10 pm

I have added the BBcode however I dont have a xlsfiles/ directory, where does that need to be created?
Creat it on your server
Yes, However I found an easier solution that is accessible to all forum members,
User avatar
ssl
Registered User
Posts: 1813
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: Excel xls/csv to Table

Post by ssl »

And let the community benefit from it
Sorry for my English ... I do my best!

phpBB: 3.3.12 | PHP: 8.3.7
[Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
Floyd
Registered User
Posts: 189
Joined: Tue Sep 03, 2013 10:16 am

Re: Excel xls/csv to Table

Post by Floyd »

vk3ymml wrote: Thu Feb 01, 2024 5:18 am After a lot of research and maybe a few curse words, I have found a solution.

Install the Plugin: phpBB Media Embed PlugIn - https://www.phpbb.com/customise/db/exte ... ediaembed/

Create a Spreadsheet file under Google Docs, you can then embed the file into a posting
on your forum!!

Ref: https://www.phpbb.com/customise/db/exte ... pic/229501
The Advanced BBCode Box extension also works with Google docs.
Entropy is maintenance free.

Return to “phpBB Discussion”