topic Manual copy paste excel value in LabVIEW

Manual copy paste excel value

klaz — Fri, 11 Feb 2011 16:47:10 GMT

I have a vi which allows users to manual input numeric values (hex). It's a numeric control. However, I found that whatever they copy from Excel cell can't paste into the numeric control front panel. If they copy the content but not the cell, it works. Any clue for this issue? I guess it has to do with the way excel cell is copied.

Re: Manual copy paste excel value

RavensFan — Fri, 11 Feb 2011 16:52:25 GMT

Exactly. The contents of an Excel cell is text data that can be copied. The entire cell itself is an object full of properties. LabVIEW wouldn't know how to handle that object. Suppose you actually copied a range of two cells, how would you want LabVIEW to handle that?

Re: Manual copy paste excel value

hecmar.arreola — Fri, 11 Feb 2011 17:23:30 GMT

I asked a similar question here:

http://forums.ni.com/t5/LabVIEW/Control-that-supports-copy-paste-from-Excel/m-p/1005498

And I believe I came out of it with a working solution. Hopefully this works for you as well.

Re: Manual copy paste excel value

Samuel_S — Mon, 14 Feb 2011 17:06:01 GMT

The Link above is a very good tool to use when trying to solve an Excel copy and paste issue. You can also use an Microsoft Office Excel Spreadsheet Active X control to control copy and paste. I would recommend using a button on the front panel which takes just the text from the cells and not the object.