Django Excel Tools

Common function when working with excel.

Requirements

Django (1.8 or higher version)
openpyxl

Installations

Install django-excel-tools

pip install django-excel-tools

Usage

Class declaration

from django_excel_tools import serializers


class OrderExcelSerializer(serializers.ExcelSerializers):
    REGION_CHOICES = ('Central', 'North', 'East', 'West', 'South')
    product_name = serializers.CharField(max_length=100, verbose_name='Product Name')
    quantity = serializers.IntegerField(verbose_name='Quantity', blank=True, default=0)
    price = serializers.IntegerField(verbose_name='Price')
    region = serializers.CharField(max_length=10, verbose_name='Region', choices=REGION_CHOICES)
    transaction_date = serializers.DateField(date_format='%Y-%m-%d', date_format_verbose='YYYY-MM-DD',
                                             verbose_name='Transaction Date')

    class Meta:
        start_index = 1
        fields = ('product_name', 'quantity', 'price', 'region', 'transaction_date')

Class initialization

from openpyxl import load_workbook


def import_order():
    workbook = load_workbook(file)  # Create workbook from file. Used openpyxl
    worksheet = workbook.worksheets[0]
    serializer = OrderExcelSerializer(worksheet=worksheet, **kwargs)

Credits

This package was created with Cookiecutter and the audreyr/cookiecutter-pypackage project template.

History

0.1.0 (2017-08-22)

First release on PyPI.

Metadata

Release files for django-excel-tools 0.0.6

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-excel-tools 0.0.6
File	Size	Uploaded
django_excel_tools-0.0.6.tar.gz	16.1 kB	Aug 30, 2017	Details

Release files / django_excel_tools-0.0.6.tar.gz

Download URL	django_excel_tools-0.0.6.tar.gz
Size	16.1 kB
Tags	Source
SHA-256 checksum How to use checksums	`fd7107060b06fb5783413d4aa5f021ebafc03ebae78d42bac0b56bed6409c486`
BLAKE2b-256 checksum How to use checksums	`5ff04b76e94acaadebc11161f6c60f0ffc744eb11b299737a3fead6ff0c97078`
Upload date	Aug 30, 2017
Uploaded using Trusted Publishing? What is trusted publishing?	No