How do you read out or write tag values 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
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
The sample project contains...
- One Excel template
- One Comfort Panel configuration
- One PC Station configuration
The sample project was created with WinCC Advanced V14 SP1 and the Excel template with
MS Excel Professional 2010.
There is no guarantee that the Excel template is compatible with all MS Excel versions.
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.