Advertisement
Guest User

Untitled

a guest
Jun 30th, 2016
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. import xlsxwriter
  2. workbook = xlsxwriter.Workbook('student_data.xlsx')
  3. worksheet = workbook.add_worksheet()
  4.  
  5. students = student_id.keys()
  6. fields = [student_age, student_id] # add other dicts here...
  7.  
  8. for row, student in enumerate(student):
  9. worksheet.write(row, 0, student) # name column
  10. for col, student_data in enumerate(fields):
  11. col = col + 1
  12. worksheet.write(row, col, student_data[student])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement