Excel Connector
The OAS Excel Connector product provides connectivity to local and remote Microsoft Excel Workbooks for both read and write functionality. Transform your Excel data management to include live data from Industry 4.0 data sources and elevate your workflows. Display live operational data directly in your workbooks.
Live Dashboards In MS Excel
Display live operational data directly in your workbooks.
The OAS Excel Connector is compatible with Microsoft Excel versions 2007, 2010, 2013, 2016, and 2019, as well as Excel for Microsoft 365.
Each licensed service for the OAS Excel Connector can support unlimited local and remote Excel workbooks. You can even have Excel workbooks access live data over the internet.
a server-based, highly-scalable, network platform that enables the transport and transformation of your data
Data HistorianAchieve fault-tolerant logging, zero data loss, and multi-destination storage with our high-performance Store and Forward technology.
Visualization ToolsBuild Visualizations, User Interfaces, and server configuration interfaces for .NET, web technologies, native iOS and Android mobile apps
Device & Data ConnectorsThe OAS Platform provides rapid communications and connectivity to a wide variety of PLCs, devices, and databases.
IoT ConnectorsConnect to cloud-base IoT gateways such as AWS, Azure IoT Hub, Azure Event Hubs, Kafka, and more.
Alarm Logging & NotificationCapture events on each data point, log to open formats for historical analysis and archiving, and trigger real time notifications
SDKs & APIsExplore a wide variety of Developer Tools and APIs to allow you to create applications and system integrations to execute in any environment.
Networking FeaturesOpen Automation Software implements edge computing with a Distributed Network Architecture.
Download a fully functional trial of Open Automation SoftwareKey Features & Benefits
Industry 4.0 Data Sources
Modbus, Allen Bradley PLCs, Siemens S7 Controllers, OPC UA, OPC DA, MQTT, Sparkplug B, MTConnect, AWS IoT Core, Kafka, .NET, REST Clients, and Databases
Direct Excel Integration
Report and share real-time data in Microsoft Excel Workbooks, reading and writing live values to and from MS Excel using an Excel Add-In.
Real Time KPIs and ROI
Implement operational dashboards with real time ROI calculations and KPIs from live plant production data.
Drive Excel Charts
Using OAS data, you can drive charts, graphs, and calculations from live data points, with as low as a 30 millisecond update rate.
Local and Remote Networking
Data can be sourced from any OAS server, either on local or remote networks, allowing for interactive spreadsheets with enterprise-wide data.
Every Data Source, One Interface
Access data from any data source connected to the OAS Platform including OPC UA & DA Servers, Allen Bradley PLCs, Siemens S7 controllers, Modbus devices, MQTT brokers, Sparkplug B EoNs, and more.
Display KPIs
Create user interfaces for both visualization and data entry. Leverage the extensive array of Excel functions and inspiring online examples to craft an engaging monitoring console for your Key Performance Indicators, highlighting the performance of your production lines.
Transfer Data from Excel to Industrial Data Source
Employ Excel functions to accurately calculate operational settings and effectively transfer data to Industry 4.0 sources, all without the necessity of coding. This approach enhances operational efficiency and streamlines data management processes in modern industrial environments.
Remote Deployment
Deploy Excel workbooks to an unlimited number of workstations, connecting plant floor data and sharing it among colleagues.
Common Use Cases
Order Processing
Similar to the OAS Database Connector, which enables recipe execution to retrieve batch or order operational setpoints from a database, the OAS Excel Connector can perform the same function to update values using Excel lookup functions. Specific cells within a worksheet can be configured to write values to local or remote OAS Tags, which are then passed to the data source defined in each tag.
Data Sharing
Data can be shared across an organization by using OAS as a central live data store, which can be updated from remote workbooks and can share data back to other workbooks. All users can utilize the same workbook utilizing OAS networking.
User Interface
Excel can be used to create workbooks that visualize data meaningfully and summarize plant floor data along with operational targets. Incorporate line charts or bar graphs that display real-time data, providing an insightful visual representation of trends and patterns as they emerge.
Looking for a web user interface? Learn more about the UIEngine
Learn how thousands of customers are using the OAS Product Platform around the globe to achieve truly open industrial automation
24/7/365
Support
Technical support available by phone, chat, and email
30+ Years
Experience
Product efficacy, market testing, and reliability
Used in 10K+
Data Servers
OAS is used in thousands of businesses worldwide
OAS Platform Features
Cross-Platform Support
The OAS Platform supports multiple operating systems and deployment options including Windows, Linux, Docker Containers, and can even run on low footprint devices such as a Raspberry PI 4.
Networking
OAS is an edge solution that offers flexible networking options for standalone installations, multi-tenant data aggregation, and even secure unidirectional data transport.
Programmatic Setup
Utilize our .NET SDK or REST API for flexible and automated setup, ensuring full integration with your asset management software. You can also import and export CSV files, which helps you work with Excel and third-party applications.
Calculations, Time On, Counts, and Totals
Merge data from various controllers and additional data sources while performing real-time computations and logic processing, all without the need for coding. Monitor the duration of activities for specific points and the frequency of their transitions over a defined period. Aggregate analog values both daily and over the entire timeline.
See How We Compare
The initial cost of OAS is far less than our competitors – but the savings don’t stop there. We work with OEMS and System Integrators to provide perpetual licenses with quantity discounts with flexible tag pricing and unlimited client connections.
No Question Left Unanswered
We make getting started with OAS easy - Follow this step-by-step introduction to using the Open Automation Software platform, from selecting your data sources, product features, and data destinations.
Getting Started - Download, Setup & Support
Step-by-step introduction to using the Open Automation Software platform
How to use the OAS Excel Connector.
More about the 3 key networking methods included with licenses.
How to active and manage OAS license.
Related Videos
