How to Save excel pages file with a loop?

Question

i would like to save a different dataframe in different excel pages withb a simpler loop. How can i construct correctly this loop?

my Currently codes are:

for fund in list(read_ex.keys()):
    writer = pd.ExcelWriter(excel_file, engine='xlsxwriter')
    data_2             .to_excel(writer, sheet_name= 'Df_ag')
    read_ex[fund]      .to_excel(writer, sheet_name= fund[:28])
    writer.save()

but the returns are only two page: the data_2 and the last in the loop. Thank you for your time!

Imopla

Just move the ExcelWriter(), the first to_excel() and save() outside the loop. — jmcnamara
– jmcnamara, Commented Aug 1, 2022 at 14:08

Agustos Imola · Accepted Answer · 2022-08-01 14:24:35Z

1

For future readers:

I have been resolved this quastion in this way:

writer = pd.ExcelWriter(excel_file, engine='xlsxwriter')
data_2             .to_excel(writer, sheet_name= 'Df_ag')

for fund in list(read_ex.keys()):
    read_ex[fund]      .to_excel(writer, sheet_name= fund[:28]) 
 
writer.save()

answered Aug 1, 2022 at 14:24

Agustos Imola

517 bronze badges

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

Collectives™ on Stack Overflow

How to Save excel pages file with a loop?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related