Skip to main content

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.

Release files for django-sheets 0.1.2

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

Source distribution (sdist)

Source distribution for django-sheets 0.1.2
File Size Uploaded
django-sheets-0.1.2.tar.gz 5.8 kB Details

Release files / django-sheets-0.1.2.tar.gz

Download URL django-sheets-0.1.2.tar.gz
Size 5.8 kB
Tags Source
SHA-256 checksum
How to use checksums
b7769bd50fcc62c64edbb9432ee4f8a950e8c863ec3dbba65785eb4aea3fd277
BLAKE2b-256 checksum
How to use checksums
bb3c1df0a339e5aa2a8c880624b435ed7543d6b214b4004f81e992d82b87acca
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Release history Release notifications | RSS feed

This release

0.1.2 This release

1 release file

0.1.1

1 release file

0.1.0

1 release file

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