background color xls file

[wolf0815]

hi,
short question,
i write in one cells in a table another background, for example blue. some while-rounds later, i wanna save this color information in a xls-file.
how can i do this??

thanks for the support

greeting christian

[Michael_Munroe]

Look at the example file called Write Table to XL. It shows how to open Excel using ActiveX and write a table to a new workbook. Inside the inner for loop, you can create a new vi that sets the Interior.ColorIndex properties of the cell in the same way that the Value is set. Just use two property nodes, the first set to Range->Interior and cascade that output into the reference of the second property node and set it to Interior->ColorIndex.