review-checklists
review-checklists copied to clipboard
Azure
Consider generating the "latest and greatest" Excel files from the json from a GitHub actions pipeline
VBA macros or Office addins are a (slight) burden on users of the Excel, perhaps generating the latest version of the Excel (in multiple languages for different technologies) could simplify "consumption" of the Excel sheet?
Great point @jelledruyts ! I thought about that, but I was not able to find an easy way of generating Excel files with Github actions. Do you have any idea of how to do that?
I assume there would be some coding involved :-) Not the end of the world but first of all no point in going this route if the ideal end state isn't excel but some custom web app or Microsoft Assessments or whatever. And perhaps @xstof's no-code idea of using PowerQuery would be even better if you can pull that off!
These Python modules might help: https://www.xlwings.org and https://openpyxl.readthedocs.io
I have started playing with the automatic generation of macro-free .xlsx files, have a look in the spreadsheet folder. I am using the Python module openpyxl, it does not support all Excel features so I needed to simplify the spreadsheet, but the result is IMHO acceptable.