Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Regarding Exporting Data from Wincc to Excel

Created by: ssmanku1699 at: 5/17/2011 6:31 PM (10 Replies)

Rating (0)

Thanks 7

Result pages:: |; 1 | 2; |

11 Entries

Entries per page: 10 | all

5/17/2011 6:31 PM	Rate (0)
ssmanku1699 Experienced Member Joined: 8/10/2009 Last visit: 7/19/2024 Posts: 166 Rating: (2)	Dear Friends, I am doing a Project in which I need to export some Tag values in MS Excel at a particular Trigger bit.How can it be possible by without buying any additional software ? Can you plz help me with it? Thanks. Your's truly, Sarabjot Singh Manku

Suggestion To thank Quote Answer

5/17/2011 7:12 PM	Rate (0)
jjh5791 Posts: 11 Rating: (3)	Hi Sarabjot, Are you using TIA Portal V11 for your PLC? If so, you can use the Data Logging feature to write a CSV file with the tag values you want to keep track of. I have posted an example program with a FB to set up and maintain a data log here. You may need to modify it for your application, but it would be a good starting point. Again, only really useful in this case if you are already using TIA Portal V11, but should be an easy solution if you are. Best Regards
jjh5791 Posts: 11 Rating: (3)
Suggestion To thank Quote Answer

5/17/2011 7:33 PM	Rate (0)
UMENCHO Diamond Member Joined: 3/21/2006 Last visit: 12/2/2024 Posts: 10229 Rating: (1181)	How can WinCC exchange data with Microsoft Excel or Access? Best regards, Hristo Mihalev

Suggestion To thank Quote Answer

5/20/2011 10:03 AM	Rate (0)
VladD Bronze Member Joined: 2/6/2009 Last visit: 6/10/2024 Posts: 46 Rating: (23)	Here is simple example of VBS script for writing tag values in csv file from WinCC. Best regards, VladD Attachment WinCC_VBS_WriteTagInFile.zip (3801 Downloads)

Suggestion To thank Quote Answer
This contribution was helpful to 5 thankful Users MANOJ.N JHu hut_3e M.walid glardinois

5/20/2011 12:41 PM	Rate (0)
ABN Posts: 212 Rating: (12)	Hi, If you are using WinCC V7.0 onwards then there is default feature of exporting data to excel or in CSV format. Please check if its ok with you. Export button is available in WinCC Trend control. Post your comments
ABN Posts: 212 Rating: (12)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users hut_3e

5/20/2011 1:53 PM	Rate (0)
ssmanku1699 Experienced Member Joined: 8/10/2009 Last visit: 7/19/2024 Posts: 166 Rating: (2)	Dear ABN , Suppose , If those tags, I dont want to use in Trends , just only want to export it to Excel , Will it work? Thanks. Your's Truly, Sarabjot Singh Manku

Suggestion To thank Quote Answer

5/20/2011 2:08 PM	Rate (0)
SteBo Platinum Member Joined: 10/3/2010 Last visit: 11/18/2024 Posts: 1563 Rating: (192)	ssmanku1699 Suppose , If those tags, I dont want to use in Trends , just only want to export it to Excel , Will it work? did you read the other replies above? Seems already an answer to your question in there
	B r g d s , S t e B o SIMATIC HMI in Online Support Forum
Suggestion To thank Quote Answer

5/26/2011 9:43 AM	Rate (0)
VladD Bronze Member Joined: 2/6/2009 Last visit: 6/10/2024 Posts: 46 Rating: (23)	ssmanku1699 Dear ABN , Suppose , If those tags, I dont want to use in Trends , just only want to export it to Excel , Will it work? Thanks. Your's Truly, Sarabjot Singh Manku Yes, it will work. If you want to write tag values in file on some reasonable cyclic time trigger or on event, script that I attached in uper post will work. Just adjust it to your needs. If you need tag values on 1s or so, it is beter to use functionality provided inWinCC trend control for export values, as ABN statedabove. Best regards, VladD
	Last edited by: VladD at: 5/26/2011 9:48 AM
Suggestion To thank Quote Answer

5/30/2011 5:40 AM	Rate (0)
ABN Posts: 212 Rating: (12)	Dear ssmanku1699 what is ur exact requirement? what is final o/p required by you?
ABN Posts: 212 Rating: (12)
Suggestion To thank Quote Answer

1/22/2014 11:50 AM	Rate (0)
oalqadi Posts: 12 Rating: (0)	Thanks for the script example. it's working but I'm wondering. How can have many tags in the same script? because I tried to add my tags to read it but the script just read the first tag. DataSet = CStr(Now) & ";" & HMIRuntime.Tags("xxx1").Read DataSet = CStr(Now) & ";" & HMIRuntime.Tags("xxx2").Read DataSet = CStr(Now) & ";" & HMIRuntime.Tags("xxx3").Read DataSet = CStr(Now) & ";" & HMIRuntime.Tags("xxx4").Read and how can have second header in the excel sheet. to segregate the data in the excel file. Please advise or who can help me in this issue.
oalqadi Posts: 12 Rating: (0)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users M.walid

|

Share this page:

Share this page on...

Related topics by keywords:

WinCC Scripting

Follow us on