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

Report Generation in EXcel

7/27/2013 6:59 AM	Rate (0)
@shish Posts: 291 Rating: (6)	Dear Experts, Presently I am working on excel report generation, my idea is to first tranfer the values of list of tags in SQL server at 6:00 AM every day. I know, for this, I need to write some global scripts to transfer the values to SQL. Help me to write this conditional kind of script ! Secondly, I want to fetch the SQL data to the excel in a report format, that is based on Date. Operator need to select a date to get the production report of that day. Has anybody idea how to get the SQL data into the Excel ? Reg, Ashish
@shish Posts: 291 Rating: (6)
Suggestion To thank Quote Answer

7/27/2013 7:22 AM	Rate (0)
Amit_86 Posts: 1750 Rating: (272)	@shish Dear Experts, Presently I am working on excel report generation, my idea is to first tranfer the values of list of tags in SQL server at 6:00 AM every day. I know, for this, I need to write some global scripts to transfer the values to SQL. Help me to write this conditional kind of script ! Secondly, I want to fetch the SQL data to the excel in a report format, that is based on Date. Operator need to select a date to get the production report of that day. Has anybody idea how to get the SQL data into the Excel ? Reg, Ashish Hello Ashish, Please have a look at follwing entries might be helpful to you at some extend. How can WinCC exchange data with Microsoft Excel or Access? Exporting the database to microsoft Excel
Amit_86 Posts: 1750 Rating: (272)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users OMKRIS2017

7/31/2013 8:26 AM	Rate (0)
efka Posts: 799 Rating: (43)	Hey @shish, have you already thought about using WinCC D@taMonitor? I think this is exactly what you need. Best regards
efka Posts: 799 Rating: (43)	Last edited by: efka at: 7/31/2013 8:27 AM
Suggestion To thank Quote Answer

Share this page:

Share this page on...