retrieve data from excel file in PLC project DB data block.

[Neerabh]

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.

[proplc]

Hi,

'S7 Excel Connect' can read and write to S7 datablocks. This should do the job.

[marzari]

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

[MaxS]

I need to write and read data via excel in a data block of an S7 1200. Does anyone have any example procedures?

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

[marzari]

Thanks MaxS,
sorry for my delay, but I could not enter the site
"https://plcforum.uz.ua"
Thank you very much.
Aldo