Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Data to Excel sheet

Created by: Dipsw at: 4/20/2009 8:25 AM (4 Replies)

Rating (0)

Thanks 0

5 Entries

4/20/2009 8:25 AM	Rate (0)
Dipsw Posts: 32 Rating: (0)	Hi, I want one data ( Totalizer reading) in Excel sheet. I know how to trigger in daily basis but not know about how to transfer date and total reading in Excel sheet. I know that there is requirement of C or VBS script. Anyone help With details. Regards, Dip
Dipsw Posts: 32 Rating: (0)
Suggestion To thank Quote Answer

4/20/2009 8:49 AM	Rate (0)
April Posts: 1776 Rating: (95)	Hi, for an example see Wincc Information System Working with WinCC > VBS for creating Procedures and Actions > Examples of VBScript > General examples > Example: Using the MS Automation Interface
April Posts: 1776 Rating: (95)
Suggestion To thank Quote Answer

4/29/2009 7:48 AM	Rate (0)
Dipsw Posts: 32 Rating: (0)	Thanks , It is very useful for my project. Regards, Dip
Dipsw Posts: 32 Rating: (0)
Suggestion To thank Quote Answer

4/29/2009 8:00 AM	Rate (0)
Dipsw Posts: 32 Rating: (0)	Hi, Data from Wincc to Excel sheet was done. But i want trigger that script at given time like 6:00 am daily. I found there is provision in Action Trigger cyclic function but how i club with VBScript. Regards, Dipak
Dipsw Posts: 32 Rating: (0)
Suggestion To thank Quote Answer

4/29/2009 10:43 AM	Rate (0)
cumulus Platinum Member Joined: 9/27/2007 Last visit: 12/18/2020 Posts: 993 Rating: (102)	Hi create an action click in the toolbar at the clock-icon (or use CTRL-T) click at the register "Trigger", at "Timer" and at "Add" select as "Event" "Dayly", assign a name and set the time confirm both diallogs with OK. at last call your script in this action regards cumulus
	Learn more about visualization - visit the HMI courses of Siemens AG! siemens.com/sitrain Basic course WinCC (TIA Portal) machine-based https://support.industry.siemens.com/cs/ww/en/view/109758624 Advanced course WinCC (TIA Portal) machine-based https://support.industry.siemens.com/cs/ww/en/view/109758626 Basic course WinCC Professional https://support.industry.siemens.com/cs/ww/en/view/109758618 Basic course SiVArc (Auto. Generation of HMIs) https://support.industry.siemens.com/cs/ww/en/view/109758628 Basic course Energy Suite https://support.industry.siemens.com/cs/ww/en/view/109755577
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on