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

Excel data logging, every day need to create new excel book

7/14/2022 11:43 AM	Rate (0)
Soundararajan Posts: 13 Rating: (0)	Hi, Currently am using TIA 15 RT. Am doing excel data logging. Every 5 seconds logging data into excel in csv format. Every day I want to create new excel book. Thanks in advance....
Soundararajan Posts: 13 Rating: (0)
Suggestion To thank Quote Answer

7/14/2022 11:58 AM	Rate (0)
Kahl Platinum Member Joined: 12/16/2012 Last visit: 9/8/2025 Posts: 655 Rating: (132)	Hi! Sounds like you will have to write some scripts. With SIMATIC WinCC (TIA Portal) on a panel, how do you access process data in a file via a script?
	ZEISS SMT
Suggestion To thank Quote Answer

7/14/2022 12:30 PM	Rate (0)
K_Ohjus Gold Expert Joined: 3/5/2017 Last visit: 10/31/2025 Posts: 780 Rating: (130)	Or you can create a scheduled task for log archiving and use only system functions on function list. Press F1 to access TIA help and search for ArchiveLogFile there is an example. Weird thing about the example that archivelogfile is called before making sure all logs are closed. I would consider to use system event all logs closed successfully before archiving.
	- Trying is the first step towards failure. - Singing while you work is not happiness, it's mental illness. - Kaikki on paskaa, paitsi kusi.
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Kahl

7/19/2022 12:13 PM	Rate (0)
Soundararajan Posts: 13 Rating: (0)	Hi, am not used panel view / HMI. Am using PC RT for Excel data logging.
Soundararajan Posts: 13 Rating: (0)
Suggestion To thank Quote Answer

7/19/2022 7:49 PM	Rate (0)
Prof. Frink Platinum Expert Joined: 7/5/2013 Last visit: 1/15/2026 Posts: 3275 Rating: (526)	Hello Soundarajan, on the bottom of Kahl's link there is further information leading to How do you store data with a script in a file with WinCC (TIA Portal) PC Runtime?. Regards, Frink
	Pi is exactly three! All you have to do is think of things which people need but which don’t exist yet.
Suggestion To thank Quote Answer