HELP : Combine multiple excel files with multiple sheets in 1 working file

#1

Hi All,

Can someone help me to create a program that will combine multiple excel files with multiple sheets in 1 working file. no condition at all.

Im using python3 to run it. .PY file

Thank you in advance!

#2

If the files only contain data, I would suggest using Pandas. If you need more advanced functions, please see xlwings: https://www.xlwings.org/

#3

pandas will do sir… however, i dont know how to code it…