Read Functions

The read functions are together with the write functions the core of the program, select one of the functions for a detailed explanation. The read functions extract data from the PLC to display in Excel. When connecting to a S7-1200 or 1500 CPU, make sure the “Permit access with PUT/GET communication from remote partner” is enabled, see Permit PUT/GET access in TIA Portal.

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