excel - Merge(Combine) several .xlsx with one worksheet into just one workbook (Python) -

i've been trying , got no clue. i've search lot , know can merge files vba or other languages, want python.

can me on track?

i wished there straight forward support openpyxl/xlsxwriter copy sheets across different workbooks.

however, see have mash recipe using couple of libraries:

1. one reading worksheet data and,
2. another writing data unified xlsx

for both of above there lot of options in terms of python packages.