Jump to content

Copy/Pasting cells from a LabVIEW table


Recommended Posts

Is there any way to copy data contained in a LabVIEW table and paste it as <tab> delimited into a plain text file or Excel spreadsheet? Whenever I try and paste data copied from a LabVIEW table into an external program (like Notepad/Excel), the data is converted to a bitmap image. This is true of data contained in plots as well as tables. This is also completely useless since the data cannot be manipulated in Excel (or OpenOffice) this way. I know the data could be saved from within LabVIEW to a tab delimited text file but this isn't what our customer wants "because its an extra step that complicates things". Any ideas?

Thanks,

Richard

Link to post
Share on other sites
Could you explain what exactly you do? I do not have that problem, I can copy/paste ASCII information, not bitmaps

-Franz

4968[/snapback]

Sure. Thanks for helping me with this Franz. I'm using LabVIEW 7.1.1. I have a table indicator that contains a bunch of numerical values. I hold the left mouse button down on the table, and then drag the mouse to select some cells. When I right click my selection, one of the options that appears in the popup window is "Copy Data". I click this. Then I open Wordpad, and click the Edit menu, then Paste.

A PICTURE of the LabVIEW table is pasted into the Wordpad document, NOT the text contained in the Labview table. Also, this picture is BUGGED because the cells have shifted around and the column labels no longer match. See screenshots here (open them in something that doesn't AUTOZOOM the image):

http://rcb1974.tripod.com/before_copy_from..._to_wordpad.PNG

http://rcb1974.tripod.com/after_copy_from_..._to_wordpad.PNG

This is definitely a bug National Instruments needs to fix.

Richard

Link to post
Share on other sites
Any ideas?

4962[/snapback]


There are several ways, but the one that came to my mind first was:

If you�re on Windows, over in the Example Code section at ni.com, there�s clipboard.llb.

With it you can do something like in the attached jpg.

If you search the Example Code section for �clipboard�, you�ll get several other hits for Vis (some ancient) that take the keystroke simulation approach.
 

post-55-1118449890.jpg?width=400

Link to post
Share on other sites

Richard,

I just answered in NI's forum to the same posting. Besides pointing to the same clipboard.ddl as swainedonald, I there recommended activex and excel.

The topic http://forums.lavausergroup.org/index.php?...c=1396&hl=excel in the LAVA forum is maybe something that helps, but at least the topic's author will know better than me what to do to communicate with excel

This is another possibly helpful link:

http://sine.ni.com/apps/we/niepd_web_displ...034080020E74861

(Searching for 'labview excel' on NI's homepage gives you lots of good hits)

-Franz

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.