Working with Excel files in Python
Too many people in the Python community think the only way to work with Excel files in Python is using COM on Windows. This tutorial will introduce xlrd and xlwt, a pair of python packages for reading and writing Excel files in pure python that runs on any platform.
We'll go through the process of reading excel files to extract data and formatting, writing excel files and filtering existing excel files.
Presenter
Chris has been wrestling snakes for almost a decade now. This has predominantly been with Zope but has branched out into the wider world of Python web frameworks and general Python programming.
Requirements
You'll need a laptop with Python already installed to get the most out of this tutorial. Feel free to bring along any Excel-related problems you'd like to solve as there'll be a section at the end just for this!
Outline
- Introduction: No need for COM, here's xlrd and xlwt!
- Reading Excel Files
- Writing Excel Files
- Filtering Excel Files
- Workshop for your problems
.