Write Multiple Data into Excel

[HeReL]

Hi everyone

I am currently building a project to monitor room temperature using LabVIEW v.6i. I am try to get the data (date, time and temperature) into an excel file. The problem is now i want the data to be seperated into different column. So far the data is filled up in one column per row, as per picture below. I am attaching my VI as well.

What i need to add to make it date in one column, time in one column, and the temp in one colum, all in one row before the new data in another row.

Thanks in advance.

[RavensFan]

That's actually not a LabVIEW issue, but an Excel issue.

You need to get Excel to import the text file in a way that breaks it up into different columns by recoginizing the tab character as a delimiter.

[Todd_Lesher]

Change the file extension to .txt

[ben64 · Accepted solution]

Change your tabs for commas and save your file with the .csv extension. It should open like you want in Excel (you will have to convert the double value to a string).

Ben64

[HeReL]

Thanks ben64

I did changed it to comma and it works =). Now what if I would like to insert header into each column such as DATE, TIME and TEMP on top of the colums?

[RavensFan]

Write that before the loop starts!

[HeReL]

Where..?

At the New File vi or the Write File vi ?

[RavensFan]

After the new file, before the wires go into the while loop.

I would recommend looking at the online LabVIEW tutorials
LabVIEW Introduction Course - Three Hours
LabVIEW Introduction Course - Six Hours

[HeReL]

Thanks. Will go look into that toturial 😃

[ben64]

As Orioles Fan said, add a write file vi after the New File vi (before the while loop) and write to it this input string:

Ben64