Export pandas dataframe to excel sheet

Question

I have a dictionary of dataframes and need to export them to excel.

mycollection = {'company1': df1, 'company2': df2, 'company3': df3}

I need to export all 3 dataframes to a single excel file using 3 sheets. Each sheet should be named the company number for e.g. "company3".

There are around 200 dataframes in the mycollection dictionary. I can use to_excel method to export data to excel, but that will create 200 excel files. Is it possible to export dataframe to sheets?

jezrael · Accepted Answer · 2020-08-19 12:57:54Z

1

Use ExcelWriter with iter dicts and write by DataFrame.to_excel:

with pd.ExcelWriter('output.xlsx') as writer:  
    for k, v in mycollection.items():
        v.to_excel(writer, sheet_name=k)

answered Aug 19, 2020 at 12:57

jezrael

868k102 gold badges1.4k silver badges1.3k bronze badges

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

2 Comments

shantanuo Over a year ago

# InvalidWorksheetName: Excel worksheet name 'XXXX_YYYY_promo_194_del_ZZZ_may2017' must be <= 31 chars.

shantanuo Over a year ago

It seems that I need to truncate long sheet names to 31 characters without duplicating! sheet_name=k[:30] may or may not always work

Collectives™ on Stack Overflow

Export pandas dataframe to excel sheet

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related