LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Writing to Spread Sheet File

You can't get rid of all of the dynamic data types as long as you use the Express VIs. To completely eliminate them, you would have to use the lower level functions that the Express VI calls. You can actually look at the code by right clicking on the Express VI and selecting Open Front Panel.

You have provided a default name and Create function. If you just click OK when the dialog comes up, then it will create that file. If the file exists, you will be prompted to replace it. I think you'll have an error though unless the mode is Create or Replace. With Create, the user has tp specify a new file each time or you come up with a method of automatically creating the file name. A common technique is to get the Date/Time string and append that to a path constant.

With Write File or Write to Spreadsheet, then is no automatic creation of a time stamp. The higher level file write functions like Write LabVIEW Measurement File have that and it gets it from the dynamic data type. I would suggest you try it both ways. Use a single Merge Signals to get all of the dynamic signals togeterh and wire the output to the Write LabVIEW Measurment File. The format of the file created is more or less fixed unless you want to do a lot of modifications to the WLMF function. It's also a bit slower because it also opens and closes the file each iteration. At one end, you have extreme ease of use but little flexibiltiy. At the other, more coding involved but a great deal of control on the format of the output.

0 Kudos
Message 11 of 17
(1,124 Views)
Hi, Is it possible to rely on the wait function and then read the data every second, ie. wait function=1000m/s. So when the data goes to file each row could represent 1 second of data?

I wrote that program using the write LabView Measurement file. I deleted the other write to file text functions, so I have everything merged into the function. I assume it writes to the file that is listed on the top of its configuration window, as no dialogue came up when I ran it. Since I can't actually see the outcome, will this function list the data with automatic headings?
0 Kudos
Message 12 of 17
(1,120 Views)

The file will be written with the properties that you selected. You can have it prompt for a name once, every time, or never. You can have it replace an existing file, append overwrite, etc.

Why can't you see the outcome? It's a text file that you can open with notepad.

0 Kudos
Message 13 of 17
(1,111 Views)
Hi, I'm pretty clear now on what you mean. Do you think the wait function is suitable to use instead of a time stamp? It should be shown in the vi I posted above. I have it set to wait 1 second for each iteration. Will it work out that way, so when I have the data each row will equal 1 sec?

One more thing. You wouldn't happen to have heard of Teledyne Isco. In the set up I have a polymer extruder with transducers fixed along it. I'm going to then use a pump to inject critical carbon dioxide. The company manufactures pumps. I have a cd driver they issued out, and is used to link labview with a pump. It has a stack of vi's on it. I have tried looking for message boards on the subject, but theres nothing on this site. No worries if you've never heard of them before.
0 Kudos
Message 14 of 17
(1,104 Views)

A time stamp does nothing except get the current time. Controlling the rate at which your while loop iterates is doen with the Wait (ms), Wait Until Next ms Multiple, Delay, and Timed Loop functions. For 1 second iterations, the Wait (ms) is fine.

No, sorry, never heard of them.

0 Kudos
Message 15 of 17
(1,093 Views)
Thanks Dennis, you've been a massive help you won't believe. I posted another message 'Get flow rate'. Do you think you could take a look at it?
0 Kudos
Message 16 of 17
(1,093 Views)
0 Kudos
Message 17 of 17
(1,071 Views)