Writing data to excel - with SetCellValue.vi

[suneelkv]

Hi Ni,

I am using SetCellValue.vi from the excel.llb (examples) of NI.

But with some backend logic i am writng Pass to some cells and

Fail to some cells..

Can anybody please let me know how i can add colors for Pass/Fail

i/e Green/Red resp...

Any suggestions are welcomed.

-Suneel.V

[kj101]

Hello Suneel,

Yes, you can programmatically change the colors of the cell inside your excel application.

The attached example vi does the same by making ActiveX calls to the Excel Application.

I hope it solves your problem 

Regards,

Karun 

[suneelkv]

Thanks Karun,

I will try to implement the same in my VI's

And will keep updated.

Be in touch

-Suneel.V

[suneelkv]

I tried to implement the same logic in SetCellValue.vi

But i couldnt find an invoke node with name color...

So this is not working for me...

My req is

1. In some 20 rows
2. few cells will be updated runtime of the exe as PASS
3. and the other few cells are updated as FAIL.
4. even few cells will be remained as empty.
5. So only the cell with PASS need to be updated with GREEN color and
6. and FAIL cells should be RED.

But the ZIP given by u would update a certail row and column range with either green or red color...

Please reply back ASAP

-Suneel.V

[kj101]

Hello Mr. Suneel,

To programatically change the colour in the above VI, you can use the "Value" Property Node of the Color Box.

Right Click the  Color Box, choose <Create>, go to Property Node and then Choose Value.

Then after placing the terminal on the Block Diagram, right click it and select "Change to Write" and wire in a constant (Red or Green Colour)

We use Property Nodes to programmatically modify the appearance of front panel objects.

Thanks.

Karun

[kj101]

Hello Suneel,

Did you try the solution? Do get back to us if you face any other issue.

Thanks.

[suneelkv]

Hi Karun,

I m not working for that project right now.

Will def catch u for the same.

-Suneel.V