Advertisement
skip420

customer

Sep 5th, 2022
871
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.55 KB | None | 0 0
  1. # python3 customer
  2. # pip install XlsxWriter
  3.  
  4.  
  5. import xlsxwriter
  6. workbook = xlsxwriter.Workbook('Customer_Details.xls')
  7. worksheet = workbook.add_worksheet()
  8. worksheet.write('A1', 'Name')
  9. worksheet.write('B1', 'Department')
  10.  
  11. row = 1
  12. col = 0
  13.  
  14. data = (
  15.     ['Tom Biznis', 'IT'],
  16.     ['Karen IS upset','Physiotherapist'],
  17.     ['Bob\s your uncle', 'Student'],
  18.     ['terminal illness','Bank Manager'],
  19. )
  20.  
  21. for name, score in (data):
  22.     worksheet.write(row, col, name)
  23.     worksheet.write(row, col + 1, score)
  24.     row += 1
  25. workbook.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement