From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

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
(2,768 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 LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 2 of 4
(2,744 Views)

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

aputman
------------------
Heads up! NI has moved LabVIEW to a mandatory SaaS subscription policy, along with a big price increase. Make your voice heard.
0 Kudos
Message 3 of 4
(2,725 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
(2,706 Views)