Write data frame into excel with wide column

Question

I want to write a data frame into excel like this :

    df = DataFrame({'Frequency':lenFreq,'Fatigue Thrust    [N]':meqThrust[iexcel],'Extreme Thrust [N]':extremeThrust[iexcel],'Extreme Thrust DMR [N]':extremeThrustDMR[iexcel],\
                'Fatigue Yaw [Nm]':meqYaw[iexcel],'Extreme Yaw [Nm]':extremeYaw[iexcel],'Extreme Flapwise [Nm]':extremeFlapwise[iexcel][ilenFreq]})

    df.to_excel(workbookOutput, sheet_name='Results', index=False)

but every time I open the file I need to expand columns :

enter image description here

I would like to know an option to expand columns automatically when writing to excel. Thanks

Pandas dev ruled this out of scope. You may find some direction in these answers stackoverflow.com/questions/6929115 — Zero
– Zero, Commented Apr 21, 2015 at 15:19
Related, if not outright duplicate: stackoverflow.com/questions/17326973/… (this was even mentioned in the Pandas issue tracker thread linked to by @JohnGalt). — John Y
– John Y, Commented Apr 21, 2015 at 16:48

farhawa · Accepted Answer · 2015-04-21 19:19:24Z

1

I don't think there is a way to directly re-size excel cells when you call df.to_excel() but here is a way to do it after that call

df = DataFrame({'Frequency':lenFreq,'Fatigue Thrust    [N]':meqThrust[iexcel],'Extreme Thrust [N]':extremeThrust[iexcel],'Extreme Thrust DMR [N]':extremeThrustDMR[iexcel],\
             'Fatigue Yaw [Nm]':meqYaw[iexcel],'Extreme Yaw [Nm]':extremeYaw[iexcel],'Extreme Flapwise [Nm]':extremeFlapwise[iexcel][ilenFreq]})

df.to_excel(workbookOutput, sheet_name='Results', index=False)

sheet = workbookOutput.sheet_by_name('Results')
nrows = len(sheet.get_rows())
ncolumns = len(sheet.get_cols())

for row_index in range (nrows):
    for column_index in range(ncolumns) :
      cwidth = sheet.col(column_index).width
      column_data = sheet.cell(row_index,column_index).value
      if (len(column_data)*367) > cwidth:  
          sheet.col(column_index).width = (len(column_data)*367)

edited Apr 21, 2015 at 19:19

answered Apr 21, 2015 at 15:46

farhawa

10.5k16 gold badges58 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yu Shen Over a year ago

What's the data structure of workbookOutput? Is it a ExcelWriter?

Collectives™ on Stack Overflow

Write data frame into excel with wide column

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related