Data column property not displaying

Getting help Questions
1

I’m trying to pass handsontable cells’ data vi ajax json. But the column property is not display. Here is the code:

hot = new Handsontable(container, {
    startRows: 1,
    startCols: 6,
    renderAllRows: true,
    height: 100,
    manualColumnMove: true,
    manualRowMove: true,
    fixedRowsTop: 0,
    fixedColumnsLeft: 1,
    manualColumnResize: true,
    manualRowResize: true,
    colWidths: [150, 200, 100, 125, 125, 150],
    colHeaders: ['Company', 'RFQ subject', 'Deadline', 'Buyer firstname', 'Buyer lastname', 'Email'],
    columns: [{
        data: 'company'
    }, {
        data: 'name'
    }, {
        data: 'deadline'
    }, {
        data: 'firstname'
    }, {
        data: 'lastname'
    }, {
        data: 'email'
    }
    ]
});

Handsontable.Dom.addEvent(save, 'click', function() {
    $.ajax({
        url: "/datatables/add/",
        dataType: "json",
        type: "POST",
        data: {"data": hot.getSourceData()},
        success: function (res) {
            console.log(data.toString());
            closeModal();
        },
        error: function (res) {
            //console.log("error", data);
        }
    });
});

The result is:
data[0][]:
data[0][]:
data[0][]:
data[0][]:
data[0][]:
data[0][]:

2

Hi @bataak
Could you create a working demo (using for example JSFiddle)? It be easier to track and isolate the issue.

3

https://jsfiddle.net/h16bqqdp/

Thanks for your reply.

4

I think that this ajax tutorial can help you achieve your goal. It also explains how to easily save data.

If you’d have any issues implementing - I’m here to help.

5

I assume that you have reached your goal as there is nearly 20 days without a comment.
I’m closing this issue and if you’d need anything please create a new topic.