tania Posted February 19, 2008 Share Posted February 19, 2008 how do i get my data n time in a series of columns n rows...i seem to get the recent data only in a cell.... Link to comment Share on other sites More sharing options...
AzeoTech Posted February 19, 2008 Share Posted February 19, 2008 Its much easier to log to a CSV file and then load the file directly into Excel. But, if you want to use DDE (only supported by DF-Standard and higher), you can try the attached two excel samples. They use VB script in the excel spreadsheet to move the data down rows. These were written nearly 5 years ago and have not been recently tested, or tested with the latest versions of Excel, but should give you a good start. There are two samples that do essentially the same thing, except one adds data to the bottom of the list, and the other adds new data into the same cell, moving the older data down a row each time. Exceldde.zip Link to comment Share on other sites More sharing options...
tania Posted February 20, 2008 Author Share Posted February 20, 2008 so since i have an DF express updated edition..i am not able to use the DDE broadcast? Link to comment Share on other sites More sharing options...
tania Posted February 25, 2008 Author Share Posted February 25, 2008 so since i have an DF express updated edition..i am not able to use the DDE broadcast? Link to comment Share on other sites More sharing options...
AndyT Posted August 2, 2010 Share Posted August 2, 2010 Update August 2010 ----------------------- This is still valid and now works with latest DAQFactory Express v5.79 which allows DDE and Excel 2003. Just have to change security settings from default in Excel to allow Macros to load and run under Tools/Macro/Security. Nice simple examples that are easy to follow and they both work fine (just edit the chanel name from test to your DAQFactory channel name you want to read in and log). Thanks, Andy Link to comment Share on other sites More sharing options...
polilies Posted May 20, 2011 Share Posted May 20, 2011 Hi I have a question about DDE's working way in openoffice. İs there any one ever use openoffice with it? I tried a few times but didn't success. In "http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_DDE_function" this site there is an explanation, i've try them. DDE Returns data from a DDE-based link. Syntax: DDE(server; file; item; mode) server is the (text) name of a server; for example "soffice" for OpenOffice.org. file is the (text) complete name or IRL (Internet Resource Locator) of the document containing the data; for example "c:\office\document\test1.ods" or "file:///documents/test2.ods". item is the (text) name of the item to return. For example "Sheet1.B3" is cell B3 on Sheet1 of a Calc spreadsheet; "MyRange" is the name of a range in a Calc spreadsheet; "MyItem" is the name of a section or table in a Writer document. mode is an optional parameter specifying how numbers are returned. Non-numeric text is returned unchanged. 0 or omitted: Data is converted to number if possible, using the default cell style 1: Data is converted to number if possible, in US English (en_US) format (for example with Link to comment Share on other sites More sharing options...
AzeoTech Posted May 20, 2011 Share Posted May 20, 2011 First, DDE server is only supported by DAQFactory Standard or higher and you have to enable it from Tools - Document settings. Likely you will need to save your file and restart after changing that setting. Next, make sure things work using the Excel sample, though I guess if you have openoffice maybe you don't have excel. As for your parameters, Server is correct, File I'm not sure about, but you are probably right, Item is MyChannel, mode is probably the same as topic, so should be "Data" or "Time". Link to comment Share on other sites More sharing options...
polilies Posted May 26, 2011 Share Posted May 26, 2011 can't we use variables like "v" channels to broadcast DDE server. any way or something u know? it'll pretty usefull for transporting data from class members to excell cells. Link to comment Share on other sites More sharing options...
AzeoTech Posted May 27, 2011 Share Posted May 27, 2011 No, but you can use a Test D to A channel to do basically the same thing as a V channel but more. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.