Help - xlsx recipe escaping single tick to '

[torydouglas]

Hello,

Can anyone tell me how to handle a scenario where the json data has a property value with a single tick character. Example "name": "Jan B'laha" is showing up in excel as Jan B'laha. I want it to be displayed in excel as a '

Thanks.

[jan_blaha]

It is likely the handlebars who is escaping. You need to use triple brackets to avoid escaping.

{{{text}}}

https://playground.jsreport.net/studio/workspace/r1vaurbw/285

[torydouglas]

That fixed it. Thank you very much.