03-07-2016 04:40 PM
I can not find the " Write to Spreadsheet File.vi" in 2015 Labview. I used to have 2012 but now I can not find it! I can see some others with similar icon so I thought "Wire Delimited spreadsheet.vi" is the same but when I read the help It does not seem the same!
Solved! Go to Solution.
03-07-2016 04:43 PM - edited 03-07-2016 04:46 PM
They are essentially the same thing. NI changed the name because so many people thought that you could read/write from/to excel. Adding the word Delimited makes it a little more specific.
What are you seeing that is the difference?
They should create the same file if the same inputs are used. Have you tried it?
The new Vi includes the error clusters because the old Spreadsheet File version used automatic error handkling (yuck).
Cheers
--------, Unofficial Forum Rules and Guidelines ,--------
'--- >The shortest distance between two nodes is a straight wire> ---'
03-07-2016 06:07 PM
This change came about from these two ideas:
Rename Read and Write Spreadsheet file
Revision of many VIs written by NI (usage of the error cluster)
03-08-2016 11:47 PM
Thank you for your response, in the older version I could initialize the 1D input with string to give title to each column of my data but in the new one it does not accept the string. How should I do that?
03-09-2016 12:00 AM
Cheers
--------, Unofficial Forum Rules and Guidelines ,--------
'--- >The shortest distance between two nodes is a straight wire> ---'
03-09-2016 05:56 PM
@SilasIII wrote:Thank you for your response, in the older version I could initialize the 1D input with string to give title to each column of my data but in the new one it does not accept the string. How should I do that?
That still works. The new version is equally polymorphic.
However, it needs to be a 1D string array, not a plain string.
As before, you need two sequential write operations: first the 1D array of strings, then the 2D array of dbl or whatever. (you cannot wire a 1D array of string and a 2D array of DBL to the same write operation unless you made a custom VI to do just that).
Please show us a simplified version your code?