sphinx-excel

introduction

sphinx-excel uses openpyxl to read an excel file and render it into sphinx document.

installation

you can install sphinx-excel by pip.

python3 -m pip install sphinx-excel

setup

please add sphinxcontrib.excel into your conf.py file.

extensions = [
    'sphinxcontrib.excel',
]

usage

the following code will insert the first sheet of tables.xlsx into sphinx document.

.. excel:: ./tables.xlsx

the excel directive will show the sheet name as the caption of table. you can use :no-caption to remove it.

.. excel:: ./tables.xlsx
   :no-caption:

if you want to specify the caption, you can use :caption: argument.

.. excel:: ./tables.xlsx
   :caption: hello world

excel directive supports all arguments of sphinx native table directive. for example, you can use :align: to change table align style.

.. excel:: ./tables.xlsx
   :align: center

if an excel file contains more than one sheets, you can use :sheet: arguments to specify which sheet to be rendered.

.. excel:: ./tables.xlsx
   :align: center
   :sheet: stuff

the first line of table is in bold font, it means that the first line is header of table. if the table has two rows header, you can use :headers: to tell excel directive.

.. excel:: ./tables.xlsx
   :headers: 2

one more thing

excel directive supports to render merged cell in excel. the content of the cell can be:

• math equtions,
• code snippets, and
• other directives.