Advertisement
Mancolo

Untitled

Dec 2nd, 2020
867
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.42 KB | None | 0 0
  1. from openpyxl import Workbook
  2.  
  3. wb = Workbook()
  4. wb["Sheet"].title = "Datas"
  5. sheet = wb.active
  6.  
  7. data = [('Name','Age','Salary','Year of work'),('Самат',25,2500,5),('Улан',30,32000,7)]
  8. for i in data:
  9.     sheet.append(i)
  10. c1 = sheet.cell(row=2, column=5)
  11. c1.value = sheet['D2'].value * sheet['C2'].value * 12
  12. c2 = sheet.cell(row=3, column=5)
  13. c2.value = sheet['D3'].value * sheet['C3'].value * 12
  14. wb.save("workers.xlsx")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement