Python Excel 2/5: automate calculations in Excel file and input formulas using openpyxl

This video teaches how to input data and formulas in correct order to spreadsheets , and how to format the cells and define decimal numbers.

This is video 2 out of five videos teaching how to write and manage data , plot graphs and develop tables, formulas, etc. in Excel spreadsheets using python (openpyxl)

My office tools:

Books I read:

[darshanphadnis]

Hi Yasser, Thanks for this video and I get it how we can use Excel formulas. Is there a way we can do progressive calculations using loops. E.g.: In Column H we would like to get values from Column B & D in rows earlier. That is Excel formula like: H3 = (B3 + D3)/(B2 - D2). I am not sure of how we would code this.

[floppyears]

Hi. I have a problem following you. When I code wp["A1"]='=SUM("D1")' and then open de the Excel, the cell goes under a naming error, if I enter the cell with F2 and press enter it gets the formula working.... but why does the error appears? Thank you!

[василийник-нш]

Hi, Thank you, you make really helpful videos

[vinayraoj]

I have added this formula to a cell using openpyxl library ws["A1"]= 'IF(OR(OR(B3=" ", N3=" "), AND(B3=0, N3=0)), " ", ABS(B3-N3))' Now i want to loop it through entire column of A.

[nripprasaddhamala]

if i want to keep only values in final output not formula what should i do?

[Saywhatohno]

when you calculate something in Python and spit out the result in excel does it show the formula in excel or is it only a hard coded number?

[MIGHTYmotovlog]

what if i only want a Sum(B1:B2) and automaticlly in all distance, ? can u help