Excel file for continuous data of DAQ

[Billo000]

I am using Mixed Signal Graph to acquire the data of 8 analog channels. The data is continuous and I display it in intervals of 5 s. When I Export Data to Excel file, it only exports the current data. How can I save all the acquired data in the same excel file.

Secondly, "export data to excel" feature seems missing in LabVIEW 2009. Is it so ? Is there any alternative in LabVIEW 2009 ?

Waiting.

[BretD]

Hi Bill,

Would it be possible to upload your vi? I have attached a vi showing writing to a spreadsheet in a while loop. Idk if this will help with your situation, but moving your write to spreadsheet function inside your while loop and indexing the path might be what you have to do.

Bret

[BretD]

forgot the vi...here it is

[systemcrash]

Are you using the graph options available in 2010? Export data to Excel ? If yes, try this have a loop and use shift register build current and previous waveforms and when loop stops use export to excel option.

[Patricia B]

Hello,

I have attached an example from the LabVIEW Example Finder that demonstrates the use of the 'Write to Spreadsheet' Vi. You might also consider using the 'TDM Excel Addin' of which I am including information about below.

Editing TDM(S) files with the TDM Excel Add-In

TDM Excel Add-In Tool for Microsoft Excel User Guide

Moving Beyond Microsoft Excel for Measurement Data Analysis and Reporting

Hope this helps,

Patricia B.

[Billo000]

Hi BretD, please help. thanks. 

[Billo000]

 Hi BretD, 

Thank you very much. I figured out that "Append to File" was not set to True. Thanks again. 

I am stuck in the following. I will be grateful if you can help further:

1. I need to clip the negative portion of 2 waves in Mixed Signal Graph. The data is dynamic data type. How can I see the contents of this data type? and how can I change it e.g. if data value is less than 0, i need to replace it with 0. I have tried Comparison, select blocks but to no use. 

I then used "Value" Property node of graph but it shows the last value of 1st wave only.

2. How can I generate the GUI of the LabVIEW VI so that it runs independently?

Many thanks in advance 

[Che_T.]

Hi Billo000,

Dynamic data types are convenient, but they take more work to manipulate.  Please see the following forum post where this topic is discussed.  Essentially, you'll have to convert the DDT to an array before you can modify it.

https://forums.ni.com/t5/LabVIEW/Waveform-vs-Dynamic-data/td-p/201654

In regards to a standalone exe, you would need to install the Application Builder Module to build it.  You can create an exe from the VI and deploy it to another system.  Please see the following:

https://www.ni.com/en/support/documentation/supplemental/19/introduction-to-the-labview-application-...

Regards,

[Eleftherios]

Hello,

What if we want to control the size of the excel file we are creating so that every 5mb to create a"_part2" and so on...

My problem is that i am acquaring data and only when i stop the program the file is created and then can be checked.

Could i check the size of the file while is being written?

Using LabVIEW 2011.

Thanks a lot

[Eleftherios]

It dawned on my that it was as simple as to create and start filling the file before checking and then, after the check to give it the final inputs (ex .csv) 🙂