Jump to content

Recommended Posts

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.

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.

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.

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.