adccommunitymod (AutomationDirect) asked a question.
Pick data from DL205 to Delphi and Excel
Created Date: August 07,2001
Created By: Chit
**** 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.****
i want to monitor data in V-memory by using Delphi. while my application is running, these data will save in excel file. These data will be updated every one seconds and stored in excel. how can i do that? can i use ADO component link with ODBC?
Created Date: September 06,2001
Created by: Mike McClanahan
How many points are you planning on monitoring in the PLC and are you trying to use the excel spreadsheet to log the data? If so why not just use Excel along and use the macros to move the pointer to the next cell when the DDE Link Data Changes?
Mike
Created Date: September 06,2001
Created by: Chit
Thank you.
Anyway, i want to use Delphi 'coz it can link to database and nextwork (i prefer Delphi http://forum1.automationdirect.com/board/smile.gif
So, any idea else :P
Created Date: September 06,2001
Created by: franji1
Chit, are you wondering how to integrate Delphi to Excel or Delphi to the PLC or both?
Created Date: September 07,2001
Created by: Chit
PLC --> Delphi --> Excel ,can u imagine?
Created Date: September 07,2001
Created by: franji1
What is the purpose of Delphi? Is it acceptable to go from PLC --> Excel?
Created Date: September 08,2001
Created by: Chit
Ah, first excel can not compile to EXE file.
second, u can use many useful libraries in Delphi to develop your program, and Delphi is more flexible.
Created Date: September 10,2001
Created by: franji1
Last I checked, Excel is an EXE file (EXCEL.EXE under C:\PROGRAM FILES\Microsoft Office\Office directory). Do you really mean that you do not have Excel installed on your PC that interfaces to the PLC and just want to create an Excel file (.XLS)?
Created Date: September 10,2001
Created by: Chit
Ah, - - '
have u known about some programming language and written it?
i mean, indeed, if u can put data from PLC to Delphi, that u can do anything u want, such as database management, calculating, graphic display and as u wish.
i have been knowing that excel is EXE file, but u know if your computer doesn't have EXCEL.EXE,but has ODBC,u can install your program (made from Delphi) and run under Windows. That does not depend on Excel.
Created Date: September 10,2001
Created by: franji1
Do you know how to do OLE programming in Delphi? If so, there is an OLE interface called OPC (OLE for Process Control) that is supported by Automation Direct's DS-Data Server product that allows you to interface to data in any ADC PLC using that OPC interface.
Created Date: September 11,2001
Created by: Chit
Thank you for all answers http://forum1.automationdirect.com/board/smile.gif
i heard that OLE was old way to interface.
i think ODBC or ActiveX are better than OLE.
nowaday, i use Excel Server in Delphi ,like OLE object. OLE will load excel and run excel under background, but ODBC don't need to load excel in background. That is my experience. http://forum1.automationdirect.com/board/smile.gif