Storing of amplitude measurement express data into excel

[riie]

Hi all,

Need some help with my vi.

1) Attached pic show part of vi that is of concern

2) I need to acquire peak to peak measurement of a signal and stored into an excel

3) 100 peak to peak measurements are required

4)  How can I stop the acquiring of data after 100 peak to peak measurements is recorded?

I am not sure why my appended array is 2D when my results only consists of one row of data.

Any suggestion is welcome and I am still learning about labview. 

[riie]

This is the correct vi.

Ignore the vi in the first post

[GerdW]

Hi riie,

3+4) Use a FOR loop instead of the WHILE loop, set to 100 iterations...

2D array: It's because you create your shift register to store a 2D array. And because of the BuildArray node which is set to create a 2D array. Remove the wire from shift register to BuildArray node and the initialization constant, right-click the BuildArray and set to "concatenate" mode, rewire the shift register...

[riie]

By following your steps for the 2D array.

The each value is being stored in different column.

However, data is required to be stored in the same column and it works when the shift registered is stored as 2D array

[GerdW]

Hi riie,

I don't get this:

---

I am not sure why my appended array is 2D when my results only consists of one row of data.

data is required to be stored in the same column and it works when the shift registered is stored as 2D array

---

Can you please clarify why data is required to store in same column and in the same time you want to use more than one column? And why do you wonder why your data is stored as 2D array?

I really don't get this...

[riie]

Hi GerdW,

(Edited) Thanks your method work, and transpose must be set to true for data to be written in the same column.

Next is the program will be run again and the 2nd set of 100 data will be stored in the 2nd column, etc.

Amendation have to be made to achieve this and any guide to how this can be done?

eg.

1st set              2nd set

1                       1

2                       2

(100 values)    (100 values)

[GerdW]

Hi riie,

writing in an additional column in a spreadsheet file is not possible by simple means. In the end you have to load the full file into memory, append the new column and write back into a spreadsheet file...

[riie]

Thanks! That is what I read from other thread earlier on, this prove to be problematic.

Anyways to work around it? Other than using the paid Report Generation Toolkit

[GerdW]

Hi riie,

RGT might be an option.

Using the approach (read file, append column, write file) might be cheaper...

[riie]

So the only free method is using your approach?

(read file, append column, write file)

Thanks!