How to hide HTML controls in downloaded excel

KG_Apex

Hi All,

I am developing an Interactive report where in i wanted to show an asteric in red color (*) next to few column headings.  I am able to achieve it by using a span and coloring it with red color. Eg: Column Heading Name (<span style='color: red;font-weight:bold;'>*</span>)

But i don't want the stars to display in the excel. Is there any way to hide it from excel and just display it on the screen?

Sergio Vega

I don't think this is possible. I usually replace strings in Excel file.

KG_Apex

Well, I was able to fix the issue by myself.

I have used a JS to append asteric in After Refresh DA of IR as follows:

$('#COLUMN_NAME').find('a').each(function(){

  var thName = $(this).text() + " <span style='color:red;'>*</span>";

    $(this).html(thName);

});

Then asterics were not exported to Excel download.

Sergio Vega

Great solution!