XlsxWriter error for percent format

python pandas xlsxwriter
Gabriel picture Gabriel · Oct 6, 2015 · Viewed 7.5k times · Source

I'm using Pandas and exporting data to excel using XlsxWriter. One of the data columns has floats and needs to be formatted as percent, so this is how I do it: 

percent_fmt = workbook.add_format({'num_format': '0.00%'})
worksheet.set_column('E:E', percent_fmt)

After that the following error appears:

File "C:\Program Files\Anaconda\lib\site-packages\xlsxwriter\worksheet.py", line 4688, in _write_col_info / float(max_digit_width) * 256.0) / 256.0

TypeError: unsupported operand type(s) for *: 'Format' and 'int'

What am I doing wrong here?

Answer

jmcnamara picture jmcnamara · Oct 6, 2015

You need to specify a width before the format or None if you don't want to adjust the width. 

worksheet.set_column('E:E', None, percent_fmt)

Related questions

How to save a new sheet in an existing excel file, using Pandas?

I want to use excel files to store data elaborated with python. My problem is that I can't add sheets to an existing excel file. Here I suggest a sample code to work with in order to reach this issue …

Read More
append dataframe to excel with pandas

I desire to append dataframe to excel This code works nearly as desire. Though it does not append each time. I run it and it puts data-frame in excel. But each time I run it it does not append. I …

Read More
Putting many python pandas dataframes to one excel worksheet

It is quite easy to add many pandas dataframes into excel work book as long as it is different worksheets. But, it is somewhat tricky to get many dataframes into one worksheet if you want to use pandas built-in df.…

Read More