Content disposition

Question

Hello,

am using xlwt module to create xls file with multiple sheets and i want to display Content disposition with the created file.

 wbk = xlwt.Workbook(encoding='utf-8')
 sheet = workbook.add_sheet('sheet1')

and then

 response.headers['Content-Type'] = \
    gluon.contenttype.contenttype('.xls')
response.headers['Content-disposition'] = 'attachment; filename=projects.xls'\

how can i make the content of wbk inside projects.xls?

Thanks in Advance

Answer 1

Looking at the docs, it seems that you could write out to a StringIO, and then print that out.

import StringIO
output = StringIO.StringIO()
wbk.save(output)

and then use output.getvalue().

I have not tested this at all.

Answer 2

Use the response.body attribute to write the excel file:

wbk.save(response.body)

Answer 3

[dis]claimer: I'm the maintainer of xlwt.

Workbook.save(destination) ...

if destination is an object with a write method (e.g. obtained by [c]StringIO.StringIO()):

xlwt writes to this but doesn't close it. What you use this for and how you dispose of the object are up to you.

else:

xlwt assumes that destination is a string which is interpreted as a file path; xlwt attempts to open a file, write to it, and close it.