Page 1 of 1

excel style tables

Posted: Mon Feb 08, 2010 10:20 am
by jd447
Hi,

i'm still wondering what's the best way to show excel style tables (like, price list, rankings,...)?

- i would like to avoid CSS and html tables
- i would like it to be easy to a content editor to edit
- is there a module for that kind of stuff?

i looked around, unfortunatly without having found the answer.

i'm really looking for your help on that one! ;)

jd

p.s. i tried to post it in the layout topic, but there's seems to be a wordpress API error.
n.b. what, the forum is not on CMSMS! :)

Re: excel style tables

Posted: Fri Feb 12, 2010 10:57 am
by tomgsd
I think the best way would be to export as a .csv file and use a plugin to read and display the data as a html table.  You can then just re-export the excel file and upload it when making changes.

I did a quick one recently (see attached - get rid of the .txt extension and add to plugins folder to use).  Just add the following to your page where you want the table to appear:

Code: Select all

{csv2table file="data.csv" tableclass='datatable'}
You can then style it with the .datatable class (or whatever you choose to specify).  The first row will be your table headers and will go in a section, the rest will go in the section in the normal way.

Re: excel style tables

Posted: Fri Feb 12, 2010 11:14 am
by andershz
How about jQuery.sheet? http://www.visop-dev.com/jquerysheet.html
I haven't used it myself, but it looks like it might do what you want.