Exporting a 2D table from Report to Excel

[Steve Koza]

I have created an automatic populating 2D table in the Report window.  I would like to copy the contents of the table into excel format.  When I try to copy/paste into excel, I just get a bunch of code.  Is there a way to copy the contents of the 2D table from Report and paste them into another program?

Steve

[Otmar]

Steve,

When you copy an object in REPORT (such as a 2D table), DIAdem will copy the code required to create the object, not the numbers in the table. This is by design and there is no direct way to copy the actual numbers from a REPORT table.

A possible workaround is the "Transfer to VIEW" function on the REPORT toolbar. That function will take the current REPORT layout and copy it into the VIEW area. In VIEW you can highlight the values in the table and Copy/Paste them into Excel. To copy a complete column, click in the first row of the column and the pres and hold Shift&Control" and then hit the down arrow. That will select a complete channel.

I hope this helps with your question,

     Otmar

[Steve Koza]

Thanks for the response, Otmar.  I tried using the "Transfer to VIEW" function to retrieve the data from the table.  When I do that though, all of the other information in REPORT (graphics, 2D axis plots from channel data) imports just fine into VIEW.  However, the table does not populate with the data from REPORT.  All of the data that I have displayed in the table is coded to pull out specific values from channels or channel properties (maximum from a temperature channel, channel length - run time of experiment, etc.).  It looks like the Channel Table in VIEW wants to display entire channels, not the summary data that I'm trying to display in REPORT.  Is it possible to copy a column of the 2D table from REPORT into its own channel?

Steve