Report Customization - Highlight cells in an Excel Report

Wednesday, December 23, 2015
Avatar
I would like to highlight certain cells in my Excel report with a background color.  I've tried the below structure - which works for HTML output... but not for reports in Excel 2007.
Does anyone know of a way to accomplish this report customization?  

FOR EXAMPLE...

<xsl:if test="MyXMLval='Good'">
<td style="background-color:green">
<xsl:value-of select="Passed" />
</td>
</xsl:if>

<xsl:if test="MyXMLval='Bad'">
<td style="background-color:red">
<xsl:value-of select="Failed" />
</td>
</xsl:if>
1 Replies
Tuesday, January 5, 2016
Avatar
re: bkstigler Wednesday, December 23, 2015
Hi Brian

The Excel 2007 format is generated from the HTML and sent to Excel (unlike the 2003 format which converts to SpreadsheetML 2003 format XML), so it should pickup any supported HTML styles.

Please submit a help desk ticket if you need more direct support from Inflectra.

Regards
Adam

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Wednesday, December 23, 2015
  • Last Reply: Tuesday, January 5, 2016
  • Replies: 1
  • Views: 2528