Write Functions

The write functions are together with the read functions the core of the program, select one of the functions for a detailed explanation. The write functions send data from Excel to the PLC. 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 SETS7DATABLOCK(...) Formula