Excel Report generation in Wincc Flexible 2005

nehe bhimaji

Member
Join Date
Apr 2007
Location
Dadra And Nagar Haveli
Posts
183
Dear all
I am new user in wincc flexible 2005.My client have requirement of
his daily production batchwise report in excel format.Can anybody help me how can i generate the report in the excel format by the winccflexible?
PLC is
S7 300--------------Wincc flexible 2005 advance
Alenbradly CPU 2005---------Winccflexible2005
Waiting for the reply
My Mail ID [email protected]




Nehe
 
There are endless possibilities.

Just sprinkling some loose ideas into the wind.

There is the general archiving feature. This is best for logging cyclically though.
The log can be done to both simple .csv files as well as to an SQL database.

Then you can write to .csv files via scripts. This is quite simple actually.
.csv files can be opened in Excel.

I think it should also be possible to write to SQL databases from Scripts, but I have never tried it though.
Could be interesting.

It should also be possible to manipulate Microsoft Office (incl. Excel) from scripts, but I think this is much more complicated.
 

Similar Topics

hi my name is shivkumar. i have redundant system with control logix L71 controller and factory talk view 6.1.i want to show or store report in...
Replies
0
Views
1,332
Dear everybody, I am new using WinCC V6.2…. I am trying to data transfer in excel from WinCC… Please help me & tell me what is the...
Replies
2
Views
5,156
Please help me out from a problem which is " 📚:nerves::nerves::nerves:How to Generate Excel report in SCADA Intouch Wonderware[/B][/COLOR]"...
Replies
3
Views
5,179
Can anyone guide me how to print a point current value in an excel spread sheet using Cimplicity. I`ve read the cimplicity help but to no avail.
Replies
3
Views
3,902
hi i am working on rs view32 in which i want to do report in excel.i write the script as follows but it doesnt work. there is a error "file is not...
Replies
3
Views
1,795
Back
Top Bottom