I've got a Step 7 proyect with an Ethernet module so, I need read and write some words between the PLC and Mocrosoft Excel but I don't know what is the best way.

If someone could support, I would really be appreciated.

 

Hi, Use a Kepware IO server this will talk to Excel and S7.

kevin

 

If you are able to do some programming by your own you could use
http://libnodave.sourceforge.net/

for connecting to S7 and read/write CSV files.

 

Firstly, I always ask - why are you interested in reading and writing from Excel? What is your application?

If you're just looking for a 'simple answer':
I would use the MatrikonOPC Siemens S7 Driver

http://www.matrikonopc.com/opc-drivers/309/base-driver-details.aspx

and combine it with the easy-to-use Matrikon Analytics Excel Reporter

http://www.matrikonanalytics.com/products/excel-reporter.aspx

It takes no programming, and you can use it directly - just select your tags and go. You can schedule things if you need to do things on a regular basis.

 

http://www.fultek.com.tr/DataLoggerEn.html

This software reading and write plc, Recording sql server and excel (real time).

 

If you have Siemens SCADA WinCC also in your application then you can use its inbuilt driver DDE (Dynamic data exhange) which directly communicates with MS applications (like Excel) and its easy to implement (just to put one VB code in XL, which is also available with WinCC help). So finally intead of communicating with S7 PLC, XL will communicate with WinCC and WinCC will inturn communicate with S7 PLC.