Hi. I have a data table. I want to copy data from excel spreadsheet and paste it in the data table. How do i do this.
Hello,
Something like this?
https://webix.com/snippet/cd070519
Also, you can convert your Excel-copied string into a JS array and use the datatable’s mapCells() method to render this data in the component: https://webix.com/snippet/5eb7aa90
Thank you. The 1st option works wonders
See 1st method don’t work in GPL
Hi. I’m struggling with the mapcells. How do i split the cells. When i past the data it splits the rows but all the data for each row is in the 1st cell. So if i copy and paste 5 rows, 4 columns, it pastes 5 rows 1 column. I need it to paste 5 rows , 4 columns.
Please ensure that the editor is not open when you paste Excel data, and if it is, change editAction to “dblclick”.
If you paste all the data into an open editor field, it will be inserted in the cell being edited. If there’s no active editor, the data will be mapped to the needed cells, starting from the current one.
Check the updated snippet, please: https://snippet.webix.com/8sww0ypq
Columns are devided by tabs in Excel, so you should split them by “\t”.
Thank you very much for the help.