Skip to main content
https://raw.githubusercontent.com/pyexcel/pyexcel.github.io/master/images/patreon.png https://api.travis-ci.org/pyexcel/sphinxcontrib-excel.svg?branch=master https://codecov.io/github/pyexcel/sphinxcontrib-excel/coverage.png

sphinxcontrib-excel uses pyexcel to read an excel files and renders into an excel-alike sheet in your sphinx documentation. The excel file formats are:

  1. csv

  2. tsv

  3. csvz

  4. tsvz

  5. xls

  6. xlsx

  7. xlsm

  8. ods

Installation

You can install it via pip:

$ pip install sphinxcontrib-excel

or clone it and install it:

$ git clone https://github.com/pyexcel/sphinxcontrib-excel.git
$ cd sphinxcontrib-excel
$ python setup.py install

Setup

Please add sphinxcontrib-excel into your conf.py file:

extensions = [
        ...
        'sphinxcontrib.excel',
        ...
    ]

And you will need to copy a few resources file to your sphinx source directory:

resources/_template/layout.html
resources/_static/handsontable.full.min.js
resources/_static/handsontable.full.min.css

Here is the syntax to present your excel file in sphinx documentation:

.. pyexcel-table:: filename.csv

And ‘filename.csv’ is expected in the directory where the referring rst file is. Relative path needs to be given if your file is somewhere else.

For example, the following rst statment:

table directive

is translated as:

table view

Embed csv into your sphinx documentation

Here is the syntax for embedded csv rendering as a single handsontable:

.. pyexcel-table::

   ---pyexcel:example table---
   Name,Age
   Adam,28
   Beatrice,29
   Ceri,30
   Dean,26

Here is the complex example for embedded csv, which will be rendered as multi-tab handsontable):

.. pyexcel-table::

   ---pyexcel:Sheet 1---
   1,2,3
   4,5,6
   7,8,9
   ---pyexcel---
   ---pyexcel:Sheet 2---
   X,Y,Z
   1,2,3
   4,5,6
   ---pyexcel---
   ---pyexcel:Sheet 3---
   O,P,Q
   3,2,1
   4,3,2

Support the project

If your company has embedded pyexcel and its components into a revenue generating product, please support me on patreon to maintain the project and develop it further.

If you are an individual, you are welcome to support me too on patreon and for however long you feel like to. As a patreon, you will receive early access to pyexcel related contents.

With your financial support, I will be able to invest a little bit more time in coding, documentation and writing interesting posts.

Development guide

Development steps for code changes

  1. git clone https://github.com/pyexcel/sphinxcontrib-excel.git

  2. cd sphinxcontrib-excel

Upgrade your setup tools and pip. They are needed for development and testing only:

  1. pip install –upgrade setuptools pip

Then install relevant development requirements:

  1. pip install -r rnd_requirements.txt # if such a file exists

  2. pip install -r requirements.txt

  3. pip install -r tests/requirements.txt

In order to update test environment, and documentation, additional steps are required:

  1. pip install moban

  2. git clone https://github.com/pyexcel/pyexcel-commons.git commons

  3. make your changes in .moban.d directory, then issue command moban

What is rnd_requirements.txt

Usually, it is created when a dependent library is not released. Once the dependecy is installed(will be released), the future version of the dependency in the requirements.txt will be valid.

What is pyexcel-commons

Many information that are shared across pyexcel projects, such as: this developer guide, license info, etc. are stored in pyexcel-commons project.

What is .moban.d

.moban.d stores the specific meta data for the library.

How to test your contribution

Although nose and doctest are both used in code testing, it is adviable that unit tests are put in tests. doctest is incorporated only to make sure the code examples in documentation remain valid across different development releases.

On Linux/Unix systems, please launch your tests like this:

$ make

On Windows systems, please issue this command:

> test.bat

License

New BSD License

Metadata

Release files for sphinxcontrib-excel 0.0.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for sphinxcontrib-excel 0.0.1
File Size Uploaded
sphinxcontrib-excel-0.0.1.tar.gz 5.2 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for sphinxcontrib-excel 0.0.1
File Interpreter ABI Platform
sphinxcontrib_excel-0.0.1-py2.py3-none-any.whl Python 3, Python 2 none any Details

Total release size: 12.7 kB

Release files / sphinxcontrib-excel-0.0.1.tar.gz

Download URL sphinxcontrib-excel-0.0.1.tar.gz
Size 5.2 kB
Tags Source
SHA-256 checksum
How to use checksums
ac052abb2b3f3687ad196749df54d4b0202f9b1200678d13ad46ea62cd8f46f9
BLAKE2b-256 checksum
How to use checksums
852d485910497f77724e7492c5324ede43d24b3fba6f051d6a44c22f924154d1
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Release files / sphinxcontrib_excel-0.0.1-py2.py3-none-any.whl

Download URL sphinxcontrib_excel-0.0.1-py2.py3-none-any.whl
Size 7.5 kB
Tags Python 2 Python 3
SHA-256 checksum
How to use checksums
5ae7a5d57953d91bf0c8a8b7eeba6b97afb4b79ea47493d77989e032639e9da1
BLAKE2b-256 checksum
How to use checksums
610c41a79554f7da024b8db6d94737dd76a03f9ca168ad372e5d23d3609a1ef5
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Release history Release notifications | RSS feed

This release

0.0.1 This release

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page