LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Reading multi line single excel cell as single string element

How to read multi line excel cell as single string indicator or only in one index of array.

0 Kudos
Message 1 of 4
(1,669 Views)

Hi pizviz,

 

did you try to read the cell as usual?

It shouldn't matter of the cell content is a single-line string or a multi-line…

Best regards,
GerdW


using LV2020 on Win8.1+cRIO
0 Kudos
Message 2 of 4
(1,645 Views)

I agree with Gerd.  Make sure your string indicator has the option "Limit to Single Line" unchecked and it should work. 


aputman
LabVIEW 2017
LabVIEW Programming
0 Kudos
Message 3 of 4
(1,626 Views)

... and I agree with the previous two responders.  But I haven't "done the test", myself, and am willing to admit that (depending exactly on what you mean and how your data are organized), I might be wrong.

 

So if you are still having trouble despite three of us telling you "Don't Worry, It Will Work", then (a) let us know, and (b) attach both your code (as a .VI, please, no pictures) and a (small) sample Excel file.

 

Note that it is easy to confuse a "Delimited Spreadsheet File", which is a text file divided into rows and columns by New Lines and a Separator Character, usually having the extension .csv, with an Excel Workbook that has the extension .xls or .xlsx.

 

Bob Schor

0 Kudos
Message 4 of 4
(1,607 Views)