Hello,


I'm building up a plant genetic website for a government institution, and I have found your extension about tables very useful.

Great experience with you about the SBD 301 redirect. I was the one left the feedback and suggested you the additional features!

I'm here again to ask you how is it possible to automatically fill a table created with your extension in my website with an excell file of 313 raws?


Bye.



Ticonzero.

Hi,

Many thanks for the vote, much appreciated...

Glad you liked our other plugin. Thought I better reply before we try to upgrade the forums, and overhaul some of the site (bound to break something - worked fine in test)

Anyway, with regard to your question, unfortunately there is no easy way. The plugin works directly on a HTML table in your article based upon the tables id. The only way you can get it to work is by doing something along the lines of:

1) Save the excel file to a HTML file.
2) Parse the HTML file with something like dreamweaver to remove MS extra CSS and controls.
3) Remove any other unwanted formatting.
4) Copy just the table from the HTML file and paste it into your Joomla article and add the table id and nicertables code to allow the plugin to work.

I hope that makes sense....

OR you could try highlighting the cells in excel you wish, then copy these and paste the into your article - I think it will copy the table formatting (but might also copy unwanted formatting/CSS etc), this may only work with certain editors - we are using JCE.

Hope this helps.

Many Thanks

A simple way to get excel data out without the dreadful markup of HTML export is this: insert columns in between the data cells:
insert first column: <tr><td>
insert in between columns: </td><td>
append last column: </td></tr>
In Excel you can hide these even.

When it comes to export: simply select all and paste as text.
Works for me.