GETS7INPUT

Summary

Retrieve a digital or analog input value from a S7 PLC. This function is available via the taskpane as well as directly via the cell “=GETS7INPUT(…)”


Return Value

The function returns the requested input value.


Arguments

cpuType – Specifies the cpu type of the PLC you want to connect with, must be a string with the CPU type in following format: ‘S7-1200’, ‘S71200’, ‘1200’.

ip – Specifies the ip address of the PLC.

rackNo – Specifies the rack number of the PLC, must be an integer between 0 and 99.

slotNo – Specifies the slot number of the PLC, must be an integer between 0 and 99.

dataType – Specifies the datatype of the requested data. Following datatypes are available: ‘BIT’, ‘BYTE’, ‘WORD’, ‘INT’.

startAddress (or Input Address) – Specifies the input address of the requested data, must be an integer between 0 and 9999.

bitNo – Specifies the bit number if the requested datatype is ‘BIT’, must be an integer between 0 and 7.


Example

S7 Excel Connect in Microsoft Excel Showing the GETS7INPUT(...) Formula

Instructional Video