Combine multi excel files into one large xlsx
combine2xlsx is a utility to combine multi Microsoft Excel files into a large one(.xlsx). Currently it only supports xls and xlsx files as input.
Go to combine2xlsx in pypi.
Why Should I Use This?
The maximum row number of xls is only 65536. Thus, you cannot merge it as an xls file. And the xlwt module doesn’t support the xls format.
Secondly, the pandas module’s API seems to be simple enough, but it is quite slow, and memory-inefficient.
First, you can install it via
$ pip3 install combine2xlsx
import combine2xlsx combine2xlsx.combine(['input1.xls', 'input2.xlsx'], 'outputname.xlsx')
- Folk the repository on GitHub.
- Make a branch off of master and commit your changes to it.
- Submit a Pull Request to the master branch on GitHub.
If you’d like to have a development environment for combine2xlsx, you should create a virtualenv and then do pip install -e . from within the directory.