pycargo is a simple to use helper library for exporting and loading data from excel. Its a common requirement in web applications for bulk loading of data. Pycargo hides all the working and gives you easy to use methods for easy exporting of templates and loading data.
from pycargo import fields
from pycargo.spreadsheet import SpreadSheet
class CustomerSpreadSheet(SpreadSheet):
name = fields.StringField(comment="Customer Name")
code = fields.IntegerField(required=True, data_key="Code")
created_on = fields.DateTimeField()
cs = CustomerSpreadSheet()
# Exporting templates
cs.export_template("customer_template.xlsx", only=["name", "code"])
# Bulk loading
dataset = cs.load("customer_template.xlsx")So with pycargo you can:
- Export template for loading data
- Load data from the templates
- Validate loaded data.
$ pip install -U pycargo
- Python >= 3.6