Set openpyxl cell format to currency

python excel currency openpyxl cell-formatting
Dominic picture Dominic · Jan 7, 2016 · Viewed 14.6k times · Source

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.

Answer

absolutelyNoWarranty picture absolutelyNoWarranty · Jan 7, 2016

Try setting the format code with your desired format code

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

Related questions

Writing to an Excel spreadsheet

I am new to Python. I need to write some data from my program to a spreadsheet. I've searched online and there seem to be many packages available (xlwt, XlsXcessive, openpyxl). Others suggest to write to a .csv file (never …

Read More
IndexError: too many indices for array

I know there is a ton of these threads but all of them are for very simple cases like 3x3 matrices and things of that sort and the solutions do not even begin to apply to my situation. So I'm …

Read More
Read Excel File in Python

I've an Excel File Arm_id DSPName DSPCode HubCode PinCode PPTL 1 JaVAS 01 AGR 282001 1,2 2 JaVAS 01 AGR 282002 3,4 3 JaVAS 01 AGR 282003 5,6 I want to save a string in the form Arm_id,DSPCode,Pincode. This format is configurable, i.e. it might change to …

Read More