×
Siemens Industry Online Support
Siemens AG
Entry type: FAQ Entry ID: 69846238, Entry date: 11/28/2017
(9)
Rate

How do you read out or write tag values with an Excel application?

  • Entry
  • Associated product(s)
This FAQ response describes how you can access the tags of an operator panel with an Excel application.

WinCC (TIA Portal) supports use of the web service (SOAP). 
This permits you to access the tags of an operator panel from an external application like Microsoft Excel, as in this example, via Ethernet.

View of the Excel template
 


Fig. 01

Support operator panels/software

  • WinCC V14 SP1 and higher
  • PC Runtime Systems 
  • All Comfort Panels
  • MP/TP/OPs of the 277 series
  • Mobile Panels of the 277 series
  • Mobile Panels 2nd generation

Download
The sample project contains...

  • One Excel template
  • One Comfort Panel configuration
  • One PC Station configuration

 

Creation Environment
The sample project was created with WinCC Advanced V14 SP1 and the Excel template with
MS Excel Professional 2010. 

Note
There is no guarantee that the Excel template is compatible with all MS Excel versions.

Additional Keywords
SOAP connection, HMI panel, HMI operator panel, Word, Table, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, MS 2003, MS 2007, MS 2010, Excel template, Data exchange, Remote access, Export, Import, Evaluation, Read out data, Excel application, Sample application.

Security information
In order to protect technical infrastructures, systems, machines and networks against cyber threats, it is necessary to implement – and continuously maintain – a holistic, state-of-the-art IT security concept. Siemens’ products and solutions constitute one element of such a concept. For more information about cyber security, please visit
https://www.siemens.com/cybersecurity#Ouraspiration.
Support to the statistics
With this function the IDs found are listed according to number (format .txt).

Generate list
Copy URL
Display page in new design
mySupport Cockpit
Related links