Copy multiple cells from excel and paste into a table or editable table

Hi,

Any idea how to implement this feature: Copy cells (multiple rows and/or columns) from Excel and paste them into a table (or editable table) so that the table contents get appropriately filled with the values from the excel? 
Assuming simple data types only, and no advanced features supported.

Regards,

Vikrant Sharma


Hi Vikrant,

The default way to import from Excel is by using the Excel import feature. It's simple to implement and does exactly what you want to achieve.

Kind regards,

Remco Dekkinga


Thanks Remco. Yes the excel import feature is the normal way to implement this. However, the ability to copy-paste cells from excel to the table (if possible) would be really good to have, as it is more flexible and easy to use for the end-user in simple use cases. For example, the user might just want to copy a particular row or column of cells from any existing excel sheet to the web application. Is there any way to support this functionality?

Hi Vikrant,

There is currently no component that can handle this for you, but with javascript, it might be possible.

Excel is just text with /t (tab) delimited data. You can analyze the clipboard data in an OnPaste action that you can implement in your table cells. 

https://stackoverflow.com/questions/11605415/jquery-bind-to-paste-event-how-to-get-the-content-of-the-paste

After this you can split the data and store it in the correct cells via javascript.

It's quite labour intensive, but possible.

Kind regards,

Remco Dekkinga