Common function when working with excel.
Project description
Django Excel Tools
Common function when working with excel.
Requirements
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.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
django_excel_tools-0.0.6.tar.gz
(16.1 kB
view details)
File details
Details for the file django_excel_tools-0.0.6.tar.gz
.
File metadata
- Download URL: django_excel_tools-0.0.6.tar.gz
- Upload date:
- Size: 16.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 |
fd7107060b06fb5783413d4aa5f021ebafc03ebae78d42bac0b56bed6409c486
|
|
MD5 |
1f98c9944d69b46ec1ede60a57314a18
|
|
BLAKE2b-256 |
5ff04b76e94acaadebc11161f6c60f0ffc744eb11b299737a3fead6ff0c97078
|