LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to write to Excel TextBox?

I am using LV 8.2 (and the report generation toolkit).  I am trying to write to an existing Excel textbox.

The closest I can get is Excel._Worksheet.Shapes.Item(0) to get the Shape reference for the textbox, but I cannot seem to figure out how to put text in it.

Any suggested method will be tried, I'm not prideful  Smiley Happy
0 Kudos
Message 1 of 2
(2,923 Views)
Figured it out, see picture.

If your text is greater than 255 characters, you will have to split it and set the Start input on the TextFrame property node to the correct offset to append to what is already there.  Otherwise it does not put the text in the textbox, but does NOT return any error.
0 Kudos
Message 2 of 2
(2,913 Views)