02-09-2010 03:54 PM
02-09-2010 04:04 PM - edited 02-09-2010 04:08 PM
This has been asked numerous times. A simple method is to write everything as strings. In LabVIEW 7.1, there are directions on the block diagram of the Write to Spreadsheet File on what changes you need to make. Be sure to save the modified VI with a new name and in a new location.
You would also eliminate the conversion of the scalar to an array. Just use the build array on the numeric converted to a string and the date/time string.
p.s. You've got some strange things in that VI. Why would you ask for the file name the second time the loop iterates instead of the first time. Why are you passing an empty file path for all other iterations? Use a shift register.