I’m trying to export to excel by using Dhtmlx gantt.exportToexcel method and it returned empty file.
var json = gantt.serialize();
gantt.exportToExcel({
data:json,
});
Can you please help me to find out the root cause of this issue.
Hello Anuj, gantt.exportToExcel() function has the data parameter, although it is not documented. And it doesn’t work as expected. The columns with the templates will be empty when you export them. It will be fixed in the future.
Now, you can specify the data by using this command:
var json = gantt.serialize().data;
gantt.exportToExcel({
data:json,
});
If you check this example by clicking on export to excel button. it will give you the right excel sheet with Parent/Child relationship in excel. When i’m trying with below method. Tasks indented is not clear Parent/Child relationship in excel.