Dear, I am working with openpyxl and I need your help
I want to copy the data from the A - B column to the C - D column but that the B data is divided by 10. and A's data is as is. How can i solve this? the other steps and I have them I leave the code below.
After this, create 2 variables in which I divide the values and the result is copied into column E and creates the file Result2.xlsx
from openpyxl import load_workbook
wb = load_workbook(filename='fig37.xlsx')
ws = wb["Fig37"]
deformation = ((ws['A3'].value)-(ws['A2'].value))
tiempo = ((ws['B3'].value)-(ws['B2'].value))
ws["E2"] = deformation / tiempo
wb.save("Resultado2.xlsx")