import excel in django

1from django.shortcuts import render_to_response
2from django.http import HttpResponseBadRequest
3from django import forms
4from django.template import RequestContext
5import django_excel as excel
6
7class UploadFileForm(forms.Form):
8    file = forms.FileField()
9
10def upload(request):
11    if request.method == "POST":
12        form = UploadFileForm(request.POST, request.FILES)
13        if form.is_valid():
14            filehandle = request.FILES['file']
15            return excel.make_response(filehandle.get_sheet(), "csv")
16        else:
17            return HttpResponseBadRequest()
18    else:
19        form = UploadFileForm()
20    return render_to_response('upload_form.html',
21                              {'form': form},
22                              context_instance=RequestContext(request))
23
24def download(request):
25    sheet = excel.pe.Sheet([[1, 2],[3, 4]])
26    return excel.make_response(sheet, "csv")
27