excel to datatable copy paste

Webix JS
1

Hi team,

How to copy paste excel data to datatable.

Thanks

2

have you tried datatable’s editable:true option

3

Please can you provide me the snippet for same

4

https://webix.com/snippet/ba6dfa0f

i have tried with editable:true and select with multi-rows but that doesnt do it. it copies the excel data only one cell

5

Yeah
I want like spreadsheet.
whatever I will copy from excel it should get paste in datatable and should look like excel.Now its pasting all in one cell.

6

https://webix.com/snippet/cd070519 or ?

7

Hi Yuppy,
Thanks for reply.
But I want something like this https://webix.com/snippet/1e76d621

8

Are you getting any solution for it?

9

Hi Meera,

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

Please note that you will have to switch to the “dblclick” editing, otherwise all the data will be pasted into an opened editor.

1 Like
10

Hi Helga,
Can I make something like this
Edit fiddle - JSFiddle - Code Playground in webix

11

I want only one row without header and when I will paste It will calculate rows and columns and accordingly append the data. I don’t want the specific header names just want to paste whatever excel data to the datatable like spreadsheet.

12

Please anybody reply me…