How to Transfer Data as a List in Microsoft ExcelPrimary Software: Other NI Software>>DASYLabPrimary Software Version: 6.00.03 Primary Software Fixed Version: N/A Secondary Software: N/A
Problem: The DDE connection to EXCEL works, but new values overwrite old values, so that I always see the last value. How can I generate a list in EXCEL ? Solution: First you have to switch the setting for the item in the DDE Output module from Fixed to Generated. Click on the Item button to define the target cells of the list. Use the Row-Column notation as before, i.e. R2C2 (B2), R3C2 (B3), R4C2 (B4). To dynamically create the target cell area, use the two counters (content changes) and 3 text fields (content is always the same) to define the range. First you need to analyse how you will fill the EXCEL sheet. You will see that some parts are always the same, like R or C2 and some parts change, like the row number (R). For example, you want to start entering data in cell B2, or R2C2. Enter as follows: Text Part A = R, Counter1 = 2 and text part B = C2. The other two parts will not be needed for a one column list. Finally, define when and how much the counter should be increased. To create a list with every new value in the next line set Increment By = 1 and Increment After = 1. Disable Restart After to enter data "forever". The maximum length of the list is now limited by EXCEL to 65536 lines. NOTE: Each time you start DASYLab, the DDE Output module starts at the first cell range defined. It will overwrite any data already in the EXCEL sheet. To APPEND to an EXCEL sheet, or any database, use the ODBC modules. Related Links: Attachments:
Report Date: 05/06/2002 Last Updated: 12/07/2004 Document ID: 2L5CM70Z |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
