Excel

Reading Excel Spreadsheets with Python and xlrd

9 Comments / Cross-Platform, Python, Windows / By / January 31, 2020 / ,

Last month we looked at how to create Microsoft Excel (i.e. *.xls) files using the xlwt package. Today we will be looking at how we can read an *.xls/*.xlsx file using a package called xlrd. The xlrd package can be run on Linux and Mac as well as Windows. This is great when you need …

Reading Excel Spreadsheets with Python and xlrd Read More »

Python and Microsoft Office – Using PyWin32

3 Comments / Python, PyWin32, Windows / By / January 31, 2020 / , , , ,

Most typical users have used Microsoft Office. While Office may be the bane of tech support, we still have to deal with it. Python can be used to script (AKA automate) Office and make it easier for us or our users to use. It may not be as easy as recording a macro, but it’s …

Python and Microsoft Office – Using PyWin32 Read More »