excel style tables

[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!

[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.

[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.