ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: akraines on December 19, 2019, 06:47:07 pm

Title: Export to Excel doesnt convert html cells to text
Post by: akraines on December 19, 2019, 06:47:07 pm

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?

Title: Re: Export to Excel doesnt convert html cells to text
Post by: akraines on December 19, 2019, 08:40:57 pm

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,"") : "")));

Title: Re: Export to Excel doesnt convert html cells to text
Post by: paramvir on December 19, 2019, 09:35:59 pm

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,"")
  }
}


Title: Re: Export to Excel doesnt convert html cells to text
Post by: akraines on December 19, 2019, 09:41:46 pm

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

Title: Re: Export to Excel doesnt convert html cells to text
Post by: Sivakumar on May 05, 2020, 08:58:18 am

Getting the following error in console

Cannot read property 'replace' of undefined.

Title: Re: Export to Excel doesnt convert html cells to text
Post by: paramvir on May 05, 2020, 09:09:49 am

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,"")
  }
}