Set openpyxl cell format to currency

Question

I'm creating an excel sheet using openpyxl. Some cells represent monetary values. How can I change the format of a cell to be of type "currency", i.e. I want a "€" symbol to be displayed after the number.

Solution

Try setting the format code with your desired format code

_cell.number_format = '#,##0.00€' 

Comments

[Dominic]

your code didn't work for me out of the box, but it guided me to the solution. _cell.number_format = '#,##0.00€' did the trick. Thank you!

[Charlie Clark]

That was the older API. We changed in recent versions to make it simpler to use.

[Gigino]

@Dominic where exactly is the difference between your code and the accepted answer?

[Mare Seestern]

@Gigino There is no difference. There was a difference before the edit.