• Free Domain Names with Yearly hosting

You are here: Home Joomla Joomla Forums

spacer
Welcome, Guest
Please Login or Register.    Lost Password?

How To Fill A Table With An Excell File.
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: How To Fill A Table With An Excell File.
#827
How To Fill A Table With An Excell File. 2 Years, 9 Months ago Karma: 0  
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.
ticonzero (User)
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#828
Re:How To Fill A Table With An Excell File. 2 Years, 9 Months ago Karma: 14  
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
SimpleByDesign (Admin)
Moderator
Posts: 435
graph
User Offline Click here to see the profile of this user
Gender: Male Birthdate: 1977-09-21
The administrator has disabled public write access.
 
#839
Re:How To Fill A Table With An Excell File. 2 Years, 8 Months ago Karma: 0  
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.
carry2web (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
Copyright © Simple By Design Limited