对于循环附加 Excel 工作表不起作用

Question

我试图附加这张纸，但最后只显示第一张纸xls = pd.ExcelFile('MyFile.xlsx')for sheetname in xls.sheet_names:    sheetname = pd.read_excel('MyFile.xlsx', sheet_name = sheetname, header=[8,9])    sheetname.drop(sheetname.tail(3).index,inplace=True)    out_df = sheetname.append(sheetname)

Answer 1

见下文：

xls = pd.ExcelFile('MyFile.xlsx')

for sheetname in xls.sheet_names:

    sheetname = pd.read_excel('MyFile.xlsx', sheet_name = sheetname, header=[8,9])

    sheetname.drop(sheetname.tail(3).index,inplace=True)

    out_df = out_df.append(sheetname)

    # -------^^^^^^

已标记更正