Skip to content

Instantly share code, notes, and snippets.

@infinitewarp
Created December 5, 2016 19:19
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 infinitewarp/357b0add9b1e5f89f8ac9a88dd4a60da to your computer and use it in GitHub Desktop.
Save infinitewarp/357b0add9b1e5f89f8ac9a88dd4a60da to your computer and use it in GitHub Desktop.
>>> from openpyxl import load_workbook
>>> wb = load_workbook('callsheet.xlsx')
>>> wb.get_sheet_names()
[u'QuickbooksToPodio']
>>> ws = wb.get_active_sheet()
>>> ws.title
u'QuickbooksToPodio'
>>> print "first row has {} cells".format(len(next(ws.rows)))
first row has 12 cells
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment