How to import excel into variables in wincc6 0

1. Implicitly or start the wincc software, and open the project you want to export variables.

2. Start the "Tag Export Import" tool.

3. Select the path and name of the file you want to export to, you don't need to write the file extension here.

4. Set the mode to "export" and click the "execute" button to confirm the entry in the message box.

5. Wait until "end export import" is displayed in the status bar.

6. Click the corresponding buttons "var", "con", "dex" and "diag" in "show" to view the files generated after the variable is exported.

1. Start the wincc software and open the project you want to export variables.

2. Start the "Tag Export Import" tool.

3. Select the path and name of the file you want to export to, you don't need to write the file extension here.

4. Set the mode to "export" and click the "execute" button to confirm the entry in the message box.

5. Wait until "end export import" is displayed in the status bar.

6. Click the corresponding buttons "var", "con", "dex" and "diag" in "show" to view the files generated after the variable is exported.

1wincc as the server for DDE and Excel as the client for DDE.

1) Open the WinCC project and add the application in "Computer Properties > Startup" in WinCC Explorer: Add command line argument : V n.

2) After activating WinCC, the WinCC DDE-server dialog box will pop up, click the Tag List button:

Select the variable you want to access from the list and click OK, so that the connection information of the variable will be copied to the Windows clipboard.

3) Open Excel, select a cell casually (double-click), copy the contents of the Windows clipboard into the cell, and then add " before the first character to complete the input of the cell. In this case, the internal and external process data of WinCC can be obtained in Excel.

4) Repeat steps 2) and 3 if you want to access multiple variables).

Note: It needs to be run all the time.

As the server for the DDE, VB acts as the client for the DDE.

1) Open the WinCC project and add the application in "Computer Properties > Startup" in WinCC Explorer: Add command line argument : V n.

2) Activate WinCC.

3) Open VB, place the textbox control on the form, and set the following properties of the control:

a)linktopic＝wincc|Computer Name Shared name of the folder for the wincc project The name of the wincc project. mcp

b) linkitem=wincc.

c)linkmode=automatic 。As soon as the property is in effect, the textbox control will be able to get the value of the wincc variable in the state.

As the client of the DDE, Excel acts as the server of the DDE (local).

1) Open WinCC Explorer, in "Variable Management" to establish the "Windows DDE" channel and connection, in its connection properties:

The computer name is empty;

application" for excel;

The subject "is the name of the worksheet [excel file name], such as [

The data output is Excel**, which can be programmed using VB scripts.