Export edited columns to Excel

DodoOliveira

I have a problem to export a column of my table, this column was edited using this example
https://www.c-sharpcorner.com/article/incell-edting-using-datatable/ it works but when I export to Excel this column is null.

kthorngren

Looks like the edit functions only update the HTML of the table. Datatables doesn't know about these updates. You might need to use cell().invalidate() or row().invalidate() to have Datatables updates its data cache based on the HTML changes.

Or you can use cell().data() instead of updating the HTMl directly. This will allow Datatables to update both its cache and the HTML.

If you still need help please build a running test case with the example code provided and we can collaborate on what you need to do.
https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

Have you looked at the Editor which has all the editing code built-in?

Kevin

DodoOliveira

Hi Kevin,

thank you very much for the answer, I managed to solve my problem using row().invalidate()