ModTcp in Excel

AlbertoM

Member

A

Join Date

Jan 2016

Location

Gauteng

Posts

5

• Aug 6, 2019

• #1

Hi Everone

I need to log data from a PLC into Excel, I've been searching and there is a lot of demo stuff out there, but is there anything I can use that does not cost so much?

Thanks

 

cardosocea

Member

C

Join Date

Nov 2016

Location

Fields of corn

Posts

2,628

• Aug 6, 2019

• #2

Have you searched for Python and the brand of PLC?

 

Last edited: Aug 6, 2019

gclshortt

Member

Join Date

Dec 2014

Location

Ontario

Posts

3,217

• Aug 6, 2019

• #3

https://accautomation.ca/how-to-implement-modbus-tcp-protocol-using-vba-with-excel/

Using AdvancedHMI with Modbus TCP
https://accautomation.ca/create-a-plc-with-hmi-training-and-learning-environment-free/
AdvancedHMI (VB.Net) to Excel:
https://www.tutorialspoint.com/vb.net/vb.net_excel_sheet

The above links may help you out.
Regards,

 

Robleguithe83

Member

R

Join Date

Aug 2019

Location

Garneau Quebec

Posts

2

• Aug 7, 2019

• #4

You have a PLC in which there is some data. You need to generate a * .xls file (or simply * .csv). Naturally, there should be some kind of connection "PC <-> PLC". And on the computer - a program for generating a file. Perhaps this option will help.

 

AlbertoM

Member

OP

A

Join Date

Jan 2016

Location

Gauteng

Posts

5

• Aug 7, 2019

• #5

Thanks Garry
I tried using your Excel suggestion but keep getting a class error with winsck, am running win 10 64 and believe winsck doesn't work on this OS?
Any idea?