Export to Excel from django shell

Question

I have a function that fetches data from a server and I have taken it in dictionary format. Now I want run that function in django shell and generate that file in my local drive. Here is my program to generate excel, it has HttpResponse which I don't need so what changes do I need to make?

def to_excel(excelStr, filename):  

""" To Generate Excel Sheets """

response = HttpResponse(excelStr, mimetype='application/vnd.ms-excel')
response['Content-Disposition'] = 'attachment; filename=%s.xls' \
    % str(filename)
return response

scytale · Accepted Answer · 2015-08-21 09:13:33Z

3

with open('%s.xls' % (filename,)) as f:
    f.write(excelStr)

answered Aug 21, 2015 at 9:13

scytale

12.7k4 gold badges35 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export to Excel from django shell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related