Skip to content

Instantly share code, notes, and snippets.

View dvee's full-sized avatar

David Ellis dvee

View GitHub Profile

Keybase proof

I hereby claim:

  • I am dvee on github.
  • I am davidellis (https://keybase.io/davidellis) on keybase.
  • I have a public key ASAAx79lxHyAOBMiVg-qpKpq33rjwr052r560I83B6OKYgo

To claim this, I am signing this object:

@dvee
dvee / xlrd_read.py
Created October 1, 2014 09:27
Use xlrd to dump all data in an excel spreadsheet to a list
import xlrd
workbook = xlrd.open_workbook("workbook.xls")
sheet = workbook.sheet_by_name("Sheet 1")
d_all = []
for i_row in range(sheet.nrows):
d_row = []
for i_col in range(sheet.ncols):
d_row.append(sheet.cell_value(i_row, i_col))
d_all.append(d_row)