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.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Write to excel using labview!!!! Please guys, I need your help. (I attached my VI)

So basically I want the values in the cell. Date, Time, Data 1, Data 2 to keep changing in the same cell. Not in other empty cells like shown below:

what I don't want.PNG

 

This below is what I want: 

what I want to generate.PNG

So I DO NOT want to see values in row 6 and so on. How do I achieve this? I want to see values changing in the same cell without stopping the VI.

0 Kudos
Message 1 of 3
(729 Views)

Granted I have never used the excel report generation tool kit but I have a question and suggestion...

 

Do you think you are going to be able to open the Excel file and watch the cell values change while you program is running? That will probably not work due to two programs trying to access the same file will cause a Windows file sharing violation.

 

Instead of "Insert into Array" try "Replace Subset". As I believe Insert will do just that, Insert a new row/column/element and push the rest down or over growing the array. Where as "Replace Subset" will over write the array Row, Column, or element  

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 2 of 3
(707 Views)

I don't know why you'd want do this, but I modified your VI to do as you asked. The problem was that the data in your shift register was growing every iteration.

 

Capture.PNG

0 Kudos
Message 3 of 3
(693 Views)