adccommunitymod (AutomationDirect) asked a question.
Data Logging to Excel from DL06
Created Date: June 20,2011
Created By: keklon
**** This post has been imported from our legacy forum. Information in this post may be outdated and links contained in the post may no longer work.****
Hi, Can someone point me in the right direction? I have been asked to look into tracking production and displaying real time percentage and target data. I have done some visual basic programing in excel before but my question is. How do I export my count data from a DL06 to a PC program? Specifically Excel. Thank You keklon
Created Date: June 20,2011
Created by: Do-more PE
The easiest way would probably be to put an Ethernet module and use DataWorx software on a PC.
This will save the files off on the PC as .csv files which you can then open in Excel.
Alternatively you could also install a Cmore HMI and log teh data off to a USB pen drive as .csv files as well.
Created Date: June 20,2011
Created by: bcarlton
This item will provide the software communication link between Excel and the PLC. Your Excel spreadsheet will initiate the transfer of information.
Obviously, seeing othe posts there are a few options available.
Created Date: June 20,2011
Created by: Do-more PE
The only problem with KepDirect and Excel is that it will only capture snapshot data when the spreadsheet is open.
If you want true logging then there is a lot of extra programming that will need to be done.
Created Date: June 20,2011
Created by: keklon
Hi, Can someone point me in the right direction? I have been asked to look into tracking production and displaying real time percentage and target data. I have done some visual basic programing in excel before but my question is. How do I export my count data from a DL06 to a PC program? Specifically Excel.
Thank You keklon