Skip to content

Instantly share code, notes, and snippets.

/invoice.py Secret

Created December 16, 2015 21:43
Show Gist options
  • Save anonymous/34655c62cbaeca74f2d8 to your computer and use it in GitHub Desktop.
Save anonymous/34655c62cbaeca74f2d8 to your computer and use it in GitHub Desktop.
itemData = {}
print('Reading rows...')
for row in range(10, 19):
# Each row in the spreadsheet has data for one item.
item = sheet['A' + str(row)].value
description = sheet['C' + str(row)].value
ordered = sheet['J' + str(row)].value
invoiced = sheet['M' + str(row)].value
rate = sheet['N' + str(row)].value
barcode = sheet['P' + str(row)].value
amount = sheet['R' + str(row)].value
print('{0: <16}'.format(item) + '{0: <24.20}'.format(description) +
'{0: <4}'.format(ordered) + '{0: <3}'.format(invoiced) +
'{0: <3}'.format(invoiced) + '{0: <13}'.format(barcode) +
'{0: <4}'.format(amount))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment