Control Excel via Python With OpenPyXL
In my formal job, as an analyst (Real estate), I used VBA to control Excel spreadsheets. It is quite convenient to use VBA macro to control Excel. No Env-setting, just save the file with .xlsm and you can simply share the code with the file to your colleagues or friends. However, sometimes I found out …
