Forum Stats

  • 3,768,730 Users
  • 2,252,841 Discussions
  • 7,874,701 Comments

Discussions

How to prevent html code while downloading classic report into excel

Anand Jagtap
Anand Jagtap Member Posts: 12 Green 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?


Thanks.

Tagged: