Web Sheets is a simple module to allow editing models on an online spreadsheet. It is meant to be pythonic and simple. It is based on the excelent django import export resource system.
- Install the module with PIP
- Insure you add 'websheets' to your settings.py :
INSTALLED_APPS = [
...
'websheets',
...
]
- Create some models, we use the Book / Category / Author model from (Django Import Export Documentation](https://django-import-export.readthedocs.io/en/stable/getting_started.html)
- Create a View sublcassing
websheets.views.WebSheetsView
from websheets.views import WebSheetView
from import_export.resources import ModelResource
from demo.models import Book, Category
class BookResource(ModelResource):
class Meta:
model = Book
class CategoryResource(ModelResource):
class Meta:
model = Category
class MySheetView(WebSheetView):
sheet_resource_classes=[("Books",BookResource),
("Cateogories", CategoryResource)]
- Add it to url.py
path('test1/', MySheetView.as_view()),
And you're done. For advanced users it is interesting to override get_sheet_resource_classes
to create sheets dynamically and get_queryset(sheetname)
to fine tune what
data shows in each sheet.