Тёмный

COM06. Connect Excel to Siemens PLC via DDE of KEPServerEX (Kepware) 

Electrical Automation Hands-On
Подписаться 22 тыс.
Просмотров 5 тыс.
50% 1

#KEPServerEX #DDE #Kepware #Excel
Next: COM07. • COM07. Use Excel VBA(V...
Previous: COM05. Connect Siemens PLC to KEPServerEX (Kepware)
• COM05. Connect Siemens...
Industrial Automation Data Collection
• Industrial Automation ...
Siemens Playlist
• Siemens Controls

Наука

Опубликовано:

 

4 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 22   
@felipepaiva4798
@felipepaiva4798 4 года назад
Hello! One more time, excellent video! Congratulations!!!
@electricalautomation
@electricalautomation 4 года назад
Thanks! I am planning and making an entire new series of videos about engineering process modeling and PID control. Please help to forward other friends if you like them. Thanks a lot!
@felipepaiva4798
@felipepaiva4798 4 года назад
Of couse yes, no doubt that would be some more good videos to this channel, i will send to my friens this kind of video, mainly cause PID is an abrangent theme at the industries, and you have a excellent didatic to give your Knowledge to us. Thanks so much! I will be waiting eagerly for your videos.
@electricalautomation
@electricalautomation 4 года назад
@@felipepaiva4798 Hi my friend, please find the playlist ru-vid.com/group/PL762SfoJC-e_1CtDQoRe6PYEG6Iz_zdvz, which is the PID and Process Object Modeling. Furthermore, the more PID videos about the PID will come soon, I am editing them these days.
@erdemdelibasi1315
@erdemdelibasi1315 2 года назад
That's a great video. Regards,
@electricalautomation
@electricalautomation 2 года назад
Thank you! Cheers!
@ahmedabdelwahd9520
@ahmedabdelwahd9520 2 года назад
Good video
@electricalautomation
@electricalautomation 2 года назад
Glad you enjoyed! Welcome!
@rdautomation4357
@rdautomation4357 3 года назад
Hello, what kind of version of excel was used in this video? I am trying to do same, but quality is always bad, even after several minutes. All the same in KEPs, and Kep's conf. Macros conf in excel also 1:1 to this video. Excel 2019. 10 pages manual was done in Excel 2007.
@electricalautomation
@electricalautomation 3 года назад
Hi My excel is Office Professional Plus 2016. You could also check two important info and setting from the video 3:12 at ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pBhcizo5aYI.html , and 2:35 DDE channel name at ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pBhcizo5aYI.html. That 10 pages include a lot important information.
@timkishelov9489
@timkishelov9489 Год назад
Your video helped me to use Excel with Siemens PLC simulation. Thanks! I'm using the Advanced tags to display data in Excel cells. I tried to write PLC data to Excel cells without advanced tags but couldn't make it work.
@electricalautomation
@electricalautomation Год назад
I think you are having issue on the PLC Simulation. Please try to use the real hardware
@timkishelov9489
@timkishelov9489 Год назад
@@electricalautomation I think if I see data in the Quick Client, then I should be able to see the data in Excel. I had no problem to get data to Excel from Siemens S7-300.
@electricalautomation
@electricalautomation Год назад
@@timkishelov9489 Check the CPU properties on ""permit access with put/get communication from the remote partner""
10 месяцев назад
How i can find DDE connect document ! please
@miguelp7078
@miguelp7078 3 года назад
hello, when i use the quick client it says "bad connection" and i dont know why is this. I'm working with Tia portal v16 and S7-1200 thanks! :)
@electricalautomation
@electricalautomation 3 года назад
Likely it is the software problem, because the quick client is communicating with Kepware server. Please make sure the software is installed correctly, also turnoff any anti-virus software and firewall.
@miguelp7078
@miguelp7078 3 года назад
@@electricalautomation now it is working correctfully thanks!! I just needed to upload the hardware and i also missing the firewall deactivation.
@electricalautomation
@electricalautomation 3 года назад
@@miguelp7078 Glad to hear that! Thanks for letting me know.
@andreeeeeeeee670
@andreeeeeeeee670 2 года назад
can this be done in WPS ? thanks alot your videos are really great, any chance u have a chinese channel as well
@andreeeeeeeee670
@andreeeeeeeee670 2 года назад
can the Siemen software itself do excel or to a SQL db ? why even use KepServer ?
@electricalautomation
@electricalautomation 2 года назад
I don't think WPS works for this case. But you can check if KEPServerEX support WPS. Regarding directly communication to Excel and SQL. Please check the videos in my channels.
Далее
COM05. Connect Siemens PLC to KEPServerEX (Kepware)
26:45
skibidi toilet zombie universe 37 ( New Virus)
03:02
Просмотров 1,3 млн
Why The Windows Phone Failed
24:08
Просмотров 215 тыс.
Samsung laughing on iPhone #techbyakram
0:12
Просмотров 7 млн