Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => SMF Feedback and Discussion => Topic started by: Killer-B on April 09, 2009, 08:13:22 PM

Title: Excel Spreadsheet (data) into SMF Forum Post?
Post by: Killer-B on April 09, 2009, 08:13:22 PM
Am not the biggest coding person in the world, but was wondering if it was possible to place data (or the actual sheet) from an Excel databook into a Forum Post?

I know (very little) about the "Insert Table" command... and have had limited success getting 2 columns to "show" properly - but have a 5 column spreadsheet with "rankings" that need to be updated weekly - which I created in Excel... I see tables all over the place on other SMF forums... but have no idea how to do this? I'm having some serious alignment issues :(

Can anyone point me to a link that shows how to do this (if it's doable) or offer some tips as to how tables works?

TIA

KB 8)
Title: Re: Excel Spreadsheet (data) into SMF Forum Post?
Post by: H on April 10, 2009, 07:15:15 AM
The only easy way of doing this would be to save the spreadsheet as a csv and then use the CSV to table mod (http://custom.simplemachines.org/mods/index.php?mod=40). This only works in 1.1.x though
Title: Re: Excel Spreadsheet (data) into SMF Forum Post?
Post by: Killer-B on April 11, 2009, 04:51:16 PM
Thanks for the tip.... sorry I didn't respond sooner, as for some reason, didn't get notification of your response - but will try to export them to csv and see if I can make that work... or maybe the other mod will get updated for 2.0 eventually -

Thanks -

KB
Title: Re: Excel Spreadsheet (data) into SMF Forum Post?
Post by: Orstio on April 11, 2009, 06:40:58 PM
In Excel, click on File>Web Page Preview.

When the browser opens with the page, right-click, and View Source.

Copy the parts you want, and paste them into your post.

Note - only works if HTML posting is enabled in SMF.
Title: Re: Excel Spreadsheet (data) into SMF Forum Post?
Post by: Killer-B on April 24, 2009, 02:49:54 PM
Quote from: Orstio on April 11, 2009, 06:40:58 PM
In Excel, click on File>Web Page Preview.

When the browser opens with the page, right-click, and View Source.

Copy the parts you want, and paste them into your post.

Note - only works if HTML posting is enabled in SMF.
Many thanks for that tip.. the other way didn't work very well - so will try yours...

Sorry for the delayed "thanks" but for whatever reason, I'm not getting notifications on this thread (yes, notify is enabled) - so - not sure why it's not doing that....

Either way, "thanks"!!

KB
Title: Re: Excel Spreadsheet (data) into SMF Forum Post?
Post by: H on April 24, 2009, 05:12:45 PM
Glad that did what you wanted. Regarding the e-mail, up until recently we've been having some issues with our mail server. These should now be fixed though.
Title: Re: Excel Spreadsheet (data) into SMF Forum Post?
Post by: Killer-B on April 24, 2009, 09:16:40 PM
Yup - worked fine this time -

Cheers,

KB