I tried writing formulas with xlsxWriter and the
worksheet.write_formula but in my excel I only have zero.
Datas are put in columns A and C but then the following formula returns a zero when I open the xlsx file with the official Excel app.
worksheet.write(0,3, '=INDEX(C:C;MATCH(MINIFS(A:A;A:A;">="&EDATE(A5;1));A:A)
I have imported what’s necessary ant tried everything I found on internet (adding ” at the end, adding _xlfn. at the beginning…)
New contributor
Titouan V is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.