OPC Excel.NET
OPC EXCEL.NET -
Share data with Microsoft Excel from OPC Servers. Implement both read and write functionality right in your Excel Workbooks. Runs as a Windows Service and comes with free configuration application to allow on-line modifications from local or remote systems. Includes free connection to OPC Servers. Combine with OPC Controls.NET for sharing data from Visual Studio applications. Combine with OPC Client.NET to share data with OPC Clients.START YOUR FREE 30 DAY TRIAL TODAY!
OPC EXCEL.NET SUMMARY
Share OPC data with Microsoft Excel by including simple to use functions in your Excel Workbooks. There are functions for both reading and writing data to OPC Servers. Data can also be shared with .NET applications, web applications, databases, and OPC Clients with the other product features of the OPC Systems.NET suite. Data server runs as a Windows Service and comes with free configuration application. Data can be shared over your Intranet or the Internet to as many remote Workbooks as you like.Use this feature as part of the full OPC Systems.NET suite to provide Microsoft Excel data to OPC Clients, .NET applications, databases, and web applications.
PRODUCT FEATURES
- Configure both local and remote OPC Systems Service configurations manually, with CSV Export and Import, or programmatically from your own application.
- Control and modify Tag, Data Logging, Alarm Logging, Alarm Notification, Recipe, Report, and Security configurations along with and Options from your own application!
- Unlimited remote clients.
- Implement Smart Client deployment with 100% managed components.
- Use Visual Studio 2010, 2008, Expression Blend 3, and 2 to create your own applications.
- Extremely fast data update with very low CPU usage.
- Very cost effective solutions for both individual and corporate users.
- Perfect solution for OEMs to create their own SCADA / HMI software to package with their systems.
- Fast development time with no code required.
- Easy setup of trending, alarming, data logging, reports, recipe management, and security in central configuration.
- Use your own data from .NET applications.
OPC EXCEL.NET FEATURES
OPC EXCEL.NET COMPONENT
- Read data from and write data to OPC Servers from Microsoft Excel 2010, 2007, and 2003.
- Easy to use formula parameters.
- Formula wizard application with tag browsing.
- Define data sources and all parameters based on Excel cell values.
- Support on-line modification for all properties.
OPC SYSTEMS WINDOWS SERVICE
Supports free connections to OPC Servers supporting OPC Data Access Specifications 2.x or 3.0.
License allows unlimited local and remote WinForm application connections.
Data source for each Tag can be a fixed value, local or remote OPC Item, or another local or remote Tag Parameter.
Calculations are also a possible data source allowing real-time equations using library of math, logical, and string functions together with local and remote Tags.
Implements .NET Remoting thus eliminating the need for DCOM configuration by connecting all OPC Servers locally with each OPC Systems Service.
Supports on-line modification while the system is running. add, modify, and remove Tags.
Includes free programmatic interface to define configurations from your own Visual Studio application.
Supports DirectOPC pass through to connect directly to OPC Servers with dynamic tag addressing from client applications.
Unique Multi-Threaded application service providing real-time data to local and remote .NET components.
OPC SYSTEMS.NET PRICING AND LICENSING INFORMATION
| Licenses | Price US $ |
| 100 Tags | $195 |
| 250 Tags | $295 |
| 500 Tags | $395 |
| 1,000 Tags | $495 |
| 2,500 Tags | $795 |
| 10,000 Tags | $1,195 |
| 20,000 Tags | $1,495 |
| 100,000 Tags | $1,995 |
| 250,000 Tags | $4,495 |
| 500,000 Tags | $8,495 |
| 1,000,000 Tags | $14,995 |
| Quantity of 5 or more licenses | 20% discount |
| Quantity of 10 or more licenses | 30% discount |
| Annual Maintenance (Optional) | 20% of purchase |
| Corporate and OEM Licensing | Contact Us |
OPC SYSTEMS.NET TRAINING
Please view our OPC SYSTEMS.NET training on all our products here Click here to view the OPC Systems.NET Help file on-line to review step by step examples and search for content.
| Training Video | Link |
| All Product Training | View |
| OPC Systems.NET Help file on-line | View |
| OPC SYSTEMS.NET INTRODUCTION | |
| OPC SYSTEMS.NET INTRODUCTION | Play Video | Download |
| Basic Start | Play Video | Download |
| Quick Start Guide | Play Video | Download | Start Guide | Play Video | Download |
| Overview Video | Play Video | Download |
| SMART CLIENT DEPLOYMENT | |
| One Click HMI | Play Video | Download |
| Run HMI Smart Client | Play Video | Download |
| HMI Smart Client | Play Video | Download |
| Automated HMI | Play Video | Download |
| WinForm Smart Client | Play Video | Download |
| DATA SOURCE TRAINING VIDEOS | |
| One Click OPC | Play Video | Download |
| OPC Server - Quick Start | Play Video | Download |
| OPC Server - Detailed | Play Video | Download |
| Calculations | Play Video | Download |
| Programmatically | Play Video | Download |
| Connect OPC Clients | Play Video | Download |
| Excel Workbook | Play Video | Download |
| Transfer Database Data | Play Video | Download |
| Data Source | Play Video | Download |
| HMI QUICK START TRAINING VIDEOS | |
| Quick Start HMI Symbols | Play Video | Download |
| HMI Symbols | Play Video | Download |
| HMI Quick Start Templates | Play Video | Download |
| WinForm MDI Template | Play Video | Download |
| WPF Tabbed Template | Play Video | Download |
| WinForm Tabbed Template | Play Video | Download |
| OPC WPF HMI.NET TRAINING VIDEOS | |
| Create WPF HMI - Quick Start | Play Video | Download |
| Create WPF HMI - Basic | Play Video | Download |
| WPF Bar Chart | Play Video | Download |
| WPF Pie Chart | Play Video | Download |
| WPF Circular Data | Play Video | Download |
| WPF Quick Chart | Play Video | Download |
| WPF Storyboard Animations | Play Video | Download |
| Add Gauges to WPF | Play Video | Download |
| Develop WPF HMI | Play Video | Download |
| Add Lamps and Switches | Play Video | Download |
| WPF Radial Gague Video | Play Video | Download |
| OPC WINDOWS HMI.NET TRAINING VIDEOS | |
| Create WinForm HMI - Quick Start | Play Video | Download |
| Create WinForm HMI - Detailed | Play Video | Download |
| Programmatically | Play Video | Download |
| OPC WEB HMI.NET TRAINING VIDEOS | |
| HTML HMI - Quick Start | Play Video | Download |
| HTML HMI Wizard - Detailed | Play Video | Download |
| Create ASP.NET Web HMI - Quick Start | Play Video | Download |
| Create ASP.NET Web HMI - Detailed | Play Video | Download |
| OPC TREND.NET TRAINING VIDEOS | |
| Add Trending - Quick Start | Play Video | Download |
| Add Trending - Detailed | Play Video | Download |
| Real-Time and Historical | Play Video | Download |
| Set Trend Time Frames | Play Video | Download |
| Add X-Y Plot Trending | Play Video | Download |
| OPC WEB TREND.NET TRAINING VIDEOS | |
| Add Web Trending - Quick Start | Play Video | Download |
| Add Trending to Web - Detailed | Play Video | Download |
| OPC ALARM.NET TRAINING VIDEOS | |
| Define Alarm Limits | Play Video | Download |
| Add Alarm Window | Play Video | Download |
| Log Alarms | Play Video | Download |
| Send Alarms via E-Mail | Play Video | Download |
| Add Alarming | Play Video | Download |
| OPC WEB ALARM.NET TRAINING VIDEOS | |
| Add Web Alarming - Quick Start | Play Video | Download |
| Add Web Alarming - Detailed | Play Video | Download |
| OPC GAUGE.NET TRAINING VIDEOS | |
| Add Gauges | Play Video | Download |
| OPC DATABASE.NET TRAINING VIDEOS | |
| Log Data - Quick Start | Play Video | Download |
| Log Data - Basic | Play Video | Download |
| Log Data - Detailed | Play Video | Download |
| Update | Play Video | Download |
| High Speed Logging | Play Video | Download |
| Data Buffering | Play Video | Download |
| Parallel Processing | Play Video | Download |
| OPC REPORT.NET TRAINING VIDEOS | |
| Generate Reports | Play Video | Download |
| OPC RECIPE.NET TRAINING VIDEOS | |
| Transfer Database Data | Play Video | Download |
| OPC EXCEL.NET TRAINING VIDEOS | |
| Excel Workbook - Quick Start | Play Video | Download |
| Excel Workbook - Detailed | Play Video | Download |
| Remote Excel Video | Play Video | Download |
| OPC ROUTE.NET TRAINING VIDEOS | |
| Transfer OPC Data | Play Video | Download |
| OPC CLIENT.NET TRAINING VIDEOS | |
| Connect OPC Clients | Play Video | Download |
| REMOTE NETWORKING VIDEOS | |
| Networking | Play Video | Download |
| Live Data Cloud | Play Video | Download |
| WCF Port Settings | Play Video | Download |
| UDP Broadcast | Play Video | Download |
| OPC Cloud Video | Play Video | Download |
| OPC SECURITY TRAINING VIDEOS | |
| Implement User Security | Play Video | Download |
| TROUBLESHOOTING TRAINING VIDEOS | |
| Troubleshoot OPC Servers - Quick Start | Play Video | Download |
| Troubleshoot OPC Server - Detailed | Play Video | Download |
| Troubleshoot Database | Play Video | Download |
| Troubleshoot Web | Play Video | Download |
| Helpful Tools | Play Video | Download |
| Troubleshoot WinForm | Play Video | Download |
| Set Target Framework | Play Video | Download |
DOWNLOADS
Download the complete suite of OPC Software here.Do you need a OPC Server for your hardware?
Click here to Download the Kepware OPC Server.
OPERATING SYSTEM REQUIREMENTS
- Windows 8
- Windows 7
- Windows Vista (with .NET Framework 3.5 SP1 or 4.0)
- Windows Server 2008 (with .NET Framework 3.5 SP1 or 4.0)
- Windows Server 2003 (with .NET Framework 3.5 SP1 or 4.0)
- Windows XP (with .NET Framework 3.5 SP1 or 4.0)
OPC FOUNDATION LAB CERTIFIED
OPC Foundation Certified for Compliance logo indicates that this product has been tested by an independent certification lab and certified to be compliant with the following OPC Specifications:
Data Access 2.05a Client
Data Access 3.0 Client
Additional information about compliance testing, logo program and a summary of test results can be found at www.opcfoundation.org for: OPC Systems.NET 6.01.0008.
