Course description
Suitable for people familiar with basic Python, this intermediate course uses Python frameworks to manipulate Excel spreadsheet and Google Sheets data. We use various Python libraries for manipulating Excel formats, especially OpenPyXL.
We also use xlsxWriter and tools for binary and legacy formats such as pylxsb, xlsd, xlst and xlUtils. These are used to manipulate cell data, worksheets, files, charts, format data and produce summary reports in Excel format, sometimes without opening Excel.
We also automate Excel with xlWings. People with VBA experience will find many of the operations familiar.
Those familiar with Python basics looking to manipulate and automate data on spreadsheets.
Course delivery details
Assessment and certificates
Learning is hands-on in a sequence of interleaving lectures. There will also be practical exercises that students can work on in their spare time.
Request info
City, University of London
City, University of London is a special place. With skill and dedication, we have been using education, research and enterprise to transform the lives of our students, our community and the world for a hundred years. We are proud of...