From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
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??
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 5.0, now with a new Interactive Window Manager! Now supports full project automation using one-click custom macros or CLI.