LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Changing the Font or background color of a cell in a spreadsheet

Hi
Does anybody know if it is possible to change the font or background color of a specific cell in a spreadsheet?
0 Kudos
Message 1 of 3
(2,874 Views)

Hi,

This can be done easily if you add the microsoft office toolkit. it contains all what you need to control the font the color and any other specification in excel. If you don't have this toolbox you can still do this if you are familiar in activex.

Tareq

0 Kudos
Message 2 of 3
(2,869 Views)
If you are using activex property nodes, Active Cell, Interior, Color gives you a variant value. Wire an I32 into the Variant to data and then into a Color to RGB to find out current cell background color. You should be able to reverse this to set the color.
0 Kudos
Message 3 of 3
(2,866 Views)