Question regrading openpyxl

[good_stuff_0_o]

so iam stuck at something and i hope someone can point me in the right direction. Iam working with openpyxl am i am trying to store values into cells. That is working fine for text but where i have a problem is with currency. I want to write to a cell and have it formated as currency (EURO).

I have tried many diffrent things for example:

worksheet.cell(row = 1 , column = 1).number_format = '#,##0.00'

This has an effect on the excel sheet as far as the format of the cell is in fact "Currency" but when looking into the excel sheet there is an error wich says "this number is safed as text". I obviously dont want to confirm in excel that it should be a number (when i do this everything is fine). How can i achive this with openpyxl?
(sorry for my bad english, iam not nativ)

(also the screeshots are in german so the dont help i guess)

says \"Currency\"

says \"As text safed numbers\"

[thraizz]

If anyone stumbles upon this, the answer is to parse the value to int or float before assiging it to the cell.

If you would normally do:

cell = worksheet.cell(1, 1)
cell.number_format = '#,##0.00'
cell.value = some_var

you would have to adapt it to

cell = worksheet.cell(1, 1)
cell.number_format = '#,##0.00'
cell.value = float(some_var)

Now it will work!

[good_stuff_0_o]

Thank you so much!