Hello,
I have been trying to export filtered table data to excel but was unlucky.
I can filter the table by date range successfully but can export the
filtered data.
Below is my view.py. Please help....
def export_sickoff_export(request):
if request.method=="POST":
start_date = request.POST.get('start_date')
end_date = request.POST.get('end_date')
search_results =
Prescription.objects.filter(date_precribed__range=[start_date,end_date])
return render(request,
'pharmacist_templates/reports/referrals_report.html', {"data":
search_results})
response = HttpResponse(content_type='application/ms-excel')
response['Content-Disposition'] = 'attachment;
filename=Referrals & Sick-offs' + \
str(datetime.datetime.now())+'.csv'
wb = xlwt.Workbook(encoding='utf-8')
ws = wb.add_sheet('Prescription,Patients')
#Sheet header, first row
row_num = 0
font_style = xlwt.XFStyle()
font_style.font.bold = True
columns = ['Payroll No', 'First Name', 'Last Name', 'Non Work
Related SickOff', 'Work Related SickOff', 'Referral', 'Remarks',
'Date']
for col_num in range(len(columns)):
ws.write(row_num, col_num, columns[col_num], font_style)
# Sheet body, remaining rows
font_style = xlwt.XFStyle()
rows =
Prescription.objects.filter(nurse=request.user.pharmacist).values_list('patient_id__reg_no',
'patient_id__first_name', 'patient_id__last_name',
'non_work_related_sickOff', 'work_related_sickOff', 'referral',
'remarks', 'date_precribed')
for row in rows:
row_num += 1
for col_num in range(len(row)):
ws.write(row_num, col_num, str(row[col_num]), font_style)
# for patient in patients:
# writer.writerow(patient)
wb.save(response)
return response
else:
displaydata =
Prescription.objects.filter(nurse=request.user.pharmacist).order_by('-id')
return render(request,
'pharmacist_templates/reports/referrals_report.html',
{"data":displaydata})
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CADYG20H0kkewMMV4s_Uxbm%2BwS1HYQGtpfRDfWM%3DUMXj%3DeQiKyw%40mail.gmail.com.
