How to get handson table data as key value pairs json on click of a button

Getting help Questions
1

Hi @aleksandra_budnik ,

I need to get handson table data as key value pairs as json data on click of a button.

2

Hi @sumanthhs48

Maybe this demo will help https://jsfiddle.net/handsoncode/f0b41jug/. It uses custom cell validator, editor and renderer for the key-value dropdown.

3

Hi @aleksandra_budnik

I need complete table data as json key value pair on click

4

So you keep the table data as an array of objects and then you want to retrieve the table data (as I understand the altered data). I am right?

If so here are related topics
https://handsontable.com/docs/api/core/#getdata
https://handsontable.com/docs/api/core/#getsourcedata

5

Hi @aleksandra_budnik
yes but i need json data not array

6

Does this https://jsfiddle.net/f5vcoyzj/1/ work for you?

7

Actually getSourceData() function shows undefined

8

Does my demo return undefined for you?

It returns data for me (on Chrome 99)

00
00473×164 16.8 KB

9

Hi @aleksandra_budnik

Handson table version 0.16.0 it happens here when data is added in this format

const data = [
  ['', 'Tesla', 'Nissan', 'Toyota', 'Honda', 'Mazda', 'Ford'],
  ['2017', 10, 11, 12, 13, 15, 16],
  ['2018', 10, 11, 12, 13, 15, 16],
  ['2019', 10, 11, 12, 13, 15, 16],
  ['2020', 10, 11, 12, 13, 15, 16],
  ['2021', 10, 11, 12, 13, 15, 16]
];
10

The getSourceData was not available in version 0.16. If you update to a newer version the issue is gone.

11

Actually newer version does not support select 2 renderer

12

Select 2 is not an official Handsontable project and we do not support it.

13

Hi @aleksandra_budnik
is there any alternative for select 2

14

Handsontable does not support this functionality yet. If there is an alternative, it is also a 3rd party project.

15

Hi @aleksandra_budnik
Can we get value with handsontable dropdown.

16

Can we get value with handsontable dropdown.

Do you mean how to get the value that was chosen by the user upon change?

17

hi @aleksandra_budnik
<option value="id">Name</option>
value from option

18

Sorry, we do not have any demos other than https://jsfiddle.net/handsoncode/f0b41jug/ for the dropdown key-value subject.

19

Hi @aleksandra_budnik
Thank you