Please show me how to insert excel data sheet so that I can edit it online.
Thank you
Insert excel sheet
Re: Insert excel sheet
this is not an Accessibility/Usability issue
you need to be more specific with your request. Inserting a table of data is very easy. If you're looking to actually edit an Excel spreadsheet from within CMSms, that is not possible, to my knowledge.
you need to be more specific with your request. Inserting a table of data is very easy. If you're looking to actually edit an Excel spreadsheet from within CMSms, that is not possible, to my knowledge.
Re: Insert excel sheet
Thank you for response. I regret for any inconvinienece
I will be oblige if you show or provide link showing "how to insert searchable data table"
Thank again
I will be oblige if you show or provide link showing "how to insert searchable data table"
Thank again
Re: Insert excel sheet
Just in case anyone is interested, I'm working on a class (later a CMSms module) to do just this: Embed a Excel spreadsheet in an HTML page.
I find TinyMCE's table abilities difficult to work with. Besides that it doesn't quite work in Chrome, it's rather difficult to style unless you get into the HTML and CSS, which the average customer would rather not do. I do use it with success for a table on a page as part of the initial design, but can't begin to explain to the customer how to add their own tables and make them look good... Everyone knows Excel.
My class requires the user to save their Excel doc as an "XML Spreadsheet" (there is another XML option). This outputs XML data that has all the data, plus styling info into a file. You open the file into a variable, then input it into the class, plus optional arguments regarding which styling to take from the spreadsheet, then it outputs the appropriate stylesheet data, plus HTML table data. I plan on it understanding and translating attributes such as text formatting, justification, colors, borders, cell background, etc.
So far, I have it read the data and output a table with no formatting. However, it does understand horizontal and vertical cell merging and responds with the correct colspan and rowspan attributes. Not tested in Excel 2007 or OpenOffice yet.
The CMSms module would have a control panel which would allow the user to upload an Excel XML file, choose which formatting to take from the spreadsheet and it would provide the class name, so that the table can be further styled in CSS, along with the smarty tag needed to reference this document in their page/news article.
The idea came about during the re-design of my racing club's website. The points table is done in Excel. The site is currently managed with FrontPage, which being an MS app, it handles copying and pasting from Excel quite nicely. Example: http://portlandkarting.com/gcsprint_results.htm . The redesign is using CMSms, and since this ability doesn't exist, we would have to save the spreadsheet as a web page and link to it, or utilize an IFRAME.
If anyone is interested in utilizing what I have, or further developing it, I would be happy to send what I currently have.
I find TinyMCE's table abilities difficult to work with. Besides that it doesn't quite work in Chrome, it's rather difficult to style unless you get into the HTML and CSS, which the average customer would rather not do. I do use it with success for a table on a page as part of the initial design, but can't begin to explain to the customer how to add their own tables and make them look good... Everyone knows Excel.
My class requires the user to save their Excel doc as an "XML Spreadsheet" (there is another XML option). This outputs XML data that has all the data, plus styling info into a file. You open the file into a variable, then input it into the class, plus optional arguments regarding which styling to take from the spreadsheet, then it outputs the appropriate stylesheet data, plus HTML table data. I plan on it understanding and translating attributes such as text formatting, justification, colors, borders, cell background, etc.
So far, I have it read the data and output a table with no formatting. However, it does understand horizontal and vertical cell merging and responds with the correct colspan and rowspan attributes. Not tested in Excel 2007 or OpenOffice yet.
The CMSms module would have a control panel which would allow the user to upload an Excel XML file, choose which formatting to take from the spreadsheet and it would provide the class name, so that the table can be further styled in CSS, along with the smarty tag needed to reference this document in their page/news article.
The idea came about during the re-design of my racing club's website. The points table is done in Excel. The site is currently managed with FrontPage, which being an MS app, it handles copying and pasting from Excel quite nicely. Example: http://portlandkarting.com/gcsprint_results.htm . The redesign is using CMSms, and since this ability doesn't exist, we would have to save the spreadsheet as a web page and link to it, or utilize an IFRAME.
If anyone is interested in utilizing what I have, or further developing it, I would be happy to send what I currently have.
Last edited by Wishbone on Tue Mar 02, 2010 7:38 pm, edited 1 time in total.
Re: Insert excel sheet
Here is a CSV function I worked on some time ago that may help ...
Remove the txt extension..
Remove the txt extension..
- Attachments
-
[The extension txt has been deactivated and can no longer be displayed.]
Greg
Re: Insert excel sheet
@ wishbone
do you have already made a module
if so can you send me something cause i'm looking for a embed excel sheet in html
do you have already made a module
if so can you send me something cause i'm looking for a embed excel sheet in html
