Read from spreadsheet as string?

[krasing]

I need to read a spreadsheet as a string and am not understanding the directions with the Read From Spreadsheet vi file to convert it from as double to as string.

Someone posted a read as string file in this topic, but I'm running LV6.0, so I can't open it (it's in 7.1).

Any assistance would be most appreciated!

Message Edited by krasing on 09-12-2006 03:21 PM

[Will.D]

Can't convert it, but here's the block diagram.  Hope it helps...

Message Edited by Day on 09-12-2006 04:25 PM

[krasing]

I guess the problem is that I'm not understanding how to do the data type conversion for "type (empty)", "first row", and "all rows".

[Dennis_Knutson]

What exactly is confusing? Once you've made the front panel control visible, you simply click on the numeric control/indicator inside the array, select 'Replace', and pick the string control/indicator from the String palette. The difference between the three is that you first have to be on the diagram and make the 'type (empty)' control visible by right clicking on it and selecting 'Show Control' and whether you replace with a control or indicator. The 'all rows' and 'first row' are indicators and 'type (empty)' is a control.

Message Edited by Dennis Knutson on 09-12-2006 03:06 PM

[krasing]

I think the problem I was having last night was replacing things in the wrong order; I didn't realize that the type selector was hidden and that I'd have to change the visibility to be able to change it, and thought there may have been some subtle nuance involved. Worked brilliantly once I got over that particular lump.