transfer data from diadem to excel

[mdemas]

Hello,

I have a problem concerning data transfer from diadem 11.1  to excel 2003. I have several hundred of measuring channels in one group under diadem and I want to select only one hundred of them (always the same) and transfer it to excel at a specific place( One channel in one columns always the same too) to make some calculations and data treatment. The biggest problem is that channels under diadem have not always the same channel number depending of the measuring hardware and are not always all present depending of the test configurations( some sensor are not always in use). So I want to select the channel  using the name of the channel (which is always the same).I was thinking to make a loop like this: ( I dont know the correct syntax sorry)

For i 1 to 100      '100 is the number of channel that i want to extract

   if channelnames = channelnameslist (i)    'Channelnameslist would be the list of the channel names that I want to pick out.

   then excel export at excel.column (i)

  end if

else

Is something like that possible?

Thank you for your help.

Mathieu

[Brad_Turpin]

Hi Mathieu,

You have several options when exporting from DIAdem to Excel:

1)  Use the Excel Export Wizard

2)  Create a TDM or TDMS file and then load that file into Excel with the Excel TDM Add-in

3)  Create an ASCII file and then load that ASCII file into Excel with its ASCII Import

4)  Use ActiveX to send values directly to an Excel sheet

Each of these options has various pros and cons.  For options 1-3 I would suggest you rearrange the selected channels in DIAdem into the order you want to see in Excel.  You can either use the ChnMove() function or the ChnCopyExt() function for this purpose.  Options 1-3 all have the ability to export a selection of channels from the Data Portal, but they will generally export them in the order they appear in the Data Portal, for options 2,3 you would use the DataFileSaveSel() command with either the "TDM" or the "CSV" DataPlugin parameter.

Option 4 is very flexible but is harder to program and is slower than the other three options.  How many data points do you have per channel?  How many hundred channels will you want to export at one time?

Brad Turpin

DIAdem Product Support Engineer
National Instruments

[mdemas]

Hello Brad

Thank you for your quick response.I have find a solution using the function channel renumber. I compare the name of the cahnnel to a list of the one that i want and change the number to put those channel in the good order on top of my group and then export it with an stp files. It works well actually but it will not be very easy to modify the channel order and name (you have to modify the script).

To respond to your question i have 700 channels and want to pick out 112 of them. 

Mathieu