Unable export to Excel with Javascript sourced data but it is working for DOM data

vk4boddu

Export to Excel is not working with Javascript sourced data(JSON) but it is working for DOM data. I can use DOM data but having issue with performance. So I used JSON data to load DataTable but Export option is not working. Please help on this. Thanks in advance.

vk4boddu

Please help on this it is very urgent. I am using the latest DataTable and latest Buttons.

allan

Per the forum rules, please link to a test case showing the issue. If it is urgent, priority support is available.

Allan

vk4boddu

Thanks Alan. This is intranet site so I ca not provide the link. I will provide the code is that ok?

vk4boddu

Alan, I used the same code as given in the Buttons example in this site. When I use DOM population export to Excel working fine. Due to DOM performance, get the JSON data and assigning to DataTable while initializing using the data property after this change Export to Excel is not working.

Here dataset is the JSON data object.

var table = $('#residentReport').DataTable({
data:dataset,
buttons: [
{
extend: 'excel',
text: Export To Excel',
title: 'Report To Excel'
}
]
});

Thanks,
Vijay Boddu

allan

I'm afraid I would need a test case showing the issue to be able to offer any help. http://live.datatables.net and JSFiddle are available if you would like to create one so I can debug it.

Allan

jLinux

What happens when you try to export? Does it export a blank page? does no file get generated at all? are there any errors in the console?

And either the page with the code, or something on live.datatables.net where we could replicate it would be a great help

vk4boddu

Thanks Allan & jLinux trying to help me on this issue. I find the issue and resolved it. My model (which is converting to JSON) has Boolean data type property so it not allowing me to export. Once I changed the data type from Boolean to string for that property it is working fine.