Django uses Python's built-in CSV library to create Dynamic CSV (Comma Separated Values) file. We can use this library in our project's view file.
Let's see an example, here we have a Django project to which we are implementing this feature. A view function getfile() is created.
In this example, we are creating CSV using static data.
import csv def getfile(request): response = HttpResponse(content_type='text/csv') response['Content-Disposition'] = 'attachment; filename="file.csv"' writer = csv.writer(response) writer.writerow(['1001', 'John', 'Domil', 'CA']) writer.writerow(['1002', 'Amit', 'Mukharji', 'LA', '"Testing"']) return response
Provide url for the function.
While executing to the browser, it renders a CSV file. See the example.
Apart from static data, we can get CSV from the database too. See, the following example in which we are getting data from the table by using the Employee model.
from myapp.models import Employee import csv def getfile(request): response = HttpResponse(content_type='text/csv') response['Content-Disposition'] = 'attachment; filename="file.csv"' employees = Employee.objects.all() writer = csv.writer(response) for employee in employees: writer.writerow([employee.eid,employee.ename,employee.econtact]) return response
Save the file and open into the text editor that contains the following data.
This data is retrieved from the table employee, a snapshot of the table is shown below.
Well, we have seen that this library is very useful to create a dynamic CSV file. Now, implement it into Django project when required.