Set Openpyxl Cell Format To Currency

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 d

Solution 1:

Try setting the format code with your desired format code

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