Hey everyone, I have extensive experience working with PLCs to extract data to Excel. I am now exploring the use of intouch SCADA screens. I have a spreadsheet that pulls data from the PLC and utilizes Excel formulas to calculate certain values. My question is: Can SCADA systems retrieve data/numbers from an Excel cell? In other words, is it possible to create a SCADA display that mirrors my Excel spreadsheet? While I understand that data can be sent from SCADA to Excel and vice versa, I'm curious if the reverse can also be done.
Certainly, it is possible to interact with Excel in Intouch. Instructions on how to achieve this can be found in one of the Intouch manuals. Another option is to utilize an Active-X spreadsheet to view files in Intouch, although the installation of Office Web Components (OWC) is required to enable Active-X functionality. Additionally, there are informative YouTube videos available on Excel communication with Intouch SCADA, including topics such as DDE communication with Microsoft Excel. For further insights, a Google search using keywords like "Intouch communication with Excel" can yield helpful results. Upgrade your Intouch experience by seamlessly integrating with Excel for enhanced data management. #Intouch #SCADA #ExcelCommunication #DataManagement
Former SCADA programmer here! Yes, SCADA systems can indeed retrieve and process data from Excel cells. The specific process might depend on the SCADA software you're using, but one common method is to set up an OLE DB or ODBC connection to the Excel file, treat it like you would any database, and then query the required data accordingly. It might take a bit of setup, but it definitely opens up lots of possibilities. However, note that constantly reading data from Excel into SCADA might not be the most efficient approach especially for real-time systems. An alternative could be to have the PLCs write data directly to the SCADA system and use SCADA's own scripting and computation capabilities to achieve the same functions as your Excel formulas.
Sure, you can retrieve data from Excel to SCADA, but it does vary depending on the specific SCADA package you're working with. Generally, you'd accomplish this via an OPC server, which can read an Excel file as a data source. Keep in mind that with this setup, the OPC server needs to constantly read the Excel file, so any changes in the Excel file will affect the SCADA system. Make sure any formulas and calculations are carefully set up in Excel to avoid unexpected results popping up in your SCADA display.
Yes, it's absolutely possible! SCADA systems, including Wonderware's InTouch, can indeed interface with Excel files to retrieve data. You can leverage scripting languages like Visual Basic for Applications (VBA) to facilitate such data exchange. Just remember that any exchange must be handled carefully to ensure data integrity and security. Something else to consider might be the use of OPC (OLE for Process Control) servers, which can mediate between your PLC and a wide variety of software including Excel and SCADA. This would help remove a heavy dependence on Excel for calculations and likely streamline your setup.
✅ Work Order Management
✅ Asset Tracking
✅ Preventive Maintenance
✅ Inspection Report
We have received your information. We will share Schedule Demo details on your Mail Id.
Answer: - Yes, it is possible for Intouch SCADA systems to retrieve data from Excel. While the primary function of SCADA systems is real-time monitoring and control of processes, they can also be integrated with external data sources such as Excel spreadsheets.
Answer: - Yes, it is possible to create a SCADA display that mirrors the data from an Excel spreadsheet. By setting up appropriate communication protocols and data exchange mechanisms, SCADA systems can display data sourced from Excel cells.
Answer: - Yes, SCADA systems can be configured to read data or numbers from specific Excel cells. This functionality allows for seamless integration between SCADA displays and Excel spreadsheets, enabling efficient data visualization and analysis.
Answer: - Data transfer from Excel to a SCADA system can be achieved through various methods such as using OPC (OLE for Process Control) servers, DDE (Dynamic Data Exchange), or custom scripts. These mechanisms facilitate the exchange of data between Excel and SCADA systems in real-time or at scheduled intervals.
Join hundreds of satisfied customers who have transformed their maintenance processes.
Sign up today and start optimizing your workflow.