Channel Name Copy

[bm2cox]

I am using the DataBlClpCopy command to copy selected data to the clipboard and paste in Excel.  This works fine but I need a way to copy the channel name also.  This data set can vary and their are 2 groups in my tdm file.  I copy selected data from 1 group and paste it on one sheet and copy selected data from the other group and paste it on a different sheet within the same Excel workbook.  Any help would be appreciated.

[Twigeater]

Hello!

If you want to copy all Data of the selected channels you can use 'ChnClpCopy' instead. This command will add the channel name at the top.

Matthias

[bm2cox]

I am trying to only copy some data out of the middle of the file.

[Twigeater]

Hello!

Than you have to add the names add the top of the clipboard text. Unfortunately DIAdem gives you no direct clipboard read/write access. There was a trick (described in this task) but this will not work with IE7 due to the more restricted security guidlines. We use a OCX for this, but this is not free.

Sorry that I have no solution.

Matthias

[Brad_Turpin]

Hi bm2cox,

Why don't you use the 'ChnClpCopy()' suggestion of Matthias' and simply prepare a new set of channels to export?  It's a workaround, but it should give you what you want.  If you have DIAdem 9.0 or later, I'd recommend creating a new Group to make deletion of the temporary channels easier.  Then copy the selected area of data from the original channels into a set of new channels.  Then use the 'ChnClpCopy()' command to send all the values plus the channel names from the newly created subset channels to Excel.  Finally you'll want to delete those temporary subset channels.

Brad Turpin
DIAdem Product Support Engineer
National Instruments