pandas writer create "corrupted" file

[freko75]

Hello,
I recently start to learn Python (I use Jupyter), and I do a code which scrap data from several urls. Depending on the frames, I write data in excel files and sheets.
Everything looks fine, but when I open the excel file I have an error message to recover the data like this one :


If I accept, I can see the data correctly but I don't understand why I have this message.
The problem won't appears when the Excel file has only one sheet.

Do you know what can be the cause ?

Thank you.

Example of loop I used :

df = pd.read_html(xurl)
 
    writerhome = ExcelWriter(pathhome+'\\'+home+'_v1.xlsx') 
 
 
    print("******START COPY DATA******")
    for idx,table in enumerate(df) :
        print("************")
        print(idx) #dataframe id in the url
        print(table) #data from the dataframe
 
        if idx >2 and idx <10 : #Tableau home
            print('Copy in '+home+'_v1.xlsx sheetname_home : '+(dictsheets[idx]))
            df[idx].to_excel(writerhome, sheet_name=dictsheets[idx], index=True)
            writerhome.save()

[snippsat]

Use df.to_excel and you should not loop like this in Pandas(has own method for this).
Here are simpler test,see if this work.
Install openpyxl if you have not pip install openpyxl

import pandas as pd


df = pd.DataFrame(
    [[11, 21, 31], [12, 22, 32], [31, 32, 33]],
    index=["one", "two", "three"],
    columns=["a", "b", "c"],
)

print(df)
df.to_excel('to_excel.xlsx', sheet_name='new_sheet')

Output:
        a   b   c
one    11  21  31
two    12  22  32
three  31  32  33