CODEWITHSUNDEEP
pythonexcel
Andres Felipe Yie Pinedo
Andres Felipe Yie Pinedo

Reputation: 33

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

I've been trying to do this and I really got no clue. I've search a lot and i know that i can merge the files with easily with VBA or other languages, but i really want to do it with Python.

Can anyone get me on track?

Upvotes: 2

Views: 339

Answers (1)

GymLoverBabe
GymLoverBabe

Reputation: 36

I wished there was a straight forward support from openpyxl/xlsxwriter to copy sheets across different workbooks.

However, I see you would have to mash up a recipe using a couple of libraries:

  1. One for reading the worksheet data and,
  2. Another for writing data to a unified xlsx

For both of the above there are lot of options in terms of python packages.

Upvotes: 1

Related Questions