I would like to control/format Excel cell parameters, such as location, column width & cell color, for each data string being generated (i.e., For Loop) from a LabVIEW VI and being dumped into a spreadsheet. I used a bit of the code from the ActiveX built-in example “Write Tabel to Excel” VI, but in my situation the Excel file is already “open” (via the “Open/Create/Replace File” VI) and I would simply like to ADD data to this file controlling its cell properties for each chunk of data flowing into the file.
Also, is there a way to display the status of the REFNUMs (whether be via front panel or Operating System file type)?
Try the attached. It could be modified, of course, to work on other methods/properties. The RowColToChange.vi is just a tidying-up of that provided by NI in examples. The FormatRowBorder.vi works from an Excel spreadsheet that is already open.
Thanks for your reply. Unfortunately, I have at my disposition version 6i. I could not convert from version 7.0. If it's a simple task to convert from your end it would be much appreciated....Thank you!
The version I have is 6i...I believe it's one version back of 6.1. It's not compatible. I will have to download the evaluation software of 8.5 to view the code. Thanks for your effort!
Thanks Trey B...the conversion worked. It also literally invoked the "Excel._Worksheet" refnum into my ActiveX Class which I did not have access to before? (When I right click on this refnum on the front panel and choose the "Select ActiveX Class", the "Excel._Worksheet" now appears which it did not before). I'm still a little green with ActiveX components since I'm not quite sure how to correlate this refnum icon to the spreadsheet which was opened with the "Open/ Create/ Replace File" VI?
