How can complete waveform data be written to a excel file using DDE.

[Myquestion]

I want to write a complete waveform obtained through a sub VI to an excel spreadsheet using DDE. Please reply me how to do this in Labview 7.0

[Dennis_Knutson]

Can I ask why you want to use DDE? Microsoft stopped development on DDE quite a while a go and it never worked very well in the first place, imho. LabVIEW still has DDE functions but they're no longer on the palette. They're in vi.lib>platform>dde.llb but I recall ever seeing any Excel examples. LabVIEW 7 does ship with an example called Write Table to Excel that uses ActiveX. NI also sells the Report Generation Toolkit for Microsoft Office that takes a lot of pain away from working with Excel. You can also search this forum for mention of Excel and find a lot of discussion and examples. Other examples can be found here. Lastly, Export Waveforms to Spreadsheet File and Write To Spreadsheet functions give you the ability to create text files that Excel can import. I usually prefer this because I don't have to have Excel installed on the same computer that's creating the file.

[Myquestion]

You are right it is an old process and not used now.
But as an enthusiast I want to solve this matter.

It is easy to write data on an excel spreadsheet using DDE by providing data with rows and colums to write at.

But I want to write complete waveform data obtained by any subvi to a excel spreadsheet using DDE. In my view, rows with colums need to be automatically incremented with the data that should be provided in integer form to the DDE Poke VI. So that it is written to spreadsheet at proper row and column locations.
There needs to be some mechanism to perform such task but not sure if it will be successful. Need some help on this work.

[Dennis_Knutson]

After a little more searching, I found this page with a couple of links to DDE examples with Excel. One of them is specifically for writing an array.