OPC-UA data into Excel|Product and Service Requests|Forum|OPC Foundation

Avatar
Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
Lost password?
sp_Feed sp_PrintTopic sp_TopicIcon
OPC-UA data into Excel
Avatar
Keith Smith
Austin, TX
New Member
Members
Forum Posts: 1
Member Since:
09/09/2015
sp_UserOfflineSmall Offline
1
08/17/2016 - 14:42
sp_Permalink sp_Print

Does anyone know of a way to get data from an OPC-UA server into Excel?  Specifically if there is any sample code, or a commercial Excel Add-In.

Thanks.

Avatar
Guest
Guests
2
08/17/2016 - 14:51
sp_Permalink sp_Print

We have just certified exactly what you are looking for:

https://opcfoundation.org/prod.....celmonitor

Avatar
Zbyněk Zahradník
Member
Members
Forum Posts: 62
Member Since:
02/24/2014
sp_UserOfflineSmall Offline
3
08/17/2016 - 22:17
sp_Permalink sp_Print

You can use QuickOPC, http://www.opclabs.com/product.....ools/excel . It is also certified for OPC UA compliance.

Avatar
Neal Guess
New Member
Members
Forum Posts: 1
Member Since:
12/28/2017
sp_UserOfflineSmall Offline
4
12/28/2017 - 00:40
sp_Permalink sp_Print

I stilll cannot do that. What can be the problem? Whom should I write my essay? Any support representative who can assist me online?

Avatar
Zbyněk Zahradník
Member
Members
Forum Posts: 62
Member Since:
02/24/2014
sp_UserOfflineSmall Offline
5
12/30/2017 - 11:18
sp_Permalink sp_Print

Online forums on http://www.opclabs.com/forum/index, or email to support09 (at) opclabs.com .

Avatar
Sean MacDonald
New Member
Members
Forum Posts: 2
Member Since:
01/25/2018
sp_UserOfflineSmall Offline
6
01/25/2018 - 13:57
sp_Permalink sp_Print

I also wanted to let you know that Matrikon also has an Excel Add-in that works great.  You can find the free demo at:

http://www.matrikonopc.com/pro.....orter.aspx

Sean MacDonald

Avatar
Maria Denial
New Member
Members
Forum Posts: 1
Member Since:
02/19/2018
sp_UserOfflineSmall Offline
7
02/19/2018 - 00:56
sp_Permalink sp_Print
I feel like most data can be saved to a pickle pretty easily and then we can use Pandas or similar framework to do my assignment. However, a lot of corporations still rely on excel -- so that it may be useful. Good Luck!
Avatar
Niels Andersen
USA
New Member
Members
Forum Posts: 1
Member Since:
08/31/2017
sp_UserOfflineSmall Offline
8
02/19/2018 - 12:54
sp_Permalink sp_Print

sean.macdonald@matrikonopc.com said
I also wanted to let you know that Matrikon also has an Excel Add-in that works great.  You can find the free demo at:

http://www.matrikonopc.com/pro.....orter.aspx  

Sean, it looks like an OPC DA and HDA plugin. Do you know if OPC UA is supported?

Avatar
Rohit
Japan
New Member
Members
Forum Posts: 2
Member Since:
05/09/2018
sp_UserOfflineSmall Offline
9
11/01/2018 - 01:35
sp_Permalink sp_Print

said
We have just certified exactly what you are looking for:

https://opcfoundation.org/prod.....onitor  

This product has been renamed for certain reasons and hence available at following url : puerto-opc-ua-client

Please find the details about this product at : User Manual

Please feel free to write us at contact@ibress.com for more details.

Avatar
Rohit
Japan
New Member
Members
Forum Posts: 2
Member Since:
05/09/2018
sp_UserOfflineSmall Offline
10
11/01/2018 - 01:39
sp_Permalink sp_Print

niels@thinkiq.com said

Sean, it looks like an OPC DA and HDA plugin. Do you know if OPC UA is supported?  

Hi Niel, probably a late post though, but you can check the following OPC-UA Client as well : puerto-opc-ua-client

Please find the details about this product at : User Manual

Please feel free to write us at contact@ibress.com for more details.

Forum Timezone: America/Phoenix
Most Users Ever Online: 510
Currently Online:
Guest(s) 18
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Forum Stats:
Groups: 2
Forums: 10
Topics: 1336
Posts: 4535