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

[energy1500]

Hi,

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

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:

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

[crossrulz]

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?

[energy1500]

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

[energy1500]

Nobody knows how to do this? Please help me.

[energy1500]

Can anybody help me?

[Matijas31]

Hi gomulka,

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

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

[energy1500]

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.

[Bob_Schor]

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