Django implementation of Handsontable spreadsheets for CRUD actions.
Project description
Django implementation of Handsontable spreadsheets for CRUD actions.
Installation
Install django-funky-sheets:
$ pip install django-funky-sheets
Add funky_sheets to your INSTALLED_APPS:
# settings.py
INSTALLED_APPS = [
...
'funky_sheets',
...
]
Quick Start
URL
Define URLs for Create and Update views.
# urls.py
from django.urls import path
from . import views
urlpatterns = [
path('', views.index, name='index'),
path('create/', views.CreateMovieView.as_view(), name='create'),
path('update/', views.UpdateMovieView.as_view(), name='update')
]View
Define Create and Update views which inherit from HotView and render the Handsontable spreadsheet based on selected model fields.
# views.py
from django.forms import CheckboxSelectMultiple, CheckboxInput, DateInput
from django.urls import reverse_lazy
from funky_sheets.formsets import HotView
from .models import Movie
class CreateMovieView(HotView):
# Define model to be used by the view
model = Movie
# Define template
template_name = 'examples/create.html'
# Define prefix for the formset which is constructed from Handsontable spreadsheet on submission
prefix = 'table'
# Define success URL
success_url = reverse_lazy('update')
# Define fields to be included as columns into the Handsontable spreadsheet
fields = (
'id',
'title',
'director',
'release_date',
'parents_guide',
'imdb_rating',
'genre',
'imdb_link',
)
# Define extra formset factory kwargs
factory_kwargs = {
'widgets': {
'release_date': DateInput(attrs={'type': 'date'}),
'genre': CheckboxSelectMultiple(),
'parents_guide': CheckboxInput(),
}
}
# Define Handsontable settings as defined in Handsontable docs
hot_settings = {
'contextMenu': 'true',
'autoWrapRow': 'true',
'rowHeaders': 'true',
'contextMenu': 'true',
'search': 'true'
}
class UpdateMovieView(CreateMovieView):
template_name = 'examples/update.html'
# Define 'update' action
action = 'update'
# Define 'update' button
button_text = 'Update'Template
Define templates which include hot_template in place where you want to render Handsontable spreadsheet.
examples/create.html
...
{% include hot_template %}
...
examples/update.html
...
{% include hot_template %}
...Contribute
This is an Open Source project and any contribution is appreciated.
License
This project is licensed under the MIT License.
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
django-funky-sheets-0.1.0.tar.gz
(11.2 kB
view hashes)
Close
Hashes for django-funky-sheets-0.1.0.tar.gz
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 48e92cc98833d5d1acdfe4950ef25c708795be7367fbb939db407f8d90b62271 |
|
| MD5 | da1f28d95c7ab30f423aa03b6ad3c083 |
|
| BLAKE2b-256 | edd6d13d3691852d9588ee73786c24d0cd8a3f5044ed4b755f909589527597fc |
