Murof

Hello

CSV Files are not an MSExcel Format!!!

Its defined as a textfile with column seperators.

But there is also an Application example for proceeding the Log Information on another Computer like this:

How can you graphically display the contents of the tag archive of a Comfort Panel or the WinCC Runtime Advanced on the PC without WinCC (TIA Portal)?

https://support.industry.siemens.com/cs/de/en/view/60520367

Perhaps it helps.

PS you can also open CSV Files with the Pocket Explorer on the Panel but then you can see only the content of  the File and not a formated sight like in MS Excel

Bye Murof

 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.

Murof

Hello Ayman

I think you do not understand exactly what I´m trying to say. 

Of course every Version of MSExcel is able to open CSV Files and Save CSV Files. And in Windows often default Program for opening  CSV Files is Excel. But CSV Files are not a format which is made for Excel like *.xls or *.xlsx!!!!

Because MSExcel mostly crashes the csv Files with its own formatting and changes the structure of the csv Files. 

so this is the reason why I post this Information.

so most user say why cant I open CSV files on Excel Viewers Everyone thinks csv is a Excel File Extension but ist not!

Bye Murof

 Thanks for very helpful information about CSV file Murof

Murof

Hello Ayman

I think you do not understand exactly what I´m trying to say. 

Of course every Version of MSExcel is able to open CSV Files and Save CSV Files. And in Windows often default Program for opening  CSV Files is Excel. But CSV Files are not a format which is made for Excel like *.xls or *.xlsx!!!!

Because MSExcel mostly crashes the csv Files with its own formatting and changes the structure of the csv Files. 

so this is the reason why I post this Information.

so most user say why cant I open CSV files on Excel Viewers Everyone thinks csv is a Excel File Extension but ist not!

Bye Murof

 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?

SMIT SHAH

Dear Experts, 

I want to know if it is possible to install the excel editor or ms excel on hmi comfort panel? 

If yes then how to do it? 

 Dear Smit shah,

I tried but not succeeded. i want to log data in excel creating an object if you have done please share backup or link.

Dear dhaval same with me as i want to log the setpoint changes in excel file along with the time stamp and the operator name all the things I have made ready but the problem is we cannot have proper acess over ms Excel in comfort panel

So the last conclusion is it is not possible to install the excel in hmi

Hi All,

For this confusions of Logging, excel, CSV, TXT, RDB - I made a rigorous test collecting different requirements from forum.

Basically the Comfort panels runs on Windows CE6 & just has an excel viewer. So it is understood that excel editing functions are not available in VB since it doesn't have microsoft Excel installed.

Further question was, Is it possible to install Excel editing if it is not available. As far as I know there are hundreds of free excel editing softwares available, & some of them worked with Comfort panel also. I Won't give any suggestions here because, even if u install a software, the functions available in WinCC VB libraries are not changed & in HMI VB functions are controlled by a specific library which doesn't allow any third party software integration. Functions are fixed & u need to utilise among the available. No addition.

In such background if it is required to have a datalogging/reporting which explores the features of Excel... How to do!.. IT IS NOT POSSIBLE TO USE THOSE FUNCTIONS FROM VB AS OF NOW ON SIMATIC HMI COMFORT PLATFORM.

Yes, We know that Indusoft has got that since long back & Siemens will have to implement this shortly.

For me it worked out easily since the user always wanted to see the Excel files in PC & There was a PC involved. So I did VB on both ends & ofcourse it works perfectly.

If there need to be a requirement overriding the limitations, you can also install an open source WinCE into comfort panel along with other softwares & use it. Something like rooting Android phones. This I have tested & this works like rocket. You can load the processor of comfort panel to hang.

For TXT it is normal system file format functions & Possible to generate/modify/delete from scripting on SIMATIC HMI ENVIRONMENT. CSV is nothing but text functionality where we deliberately mention "," as column separator. (Comma Separated Values). It is only for reading we open it from Excel else there are no excel functions involved.

For RDB u dont need to do anything but while reporting you have just address the data in RDB. & This can be disintegrated only on a PC platform. I Didnt find any function to disintegrate this & create user defined spreadsheets. Am checking on this & post back once done.

Thank you..