Skip to content

Instantly share code, notes, and snippets.

@jpibarra1130

jpibarra1130/read_workbook.py

Created November 22, 2015 06:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jpibarra1130/f61ffa23b38513e4b2f3 to your computer and use it in GitHub Desktop.
Save jpibarra1130/f61ffa23b38513e4b2f3 to your computer and use it in GitHub Desktop.
Download ZIP
Sample Python script to read from an excel file.
Raw
read_workbook.py
import xlrd
name = input('file: ')
wb = xlrd.open_workbook(name)
sheet = wb.sheet_by_index(0)
lookup = {
'name': 0,
'website': 1
}
for rownumber in range(1, sheet.nrows):
print(rownumber)
row = sheet.row(rownumber)
name, website = row[lookup['name']].value, row[lookup['website']].value
print("Name: %s, Website: %s" % (name, website))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment