Skip Navigation LinksHome Page > Forums > SpiraTest Forums > SpiraTest Issues & Questi... > Report Customization - Hi...

Report Customization - Highlight cells in an Excel Report

Wednesday, December 23, 2015

reporting

customization

bkstigler

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'">

<xsl:value-of select="Passed" />

</td>

</xsl:if>

<xsl:if test="MyXMLval='Bad'">

<xsl:value-of select="Failed" />

</td>

</xsl:if>

1 Replies

Tuesday, January 5, 2016

inflectra.david

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: 2524

Report Customization - Highlight cells in an Excel Report

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

Edit Thread

Edit Message

Search Results