LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Read text from a named cell in Excel.

How can I get the text from a named cell in Excel?
I am able to find a cell range (i.e. A3) but I would prefer to get the text from a named cell.
I am using LV 7.1.
0 Kudos
Message 1 of 3
(2,811 Views)
All you have to do is instead of using the cell range (A3), just use the cell name into the into the Cell range node.

The attached image show a bit of code when I had to this to write to a named cell. This code had to create all the references first, so if you already have a reference to your sheet open, you'd probably just need the '_Worksheet>Range" node with the name specified.

Ed


Ed Dickens - Certified LabVIEW Architect - DISTek Integration, Inc. - NI Certified Alliance Partner
Using the Abort button to stop your VI is like using a tree to stop your car. It works, but there may be consequences.
0 Kudos
Message 2 of 3
(2,811 Views)
Thanks, that works great.
0 Kudos
Message 3 of 3
(2,811 Views)