The recent announcement from Microsoft that they have now integrated Python into it’s Excel spreadsheet software has opened up a wealth of new applications for data analytics, automation and number ...

Ever since Microsoft introduced Python in Excel, I have treated it as a ‘someday’ project. I knew Python integration was the ...

You can write a Python program or use a Jupyter Notebook to do almost anything. But you can also get a lot of things done quickly using a spreadsheet. Grist is a “hacker’s” spreadsheet that merges ...

Using the SSConverter class that we developed last week, which used the OORunner class from the week before that, this week we'll create a Python function that allows us to use spreadsheets as if they ...

Each input file is a spreadsheet and it is converted into the corresponding output file as a CSV file. As with OORunner, this code is based on PyODConverter. Next week we'll write a converter function ...