Showing results for 
Search instead for 
Did you mean: 

background color xls file

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
0 Kudos
Message 1 of 2
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.
Michael Munroe, CLD, CTD, MCP
Automate 1M+ VI Search, Sort and Edit operations with Property Inspector 4.1, now with a new Interactive Window Manager!
Review the top 24 Impossible with LabVIEW Categories
0 Kudos
Message 2 of 2