Write to measurement file, adding column name in text file.

[Mrcn]

Any idea how to solve it?

[NIquist]

Are you trying???  You are concatenating together three strings that need to be built into an array.  Right-click the concatenate VI and select replace, then look in the array palette to find what you need to replace it with.  Also chek out some of the examples (Help > Find Examples...).

Another trick, notice that the spreadsheet VI is white.  That means it is NOT a primitive so you can open it up and look inside...  

[crossrulz]

There is no point in the Replace Array Subset that I am seeing.  You can just delete that.  Then replace your Concatinate String with a Build Array.  Your 1D Array of strings should just go into the Write Spreadsheet File.  You already have the Append To File set to TRUE, so you should be good to go from there.

[Mrcn]

Yes, I'm trying all the time. One problem solved and another is coming on.

So I'm back again with this. It's not working.

Question 2: How to add column names?

[JÞB]

You had list of Column names Make that a 1D array of strings and write the spreadsheet before the loop

Then make the Transpose F on the write inside the loop

[crossrulz]

You really shouldn't be constantly opening and closing a file that you are logging to.  That is what the Write Spreadsheet File does.  Instead, create the file and write your headers before the loop.  Then write your data inside of the loop.  Be sure to close the file once the loop is done.  The "\ Codes" display on the string constants and the Format String are a lot of help here.

[Mrcn]

I did the same example as you crossrulez and look what I got.

I have no idea what the problem is.

[JÞB]

That's because Tim forgot to change the display fomt of his format specifier string.  \\ sends a literal \ they shoub be single \s and \code display so \r and \t a4e return and newline

[Mrcn]

To be honest I don't understand what is inside the string constant wired to  Format Into String, and again I want to use Write to spreadsheet as I want to record data from graph and time.

The problems are:

I can't format separated columns.

I can't add column names.

Please help.

[JÞB]

Ctrl+h. Then read the detailed help!