Python & Spreadsheets

Kojo Idrissa

His goal is to grow python by bringing non-programmers into python programming. For example, spreadsheet users may be likely to be converted to python, especially if there is an easy interface to using spreadsheets. ("Spreadsheet jocks as programmers")

Why?

lots of data already in spreadsheets
growing python
- spreadsheet jocks as progrgs
remove/reduce repititve taskas they face
excel's flaw for data analysis
- partially automated, partially manual
- allows/encourages/requires sloppy daya, not well-structured data, partially because it's a virsual format

Spreadsheet Formats

Excel
- .xls vs. xlsx
Libre/OpenOffice
To libraries
- OpenPyXL: works with .xlsx
- xlrd/xlwrt/xlUtils: works with .xls

What: Three Steps

Reading data from a spreadsheet w/python
Processing spreadsheet data w/python
Writing data to aspreadsheet w/python



In [4]:

    
from openpyxl import load_workbook

FILE_NAME = 'spreadsheet.xlsx'
SHEET_NAME = 'Sheet1'

wb = load_workbook(filename=FILE_NAME)
sheet = wb.get_sheet_by_name(SHEET_NAME)