How to append json array to handsontable?

Tags: #<Tag:0x00007efc60ac38f8>
#1

dataFormat
dataFormat.png957×138 27.3 KB

#2

Hi Kunal,

Here’s a demo that can help https://jsfiddle.net/handsoncode/vsf5ubm9/

If you would need anything more than that please let me know.

#3

Thanks. and how i can fetch only rows which have data, table.getData() return whole sheet includes empty rows. ! Check the attached screenshot for reference.! Here i have data in 0,1 and 3rd row and i dont want remaining rows.

tableData
tableData.png905×399 46.5 KB

#4

Hi @kunal

you can use the isEmptyRow method to check if a given row is empty.
docs: https://handsontable.com/docs/8.2.0/Core.html#isEmptyRow

#5