Acute Posted March 20, 2009 Share Posted March 20, 2009 Plz, can anyone help me to create an editable table?i mean the table looks like Excel table(read&write table). Any ideas or advises? Link to comment https://forums.phpfreaks.com/topic/150265-how-to-create-an-editable-table/ Share on other sites More sharing options...
markjoe Posted March 20, 2009 Share Posted March 20, 2009 Put text inputs in a table and follow any typical tutorial on form processing. In reality, such a feature would be best with AJAX, but I have no idea what you're really trying to do with such a vague question. Link to comment https://forums.phpfreaks.com/topic/150265-how-to-create-an-editable-table/#findComment-789137 Share on other sites More sharing options...
Mark Baker Posted March 20, 2009 Share Posted March 20, 2009 please, can anyone help me to create an editable table?i mean the table looks like Excel table(read&write table). Any ideas or advises? If you have any javascript experience, take a look at a javascript library like extjs that provides an editable grid. While it can't handle merging and splitting cells as you can in Excel, it provides a lot of basic functionality that is similar in nature. Link to comment https://forums.phpfreaks.com/topic/150265-how-to-create-an-editable-table/#findComment-789238 Share on other sites More sharing options...
bhavik_thegame Posted March 24, 2009 Share Posted March 24, 2009 Ya,, This is possible by Javascript Grids. Have to make use of extreme ajax. BhaviK Link to comment https://forums.phpfreaks.com/topic/150265-how-to-create-an-editable-table/#findComment-792563 Share on other sites More sharing options...
markjoe Posted March 24, 2009 Share Posted March 24, 2009 It appears to me that none of those suggested frameworks provide "Excel" like functionality. They do grids and tables, not editable spreadsheets. I have had to create such an animal in the past, but the functionality was so specific, it wouldn't do you any good. Perhaps I'll look at starting such a project if I can't find one, you've got me curious. Link to comment https://forums.phpfreaks.com/topic/150265-how-to-create-an-editable-table/#findComment-793093 Share on other sites More sharing options...
Mark Baker Posted March 24, 2009 Share Posted March 24, 2009 It appears to me that none of those suggested frameworks provide "Excel" like functionality. They do grids and tables, not editable spreadsheets. Well you're not going to find it easy replicating Excel in javascript. A javascript grid would simply be the front-end tool for presentation and editing. You'd still need server side logic for reading/writing Excel itself. Logically, you'd want the server to read Excel and provide the structure of the workbook to a js grid; edit the data or formatting within the grid itself; and when changes are made to the grid, send a server request to recalculate the worksheets. I've done this using PHPExcel and ext js editable grids, but had problems even then with splitting and merging cells. I also used APC caching to keep the Excel workbook "memory resident" while it was being worked on (for performance reasons); but it's definitely non-trivial coding. Link to comment https://forums.phpfreaks.com/topic/150265-how-to-create-an-editable-table/#findComment-793158 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.