4/24/2016 10:44 AM | |
Joined: 11/21/2007 Last visit: 3/14/2024 Posts: 2323 Rating: (306) |
Hello How do you read out or write tag values with an Excel application?
|
There is no such thing as the last bug in a program |
|
This contribution was helpful to3 thankful Users |
4/24/2016 8:07 PM | |
Joined: 7/19/2011 Last visit: 4/27/2024 Posts: 262 Rating: (5) |
You can install some basic word/excel app which is compatible with window CE platform in comfort HMI |
JAVED AKHTAR |
|
4/24/2016 8:40 PM | |
Joined: 5/28/2008 Last visit: 4/15/2024 Posts: 4505 Rating: (836) |
Hello, As far as I know, it's not possible. But you can already able to open Word , Excel or pdf files on comfort panels. How do you open a Word, Excel or PDF document with a Comfort Panel? |
Ayman Elotaify |
|
4/25/2016 7:11 AM | |
Joined: 7/24/2014 Last visit: 12/4/2023 Posts: 392 Rating: (66) |
Thank you to all for providing me the useful information. And Dear Ayman, I want to log the values of the various real variables to excel sheet but as it is only possible if and only if i have excel application in it but as we know there is only excel viewer installed to comfort panel |
Thanks and Regards |
|
4/25/2016 7:30 AM | |
Joined: 5/28/2008 Last visit: 4/15/2024 Posts: 4505 Rating: (836) |
Hello, You can log the tags in csv format.
|
Ayman Elotaify |
|
This contribution was helpful to1 thankful Users |
4/25/2016 10:34 AM | |
Joined: 5/28/2008 Last visit: 4/15/2024 Posts: 4505 Rating: (836) |
What is the version of MS Office you have. In MS Excel 2010 there is a way to open CSV files in excel. Check this. In later versions (2013 or 2016) It do not open CSV files. Check this one. |
Ayman Elotaify |
|
This contribution was helpful to1 thankful Users |
4/25/2016 6:20 PM | |
Joined: 5/28/2008 Last visit: 4/15/2024 Posts: 4505 Rating: (836) |
Dear Murof, I am sorry for misunderstanding. But I think we are both right. I know that CSV file is a not the excel format like xls or xlsx. What I meant to say that you can take the saved log (in CSV) format and open in excel for further analysis. If you have some knowledge in excel you can make some work in the excel sheet to present the log in the way you want. Moreover, you can create your own macro to read such CSV files. Here is an example for a MACRO made for tag logging in CSV for WinCC V7.2 I am not very much sure if it will work for WinCC flexible or it may be just a guide to do your own macro. How do you export and reimport WinCC Runtime data? |
Ayman Elotaify |
|
4/30/2016 6:19 PM |
|
Joined: 7/19/2011 Last visit: 4/27/2024 Posts: 262 Rating: (5) |
Thanks for the idea , I will check the same ..... |
JAVED AKHTAR |
|
Follow us on