I have made a project with siemens PLC SIMATIC S7-300, CPU 313C integration with Protool for ink dispensing system. i just put manually ink required value in kilogram in datablock and compare it with actual value which i get through weighing scale, which is working fine
Now i want to connect this system with another software from where i can get the ink required value in auto mode CxF file format.
so i want to know how can i transfer the value from file to my DB data block used for required ink input value. so that when i received these values from that software it will transfer to my PLC input data block and my system will work as per that.
retrieve data from excel file in PLC project DB data block.
-
- Posts: 1
- Joined: Fri Mar 25, 2016 6:45 pm
-
- Posts: 1
- Joined: Wed Nov 03, 2021 10:31 am
Re: retrieve data from excel file in PLC project DB data block.
Hi,
'S7 Excel Connect' can read and write to S7 datablocks. This should do the job.
'S7 Excel Connect' can read and write to S7 datablocks. This should do the job.
-
- Posts: 9
- Joined: Thu Mar 13, 2014 5:35 pm
Re: retrieve data from excel file in PLC project DB data block.
Good morning,
I need to write and read data via excel in a data block of an S7 1200. Does anyone have any example procedures?
Thanks Aldo
I need to write and read data via excel in a data block of an S7 1200. Does anyone have any example procedures?
Thanks Aldo
-
- Posts: 62
- Joined: Sat May 17, 2014 1:26 am
Re: retrieve data from excel file in PLC project DB data block.
If you use TIA Portal V16 and upwards and latest FW of S7 1200, that is if you can run the OPC UA Server on the PLC than you can try this example for S7 1500.
https://support.industry.siemens.com/cs ... /109748892
or FTP
https://support.industry.siemens.com/cs ... w/81367009
-
- Posts: 9
- Joined: Thu Mar 13, 2014 5:35 pm
Re: retrieve data from excel file in PLC project DB data block.
Thanks MaxS,
sorry for my delay, but I could not enter the site
"https://plcforum.uz.ua"
Thank you very much.
Aldo
sorry for my delay, but I could not enter the site
"https://plcforum.uz.ua"
Thank you very much.
Aldo