Hi all, below is my YouTube video for using Excel and Power Query to fetch refreshable web data. This is useful for dashboarding and data
Author: AnthonyC
Semi- Automatically Copy files from Sharepoint to local/ network folder
This post is to create a semi automatic process to copy files from Sharepoint to your local or network folder. This automation uses Power Automate,
Using Telegram bot and ESP32 to get temperature and humidity readings from sensor (DHT11) remotely
Hi all, the items you need for this project: Schematic diagram: Connections from ESP32 to DHT11 are : Gnd to Gnd, Signal/data to IO pin
Using Telegram bot to control ESP32 microcontroller LEDs
This post is about using Telegram bot to remotely control ESP32 microcontroller to on/off 4 LEDs. Please watch my YouTube video below, for better understanding
Pandas dataframe to Excel, retaining Excel sheet cells formatting
Hi, when we transfer a dataframe to an pre-formatted Excel sheet, there will be a common issue where the cell formatting of the Excel sheet
Create Draft Outlook Email with table using Python
This post uses Python to query a table from SQL Server, attach the table into the email body and create a draft Outlook email. Below
Welcome...enjoy coding, Electronics, IOT or data mining? Thank you for visiting my blog. 