Report generation toolkit conditional format - how to?

[JonEirikS]

Hi

We are using the Report generation toolkit (2010 version), and have a question regarding this tool.

I see functions for setting the number format, but not a conditional format. Does this not exist?

http://zone.ni.com/reference/en-XX/help/372120A-01/lvoffice/excel_set_cell_format/

This page refers to an example which from the name sets a conditional format. However as I understand it, this example is setting a custom number, not a conditional format.

[Mystogan]

Hi,

the simplest way to do this I guess you can provide a template for your Excel sheet, where you can set the conditional format there.

From LabVIEW you can just send the values into this sheet-template.

Maybe you can try these if you want

http://forums.ni.com/t5/LabVIEW/Using-conditional-formatting-in-excel-through-LabVIEW-activeX/td-p/1...

http://forums.ni.com/t5/LabVIEW/Excel-Colour-properties-modified-via-LabVIEW/m-p/573748?query.id=218...

Regards,

Yan.

[JonEirikS]

Thanks for the quick reply.

I cannot use a template as the excel files are dynamically changing with varying ranges of results, and hence cell positions change with result lengths.

I had a look at the links you posted.

I believe there's a compatibility issue as the code is not executable (Excel Color Properties.vi from the first link). I'm using LabView 2010 together with Excel 2007.

The output "Item" on my invoke node"FormatConditions" is purple (variant type?) instead of green (reference type) as in the thread example.