Skip to main content

Use Google Sheets as context variables in Django templates

Project description

Use Google Sheets as context variables in Django templates

https://badge.fury.io/py/django-sheets.png https://travis-ci.org/georgewhewell/django-sheets.png?branch=master https://coveralls.io/repos/georgewhewell/django-sheets/badge.png?branch=master Requirements Status

Usage

In your template:

{% load sheets %}
{% csv "1uPsdcGUnUsf3d2xGHRGUUb7_k5IQPtBvfQY61u8Z8wE" as data %}
<table>
    <thead>
        <tr>
        {% for header in data.headers %}
            <th>{{ header }}</th>
        {% endfor %}
        </tr>
    </thead>
    <tbody>
        {% for row in data.rows %}
        <tr>
            {% for cell in row %}
                <td>{{ cell }}</td>
            {% endfor %}
        </tr>
        {% endfor %}
    </tbody>
</table>

View the output, you should see

Origin (English)

Name (English)

Origin (Native)

Name (Native)

Australia

Nicole Kidman

Australia

Nicole Kidman

Austria

Johann Strauss

Österreich

Johann Strauß

Belgium (Flemish)

Rene Magritte

België

René Magritte

Belgium (French)

Rene Magritte

Belgique

René Magritte

Belgium (German)

Rene Magritte

Belgien

René Magritte

Documentation

Documentation is available at https://django-sheets.readthedocs.org.

History

0.1.2 (2014-24-03)

  • Added gid parameter for multi-sheet documents

0.1.1 (2014-22-01)

  • Added .headers and .rows methods (aliases for [0] and [1:])

0.1.0 (2014-18-01)

  • First release on PyPI.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page