SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

CODE to export data PLC to Excel

11/25/2022 7:16 AM	Rate (0)
Johnnyqn01 Posts: 11 Rating: (0)	Hello guy. I want to export data type int in PLC to Excel. Anyone has a code for it? I use WinCC RT Advanced Thank you so much.
Johnnyqn01 Posts: 11 Rating: (0)	Last edited by: Johnnyqn01 at: 11/25/2022 07:31:38
Suggestion To thank Quote Answer

11/25/2022 7:37 AM	Rate (0)
Stefan Arcularius Platinum Member Joined: 1/21/2013 Last visit: 1/22/2026 Posts: 4424 Rating: (653)	Hi Johnnyqn01, please explain your requirements in more detail? Do you want to export the data from the PLC or should it be done with WinCC? Do you need an automatic export or would it be sufficient to allow copy & paste? Kind regards Stefan

Suggestion To thank Quote Answer

11/25/2022 7:40 AM	Rate (0)
Johnnyqn01 Posts: 11 Rating: (0)	Wincc and automatic export
Johnnyqn01 Posts: 11 Rating: (0)
Suggestion To thank Quote Answer

11/25/2022 9:26 AM	Rate (0)
Stefan Arcularius Platinum Member Joined: 1/21/2013 Last visit: 1/22/2026 Posts: 4424 Rating: (653)	Hi Johnnyqn01, maybe these entry will help you: How do you export and import data in the XML format with WinCC (TIA Portal) Runtime Advanced? Kind regards Stefan

Suggestion To thank Quote Answer

11/25/2022 3:01 PM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 1/21/2026 Posts: 16653 Rating: (1944)	Hello Johnnyqn01 you can use VB Script to write the data toa csv file: https://support.industry.siemens.com/cs/ww/en/view/106501825 Or you can try to use the MS automation interface like it is discribed int the WinCC V7 Manual (works also for Advanced RT (with a few changes)): https://support.industry.siemens.com/cs/ww/en/view/109792622/139193407371 (you have to install excel on the same system in 32 bit) or you work with OPC UA there are also examples for using Excel as OPC UA client Bye Murof
	If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Stefan Arcularius