Help on Writing to Spreadsheet

[atiikah12]

I have made improvements on my program. Now i am trying to export the data to a file.

I am planning on using Write to Spreadsheet file. Can anyone help me start, and assist me?

Really need help badly.

Thank you in advance.

[GregFreeman]

I would suggestion not using this VI. It opens and closes the file every time it writes -- very inefficient in a loop. I would open a file outside your loop, take the data you want to write to the file and build an array of that data. Use the array to spreadsheet string VI to convert your data to a string, then write to text file to do your logging. Put the close file VI outside your loop so that it is called when the loop exits.

[atiikah12]

hi im very very new to LabView and i'm learning this by myself.

So maybe you could try editing them on the Vi attached? I guess that would help..

[crossrulz]

Open up the LabVIEW Example Finder (Help->Find Examples) and do a search for "Write Text File".  The first item on the list should be Write To Text File.vi.  It looks like a good example of what you want.

[atiikah12]

Attached is what i have done. is that correct? Thank you in advance.

[GregFreeman]

---

@atiikah12 wrote:

Attached is what i have done. is that correct? Thank you in advance.

---

I don't know? Is it? Did you open the log file after your program stopped and see if it was correct? We don't know what you're trying to log. If you really only want to log the max values, and log when the program stops, then yes seems correct. If you want to log continously, then no it's not correct. Did you look at the example Crossrulz suggested? That example will log continuously. But, again, we aren't sure exactly what you need to log.

[atiikah12]

I'm trying to log the data continuously for all 4 sensors. Probably every 5 seconds. 

[GregFreeman]

---

@atiikah12 wrote:

I'm trying to log the data continuously for all 4 sensors. Probably every 5 seconds. 

---

Then look at the example Crossrulz suggested