Export to Excel - Issue


#1

Hi Team,

I am using paid version of Gantt Chart. In my project, we are using export excel feature provided by dhtmlx gantt.

To show priority in different color, I have used below configuration .
gantt.config.columns = [
{name:“priority”, label:“Priority”, align:“center”, width:70, template:function(obj){return “

”+obj.priority+"
";} } **
];
priorityColor_template

when I used export to excel feature, I am getting html content in the priority column. refer below image

image

kindly help me to show only content not the html content in excel .

Regards,
Aravind L


#2

Hello Aravind,
You need to use the columns parameter in the exportToExcel function and specify which columns you want to export. Then, Gantt will return the default values without HTML properties:
https://docs.dhtmlx.com/gantt/desktop__excel.html#exporttoexcel
Here is an example:
http://snippet.dhtmlx.com/5/121a59210