Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import xlsxwriter
- workbook = xlsxwriter.Workbook('student_data.xlsx')
- worksheet = workbook.add_worksheet()
- students = student_id.keys()
- fields = [student_age, student_id] # add other dicts here...
- for row, student in enumerate(student):
- worksheet.write(row, 0, student) # name column
- for col, student_data in enumerate(fields):
- col = col + 1
- worksheet.write(row, col, student_data[student])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement