want to append multiple sheet in excel file using python

Question

concat_Data = pd.DataFrame()
path = r'C:Usersayeshaesttdownloads'
filename = glob.glob(path +"/*.xls")
def concatinate (filename, y):
    append_full=pd.DataFrame()
    for file in filename:
        if y in file:
            df = pd.read_excel(file, sheet_name = None , skiprows= None , nrows = None , usecols = None , header = None,index_col = None, index = None)
            print (df)
            concat_Data = pd.concat(df,sort=False)
            append_full=append_full.append(concat_Data)
    writer=pd.ExcelWriter(r'C:Usersayeshaestupdated.xls')
    append_full.to_excel(writer,index=False ,sheet_name=y,startrow=0)
    for i in xls.sheet_name:
        if i != y:
            append_full.to_excel(writer, index=False.sheet_name = 'y')
    writer.save() 

xls.sheet_name not working and sheet is not append for me it's over ride the old sheet

question from:https://stackoverflow.com/questions/65874142/want-to-append-multiple-sheet-in-excel-file-using-python

Answer 1

Waitting for answers