python - Django:导出我内存中的excel文件

Question

我想导出内存中的一些 Excel 文件，这是我的代码。

wrapper = open('/home/filename.xlsx')
response = HttpResponse(wrapper,content_type='application/force-download')
response['Content-Disposition'] = 'attachment ; filename=%s' % smart_str('filename.xlsx')
response['X-Sendfile'] = smart_str('/home/filename.xlsx')
        return response

当我使用Python 2.7时没有问题，但如果我使用Python 3.5则会出现错误

'utf-8' codec can't decode byte 0x9c in position 10:invalid start byte 

我猜错误是因为它们的差异(开放功能)

打开内存中的 Excel 文件并将其导出的正确方法是什么？

Answer 1

在 Python 3.x 中，文件默认以文本模式打开。将第一行更改为:

wrapper = open('/home/filename.xlsx', 'rb')

来自Python 3 documentation (强调我的):

Normally, files are opened in text mode, that means, you read and write strings from and to the file, which are encoded in a specific encoding. If encoding is not specified, the default is platform dependent (see open()). 'b' appended to the mode opens the file in binary mode: now the data is read and written in the form of bytes objects. This mode should be used for all files that don’t contain text.