LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to write to Excel values from following measurements to neighbour cells?

Hi,

I build app for some measurements, "end" of this app:

Neues Bild (2).jpg

As you see I have few arrays (with 12 rows). I want to eksport 2 arrays to Excel. In upper case results looks like this:

Neues Bild.jpg

And everything is OK, this I want, but... When I run app next time I want to save this next results in columns C and D in the same file. Next app run - columns E and F, etc. How can I do this?

Regarsds

0 Kudos
Message 1 of 8
(1,961 Views)

You are not going to get what you want with that Express VI.  It will just keep adding to your columns.

 

What format are you saving the data in, xlsx or csv or txt?


GCentral
There are only two ways to tell somebody thanks: Kudos and Marked Solutions
Unofficial Forum Rules and Guidelines
"Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
0 Kudos
Message 2 of 8
(1,951 Views)

Adding to column I also did. File format is .xlsx

0 Kudos
Message 3 of 8
(1,945 Views)

Nobody knows how to do this? Please help me.

0 Kudos
Message 4 of 8
(1,922 Views)

Can anybody help me?

0 Kudos
Message 5 of 8
(1,902 Views)

Hi gomulka,

 

can I see the settings of your Express VI ? I think what you are looking for i this option:

 

AppendToFile.PNG

And then you should said a "False" constant to the "Reset" Property of the Express VI.

 

Important is that the .xls File should be created by the express VI, if not some errors could occure

 

Best regards

 

Matijas

0 Kudos
Message 6 of 8
(1,873 Views)

Settings are the same you shown. I also placed False state to the Reset of Express VI and results are added to the same column, not the next columns.

0 Kudos
Message 7 of 8
(1,823 Views)

Express VIs (such as Write to Measurement Files) are basically "shortcuts" designed to provide a quick fix, but rarely allow much flexibility, such as allowing you to determine where to put your data on subsequent writes.

 

What you are trying to do can be done with the Report Generation Toolkit, which includes components that directly link to Excel (I'm not sure if Write to Measurement File actually uses Excel or simply writes data in an Excel-compatible format).

 

However, there's a minor complication.  The task you have stated is to write columns, with subsequent columns going to the right of existing columns.  There's a function in the Excel-specific sub-Palette to find the last row, which you can use to write rows, with subsequent rows going below the last row.  It's not too difficult to use the functions in the Report Generation Toolkit to basically do what you want, but it isn't exactly straight-forward.  It would be a lot easier if you could write your data in rows ...

 

BS

0 Kudos
Message 8 of 8
(1,807 Views)