Excel export problem

kreso191

I have DataTable in which some columns have input fields. I want Excel document to contains what is written in the input field. The first thing I do when I get some data from database is this:
result[5] = '<label id="ld' + result[13] + '" hidden>' + result[5] + '</label><input id="l' + result[13] + '" class="nova_sifra" value="' + result[5] + '" ' + dis + '/>';

After the table is generated it will export everything in excel (without this label element it won't export data from input in excel) When I change data in the input field I trigger onChange event that changes the text in the label, but the thing is that the exported excel document doesn't contain changes.

I assume that I need something like $("#ukupna").cell($("[id='"+id2+"']").parent()).data(new_data).draw(); but this isn't working.

kthorngren

Try:
$("#ukupna").DataTable().cell($("[id='"+id2+"']").parent()).data(new_data).draw();

Assuming your selector of $("[id='"+id2+"']").parent() is correct then that should work. Otherwise you will need to use something like cell().invalidate() to have Datatables update its data if you update the HRML directly.

Kevin