Write data into a spreadsheet

[Elys25]

Hi!

I'm new on labview and I've created a project that measures temperature and water level. I want the data (temperature and water level) to be saved into a spreadsheet. I've attached the project.

Thank you for your help.

[GerdW]

Hi Elys,

I want the data (temperature and water level) to be saved into a spreadsheet.

Your VI already does save the data to a spreadsheet file!

So what is your problem?

(Maybe you should clean up your VI. It would help to put that stuff into one loop instead of using two of them. Charts and gauges allow to make a numeric display visible, so no need for additional indicators…)

[Elys25]

It should do this, but everytime i run the project it doesn't ask me for the path...and if i put it before running the program, it doesn't write anything down there.

Thank you for the advice, i'll use one loop.

[GerdW]

Hi Elys,

but everytime i run the project it doesn't ask me for the path.

Your VI asks me for a path - when the "path" control is empty…

[Elys25]

Hello!

It's quite interesting... Can it be a problem with my pc or something else? I used LABVIEW 2018.

Thank you!

[GerdW]

Hi elys,

it will ask for a path as soon as WriteDelimitedFile is executed. As you probably know to THINK DATAFLOW that happens when you stop both loops...

[Elys25]

Hi!
I'm so sorry to ask you, but can you show me how to do that?

Thank you very much!

[GerdW]

Hi elys,

use the stop button in your loop to stop the loop...

[Elys25]

Hello!

I managed to write my data into a spreadsheet, but now the problem is that i want the data to be written on columns, not on rows. I attached my VI.

Thank you again!

[Yamaeda · Accepted solution]

There should be a "Transpose array"-input, or you'll have to manually Transpose 2D-array beforehand.

/Y