How do you modify Write to Spreadsheet File.vi numerical controls to string controls?

[Brad22]

I created a constant for the format input and changed it from the default (%.3f) to (%s). I still get an error when trying to connect a string to the vi.

[JellyBeans]

You might end up changing the VI little bit. Use the "Array to spreadsheet string.vi" to convert 2d array into string data

A Rafiq

[Doug (CapeFl)]

You'll need to replace the Numeric Controls inside each of the 2 arrays to Strings Controls.
Simply open the "Write to Spreadsheet file.vi", and on the Front panel, right-click on any Numeric Control inside the 2D Array, select and select . Repeat this for the 1D Array too.
If you then look at the block diagram, you'll see the change from Numerics to Strings. Good Luck, Doug

[markwysong]

Although this will work, keep in mind that the "Write to Spreadsheet VI" is in the VI library of LabVIEW, and any other program that you write will contain the modified version of this VI. Therefore, I would *strongly* suggest that you copy the Write to Spreadsheet file VI to another filename, modify it, and then use that file instead. This will prevent a lot of headaches, should you use the original VI in other programs.

Mark

[Doug (CapeFl)]

Mark,
Very correct - I should have added that to my response - thanks. PS - I've always noticed that your comments and answers are right on the mark - good job. Doug

[Brad22]

Thanks much to both of you!