Benchtop Measurement and Test
Distributed Measurement and Control
Systems Engineering Software
Perspectives showcases how NI sees what’s next in the world of test and technology.
You can request repair, RMA, schedule calibration, or get technical support. A valid service agreement may be required.
Provides support for NI data acquisition and signal conditioning devices.
Provides support for Ethernet, GPIB, serial, USB, and other types of instruments.
Provides support for NI GPIB controllers and NI embedded controllers with GPIB ports.
I am having an issue with my VI which I am wondering if anyone has a fix too or workaround.
Basically during my tests I write multiple sets of data to different sheets in Excel using the Report Generation Toolkit.
At the start of my code I open a workbook (template Excel file), I write data to the file at the end of each test for each iteration and then save and close the file at the end.
I have attached a PNG of one of my sub VIs which writes one set of data to one sheet, this could be called numerous times during my code.
The issue I have is that if I am working with a seperate workbook, each time my sub VI runs it will jump to the test results workbook.
I am aware that I do "Get" the workbook in my code and this is why it happens.
Is there a way to call different sheets in a workbook in a VI without affecting the user who is working on a seperate workbook, write data in the background?
I am unsure if it is possible to write data to different sheets in a workbook without using the "Excel Get Worksheet VI" before entering the data.
I also know I could just save all data in arrays and then at the very end write all data to the workbook but this is not a preference
Any information would be gratefully appreciated
Go to Solution.
Sorry didn't mention any details, I'm using the following:
LabVIEW 2010 SP1,
Report Genration Toolkit for LV 2010,
Changed the window state to "No Change" in the new report VI
Seems to have done the trick
What do you need our team of experts to assist you with?
We'll be in touch soon!