Is there a way to title the columns of a spreadsheet using a 'write to spreadsheet' function?

[ssteel]

Is there a simple way inorder to get the first row of every file I create to be titles?

[Christian Mergl · Accepted solution]

Not with "Write to Spreadsheetfile.vi". You can use low-leven file I/O functions to do that.

Christian

[Coq_Rouge]

---

Christian_M wrote:

Not with "Write to Spreadsheetfile.vi". You can use low-leven file I/O functions to do that.

Christian

---

I do not agree. The "Write to Spreadsheetfile.vi" can very easy be modified to this. This VI is an open VI that can be opened and modified by the user. The built in Labview functions is not some holy grail never to be touched or tweaked. Take a look at my draft. Just remember to use "save as" then saving and do not save in the vi.lib folder

[Christian Mergl]

There are always (most of the time) different ways to get something working.

The reason why I don't suggest to modify vi.lib VIs is that users very often save them as the origin, and this might cause problems in future.

You mentioned it right with your last sentence.

Anyway I'm not a friend of using "Write to Spreadsheet File.vi" when I have to write different datatypes, or a header or modify something.

This all could be done very easy with the lowlevel functions, this with better performance and more possiblities.

But you are right, to modify the VI works too.

Christian

[Coq_Rouge]

Actually Christian! Then I have messed up the Labview by overwriting built in Labview functions. I enjoy calling NI support and yell to them for selling such buggy software. It gives me the feeling of having the upper hand

[S11235]

I don't know if this fits what you are looking for but I find this is a fairly easy way to title an excel document for a quick export. The string to array can be avoided if you already have an array of strings (Scilab output does not allow groups of strings so that is already a comma seperated variable).

[RavensFan]

Thanks for your example, but why are you posting it to a year old thread?  I would have hoped the original poster had found a solution by now.

[S11235]

I was looking for an answer to the above question and didn't find an answer that worked easily so once I worked it out for my self I thought it could work as advice to others.

[worldviol]

could you please tell me in detail that how can I title the columns by using low level file I/O function?! I mean which one should I choose and ...,

Sry that my question looks primery beacuase I am beginner. 

  thanks

[crossrulz]

You can simply use the Write to Text File.  I would put the headers in a string and then use the Array to Spreadsheet String to get the text to write.