Forum Stats

  • 3,874,212 Users
  • 2,266,682 Discussions


How to prevent html code while downloading classic report into excel

Anand Jagtap
Anand Jagtap Member Posts: 16 Red Ribbon

Hello everyone,

Hope you all are doing well.

So, today I got a task to create a classic report. One of the column needs to be colored as per the value it contains.

Using html coding and case statement into SQL query, I was able to fulfill these requirement. But now, after downloading these report my excel file shows that html code assigned to values e.g. <span ----> value</span>. So is there any way to prevent this?