Last Updated: 20200903 2126 (UTC+8)
What does the common Office Excel or Google Sheets got to do with programming?
You need to know, for any variable in any porgramming language, there is a value even if it is undefined. For any Cell in any Excel Workbook or Google Sheets, there is always a value even if it is empty. That is my programming approach with regards to Excel Workbooks. To lay it out clearly, here is an example:
In programming a Variable can contain Value (Data types: string, integer, boolean, float or undefined); Thus [Variable = Value]
In Excel Worksheets a Cell has Value (Texts, formulas); Thus [Cell = Value]
Combine them, you can come to understand that a Variable and a Cell are technically the same thing; Thus:
Any Excel Cell (Variable) = Value
Once you get this, its like building a computer in Minecraft, a game that I played back in the good old days.
Here contains my excel works around 2015 to 2017, do take note that everything here is old. There are currently a total of 3 Excel Projects being shown here that have little to no use in real life applications. But fret not, here are the links:
DXCode Project (Converting to Python and JS Planned)
Excel Template (Modern Version Planning in Progress)
Offline IPv4 Planner (Modern Version Planning in Progress)