Skip to content

openpyxl reaches 1.0 mark

After a few more efforts, I am pleased to announce the release of the first version of openpyxl.

The reader and the writer are working and tested for strings and numbers.

I have been able to read and write simple Excel 2007 xlsx files from Python and open them with Excel.

You can clone the repository using Mercurial:

hg clone https://ericgazoni@bitbucket.org/ericgazoni/openpyxl

or download the release in zip format.

Edit: 1.0 release is really outdated, you might want to get a more recent version here.

The (sparse for now) documentation can be found on the wiki.

Reader usage (using the “empty_book.xlsx” file from the previous example)

from openpyxl.reader.excel import load_workbook

wb = load_workbook(filename = r'empty_book.xlsx')

sheet_ranges = wb.get_sheet_by_name(name = 'range names')

print sheet_ranges.cell('D18').value # should display D18

Code is published under the MIT licence, so you can use it for whatever use you need, and I’d be very happy if  you drop me an email if  you use it 🙂

If you don’t find it useful, spot a bug, or want to suggest an enhancement, you can do so by filling a ticket on the tracker.

Features that will be added in the next version are listed here, so if you need something in this list, please be patient or send me a message to tell me to hurry 😉

Published inOpen sourceOpenpyxlPython

11 Comments

  1. boluns boluns

    it is very useful,i’am try to convert the xlsx to txt,thank you very much!

  2. James James

    Greetings all,

    I’m a student who is new to python and am having a tough time installing openpyxl. My computer is running windows xp 2002 and python 2.6. Can one of you fine people help me out with some easy install tips?

    Thank you in advance for your reply,
    -James

  3. Matthys Kroon Matthys Kroon

    Hey there,

    I’m going to try and use it for some professional data-analysis.

    Will let you know if I succeed.

    • Paul Paul

      Did you get it to work?

      • Matthys Kroon Matthys Kroon

        Hey there Paul,

        Sorry about not replying earlier.

        I had no trouble with the installation and we have had a good experience using the library. We still use it to create excel files for interactive database reporting.

  4. j j

    Using this for an industrial application where I’m updating data in a system export from a large HMI application. Looks promising!

  5. Luis Luis

    I second James request, can we get some instructions on installing it? Thanks.

    • Hi Luis, actually the installation instructions are on the library front page (https://bitbucket.org/ericgazoni/openpyxl/wiki/Home). I’m quoting them here:

      Easy Install
      Releases are also packaged on PyPi, so all you have to type to get the latest version is:

      $ easy_install openpyxl

      You can use pip instead of easy_install (setuptools) or any alternative that might suit you best.

      As a last resort, you can still download a packaged source from the bitbucket website (https://bitbucket.org/ericgazoni/openpyxl/downloads) and use python to run setup.py as follows:

      $ python setup.py

      This will install openpyxl as pip or easy_install would have done it.

      If you need help installing easy_install, here are setuptools installation instructions: http://pypi.python.org/pypi/setuptools#installation-instructions

      • Luis Luis

        Thank you! Sorry I missed the instructions.

        I’m using this for a comercial application, thanks for developing it.

  6. […] on the project since its inception, in a few days from now, version 1.0 will be FOUR years old (see it here). I’d never expect this project to become what it is now, because I didn’t imagine […]

Comments are closed.