Skip to main content

Combine multi excel files into one large xlsx

Project description

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.

Demo

First, you can install it via

$ pip3 install combine2xlsx

Example:

import combine2xlsx
combine2xlsx.combine(['input1.xls', 'input2.xlsx'], 'outputname.xlsx')

Contibuting

  1. Folk the repository on GitHub.
  2. Make a branch off of master and commit your changes to it.
  3. 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.

Project details


Release history Release notifications

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
combine2xlsx-0.1.9.tar.gz (2.1 kB) Copy SHA256 hash SHA256 Source None

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page