If you’re doing some automation in Excel, you should know that you’re not limited to the world of Workbook and Worksheets. There’s a world out there that you can access from within Excel, and one of those worlds is the web API. In this blog, I’ll show you the most basic (bare minimum) code to …
Using the baseline MQTT sample codes from my last blog, I incorporated a visual element using PyGame so we can represent the oven temperatures as colored sprite on the screen. If you have not read that blog yet, here’s the link: Demo video I uploaded the recording of my test as it’s best shown as …
This is just a “fun” coding blog, but who knows, maybe you’ll find a good use for it on your projects 🙂 The goal is simple — move the control somewhere else — just like magic 🙂 Design (Setup) Super simple, just add the following to the default form: Command Button (to trigger the action) …
If you’ve been using Excel for a long time, you probably had written a macro or a VBA script. This blog isn’t about writing a VBA script, this blog would assume you already know how to. Instead, we’ll explore how and why to implement cache or caching in your VBA codes. What is caching? To …
November 21, 2022 —- more than 6 years have passed since we got together in one location. Back then, we love to have a good conversation on some secret floors in a secret building at a secret location that has a coffee vending machine. Times were simple back then. We write codes, write documents, beat …
You can easily research how to use a delegate, but most of the materials out there don’t really tell you the use-cases of these delegates, and so you don’t tend to use it. They give you a Hello-World-like example and you’re left to figure out how, when and why you’d implement it on your applications. …
There are many ways to do asynchronous programming in Python, but the one I’ll cover here is the probably the first option that most Python programmers will use, or is taught —- and that is using the threading module. Before we dive into coding, let’s talk about Synchronous and Asynchronous processing (or in our case, …
Pythons argparse module is very helpful when building command-line tools and so when I worked on Python 2.2 and couldn’t find it, I thought of creating one, a very lite version, for the most basic feature/functionality. It’s not a drop-in replacement, as I did not implement all the features and didn’t intend to — I …
This is a continuation blog. Please read Part 1 first, before reading this. Version 2: Component Based Let’s say that the data is no longer a dictionary or something that isn’t readily serialized by XML or JSON modules. For simplicity sake, let’s just create an object version of the data in part 1: Complex Data …
Implementing Data Formatters – Python Edition (part 2 of 2) Read More »
This will most likely be useful to you if you’re doing web applications (web services or web APIs) but the idea would still be applicable for other use cases. Since there’s really no standard way of rendering data, we usually have to support multiple format. In this blog, we’ll cover the most common formats in …
Implementing Data Formatters – Python Edition (part 1 of 2) Read More »