Applies To:
  • CitectSCADA 5.xx
  • CitectHMI 5.xx

I would like to be able to transfer data from CitectSCADA to an MS Excel spreadsheet, or vice-versa. How do you configure Citect to handle this? 

To do this, it is easiest to use CitectSCADA's DDEDRV driver. This allows you to define variable tags using the cell addresses in the spreadsheet. For example, if you want to see data in cell A1, your tag address must be R1C1 (Row 1, Column 1) if you have the English version of MS Excel. This is because in Excel, the syntax of the cell address is RxCy - where "x" is the row number and "y" is the column number. In other language versions of Excel, this format will be different:

Spanish: F1C1 (Fila 1, Columna 1)

German: Z1S1 (Zeile 1, Spalte 1)

If you are using a language version of Excel other than English (but are running an English version of Citect), you must open Excel and go to the Tools menu | Options... | General tab and enable the R1C1 Reference Style check box so that it will not use its default format that the DDEDRV driver cannot interpret.

Also, the following parameter must be defined in your CITECT.INI file:


NOTE: "I/ODeviceName" refers to the actual name of your I/O Device in your I/O Devices form (i.e. IODev1).

This allows data that is updated in Citect to be reflected in the Excel spreadsheet, and vice-versa.