You are not registered yet. Please click here to register!


 
 
plc storereviewsdownloads
This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
 
Try our online PLC Simulator- FREE.  Click here now to try it.

---------->>>>>Get FREE PLC Programming Tips

New Here? Please read this important info!!!


Go Back   PLCS.net - Interactive Q & A > PLCS.net - Interactive Q & A > LIVE PLC Questions And Answers

PLC training tools sale

Reply
 
Thread Tools Display Modes
Old September 5th, 2007, 08:16 AM   #1
nehe bhimaji
Member
India

nehe bhimaji is offline
 
nehe bhimaji's Avatar
 
Join Date: Apr 2007
Location: Dadra And Nagar Haveli
Posts: 182
Hi! Excel Report generation in Wincc Flexible 2005

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 nehe_bhimaji@yahoo.co.in




Nehe
  Reply With Quote
Old September 5th, 2007, 08:46 AM   #2
JesperMP
Lifetime Supporting Member + Moderator
Denmark

JesperMP is offline
 
JesperMP's Avatar
 
Join Date: Feb 2003
Location: Copenhagen.
Posts: 11,778
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.
__________________
Jesper
3 strikes and you're out
  Reply With Quote
Old September 5th, 2007, 09:34 AM   #3
CharlesM
Member
United States

CharlesM is offline
 
Join Date: Aug 2005
Location: Arkansas
Posts: 1,100
Try doing a search on PLCS.net first. You may find some good ideas like the following

http://www.plctalk.net/qanda/showthread.php?t=19379
  Reply With Quote
Old September 14th, 2007, 01:51 AM   #4
nehe bhimaji
Member
India

nehe bhimaji is offline
 
nehe bhimaji's Avatar
 
Join Date: Apr 2007
Location: Dadra And Nagar Haveli
Posts: 182
Cool

Quote:
Originally Posted by CharlesM
Try doing a search on PLCS.net first. You may find some good ideas like the following

http://www.plctalk.net/qanda/showthread.php?t=19379

Can anybody sent me the sample programm in wincc flexible 2005 with report generation in CSV file or excel file

Regards
Nehe
  Reply With Quote
Reply
Jump to Live PLC Question and Answer Forum

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Topics
Thread Thread Starter Forum Replies Last Post
Citect Vs WinCC - Long Doug_Adam LIVE PLC Questions And Answers 22 October 3rd, 2014 12:56 PM
WinCC Flexible 2005 and My Controls (activex) domased LIVE PLC Questions And Answers 11 August 5th, 2009 03:00 AM
Very slow pc when I install WinCC flexible 2005 micro mulderm LIVE PLC Questions And Answers 6 June 28th, 2007 11:15 AM
Simatic Wincc Flexible 2004 -->2005 STL??? LIVE PLC Questions And Answers 8 August 29th, 2006 05:42 AM
Report generation on Wincc ramcr LIVE PLC Questions And Answers 1 November 19th, 2004 08:00 AM


All times are GMT -5. The time now is 02:52 PM.


.