Publish MQTT message to [EMQ X broker] from Microsoft Excel - Control Connected Device to ESP826

Опубликовано: 04 Апрель 2022
на канале: Yaser Ali Husen

2,562

Publish MQTT message to EMQ X broker from Microsoft. Excel

In this experiment, I tried to create an excel file that can send MQTT messages to broker.
The broker used is an EMQX broker installed on a Virtual Private Server

In order to be able to publish from an excel file, use the HTTP API provided by the broker.
Noteworthy is the format of the message if the message is JSON, as well as the parameters passed.
From the experimental results, it is possible to publish MQTT messages to brokers using an Excel file.

An example of a simple application is from an Excel file you can turn on and off the LED lights connected to the ESP8266.
The concept is that the excel file will send a message in JSON format according to the LED which will be controlled to the MQTT broker via the API URL, then ESP8266 will receive the message and process the JSON file and turn the LED light on or off according to the message received.

In the future, it can also be applied in sending other messages/data to the MQTT broker which is then forwarded to other devices.

Requirement:
1. Ms.Excel 2016 or latest
2. EMQX broker, on VPS or public
3. ESP8266
4. LED 3V

Download files: https://drive.google.com/file/d/1U7W2...
Find zip password on video

If you find this content useful, please send me "Super Thanks"