'How to concatenate Excel Files in foldder with Python pandas?

I have 3 Workbook with each workbook has each sheet in it.I need to join them with single workbook with 3 sheets using python pandas(I tried other Excel engines- openpyxl and xlsxwriter).

My current code :

for files in glob.glob(Dir+"*xlsx):
  excel_file=pd.read_excel(files)
  wb_file=pd.concat(excel_file,index=False)
 wb_file.save()

I didnt achieve the expected Output.I also need to give the sheet name as same as each workbook name.

Error : first argument must be an iterable of pandas objects, you passed an object of type "DataFrame"

python pandas

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'How to concatenate Excel Files in foldder with Python pandas?

Sources

Related Questions