LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to copy data from "Ex Table"

Hi, I try to copy data from Ex table,but when I select the copy data from the right click, I only get a picture. So how to copy data from "Ex Table" and copy  data to a txt file or excel file? I attach the vi below, wish someone can help me:-)
0 Kudos
Message 1 of 11
(4,603 Views)

Hi,

You have to write the data in the table, using File i/o functions to copy the table's contents to text or excel file

Look at attached VI's

Any doubts, do get back

Regards

Dev

 

Download All
0 Kudos
Message 2 of 11
(4,594 Views)

Hiii, trinight

         Which version of LabVIEW you are using? i am using 7.1 and your vi is not opening here, can you please convert it into the 7.1 or send the jpg of the vi, then i may help you, and give some more description about ur vi.

Thanks,

Nishant

0 Kudos
Message 3 of 11
(4,594 Views)
Hi, Nishant
    I am using Labview8, I post a picture of the vi, wish you can help me, thanks. 

帖子被trinight在02-14-2006 06:26 AM时编辑过了

0 Kudos
Message 4 of 11
(4,595 Views)

Unless someone proves otherwise with an example, I concur with devchander.

You can't just right-click and copy the data in that table.

0 Kudos
Message 5 of 11
(4,573 Views)
Although there is no way to do this interactively in the LabVIEW editor, you could use the Report Generation Toolkit to very easily open an Excel spreadsheet programmatically, then insert the table data into the worksheet.
 
-D
0 Kudos
Message 6 of 11
(4,566 Views)

You can still send the data from your table to the windows clipboard using clipboard.llb\Copy Text To Clipboard.vi which I have attached. (Clipboard.llb is from another post in the forum)

I have modified your vi to do this. So when you run the vi attached the data is formatted into a spreadsheet string and sent to the windows clipboard as a string. You can then go Excel and click cell A1 then paste your data using Edit ->Paste or CTRL+V.

So I would suggest that your panel has a button that you can use to send the data from the table to windows clipboard just before you move over to excel to paste.

Hope this helps you with an alternative.

David

 

Download All
0 Kudos
Message 7 of 11
(4,561 Views)

David,

Is the clipboard.llb something that came in the LabVIEW examples or is it something you developed on your own? Very handy.

0 Kudos
Message 8 of 11
(4,555 Views)
Hi nyc.
 
I found it on the NI forums some time ago so I can't take the credit.
 
 
You are right very handySmiley Very Happy
 
David

Message Edited by David Crawford on 02-14-2006 11:52 AM

0 Kudos
Message 9 of 11
(4,549 Views)
David, its very handy indeed!
good one!

0 Kudos
Message 10 of 11
(4,535 Views)