Importing Excel Spreadsheet 
Autor: Ian S.
Visitado 3010,
Followers 1,
Compartido 0
On oe of the websites I maintain I want to add monthly activites in table format (gives a bette layout). Is it possible to import a table from MS-Excel to the Table object. I do not want an interactive table as it is just the way I receive the information and the ideal way to display it. Copying and Pasting Colmn by Column and Row by Row is very time consuming.
Any help anyone can give would be greatly appreciated. Perhaps if there is not currently a method of doing this Incomedia may like to creat an Object to do so.
Thanks in advance,
Ian S
Publicado en
Ian,
Excel and internet are like a boat and a car, they both do fine but they both need there own platform.
You can however export the excel sheet to html in excel, then set this file in the html object in x5.
But to be honest it does not work very good in my experience. I stopped trying to get this working a long time ago. But maybe it got better?
Another option, that is if it is only to show to your customers, is to make a prtscrn from excel and copy that as picture in x5, that works nicely and has the advantage, or disadvantage, that the information is not scanned by search engines and you can't copy it, only copy the picture but not the data as text.
I used this for a small club that had a few times a year some games and wanted the results published but some did not want to be found through search engines on internet....
Hope this helps you a bit on your way.
Hello Ian
There is also another solution for this.
You could use GOOGLEs spreadsheet (google doc ). This has nearly the same possibilities as excel and You can have more sheets to choose between. You can see an example here : http://www.calendarforum.dk/cottages/cottage-list.html
Please do no remarks of the calendar - I have to make a new installation, as I unfortunately deleted the wrong calendar.
The spreadsheet is very easy to embed in Your site, as google provides You with the code for this.
You could create an account, that only You have access to, or You could give an other person access, so he can maintain the data in the spreadsheet - then You dont't have to do anything more, than embed the spreadsheet in Your site once.
Kind regards
Schwartz
Another solution could be to use the CSV Viewer.
In this, You can show the data in cells and rows, and the users can search and/or sort the data.
Of course You have to export from excel to a csv file, and You have to edit the the object to give it the new data, and You have to upload Your site.
But that is also all You have to do - no copy/paste.
Kind regards
Schwartz
Autor
Thanks to both responces, the export to html works ok for what I want.
Thanks
Ian S