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.
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')
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.