Export to Excel doesnt convert html cells to text

[akraines]

I have a column with dataType = 'html', and the cells contain html, I'd like to control the export to excel option to strip out the html. How can this be done?

[akraines]

In the meantime I used the following approach:
//Remove all html tags from exported data. (can be tweaked to only act on html columns)
.map(w1.sheets, s => _.map(s.rows, r=> _.map(r.cells, c=> _.isString(c.value) ? c.value = c.value.replace(/<[^>]*>/g,"") : "")));

[paramvir]

Good approach!

Another way is to write column.render callback for html column and remove html tags from ui.cellData when ui.Export is true.

Code: [Select]

render: function( ui ){
  if(ui.Export){
    return ui.cellData.replace(/<[^>]*>/g,"")
  }
}


[akraines]

Thanks - that is much better - it will work for all forms of export - so I don't need to special case xslx.

[Sivakumar]

Getting the following error in console

Cannot read property 'replace' of undefined.

[paramvir]

This error may be caused if there are undefined values in your column data.

in which case it may be updated to

Code: [Select]

render: function( ui ){
  if(ui.Export){
    return ( ui.cellData || "" ).replace(/<[^>]*>/g,"")
  }
}