Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from openpyxl import Workbook
- wb = Workbook()
- wb["Sheet"].title = "Datas"
- sheet = wb.active
- data = [('Name','Age','Salary','Year of work'),('Самат',25,2500,5),('Улан',30,32000,7)]
- for i in data:
- sheet.append(i)
- c1 = sheet.cell(row=2, column=5)
- c1.value = sheet['D2'].value * sheet['C2'].value * 12
- c2 = sheet.cell(row=3, column=5)
- c2.value = sheet['D3'].value * sheet['C3'].value * 12
- wb.save("workers.xlsx")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement