I have a python script that writes excel file in the end with xlsxwriter. Everything works but a formula is giving error upon launching and if i copy and paste the exactly same formula it gives the results expected.
here is the line:
Goto the given link i believe you will find your answer: XlsxWriter: Working with Formulas
Specifically the Non US Excel functions and syntax says:
Excel stores formulas in the format of the US English version, regardless of the language or locale of the end-user's version of Excel. Therefore formulas must be written with the US style separator/range operator which is a comma (not semi-colon). A formula with multiple values should be written as follows:
worksheet.write_formula('A1', '=SUM(1, 2, 3)') # OK worksheet.write_formula('A2', '=SUM(1; 2; 3)') # Semi-colon. Error on load.
Hope this helps.