我试图写一些代码,从网站导出一些数据到excel表格。这是我试图用Django重写整个网站的一部分。下面是我为导出编写的脚本。在
def national_proposal_export_xlsx(modeladmin, request, queryset):
import openpyxl
from openpyxl.cell import get_column_letter
response = HttpResponse(content_type='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet')
response['Content-Disposition'] = 'attachment; filename=conference_proposals_export.xlsx'
wb = openpyxl.Workbook()
ws = wb.get_active_sheet()
ws.title = "Conference_proposals"
row_num = 0
columns = [
(u"Master", 15),
(u"Code", 15),
(u"Title", 70),
(u"Begin Time", 15),
(u"End Time", 15),
(u"Event type", 15),
(u"Status", 15),
# (u"Published", 15),
# (u"Up to date", 15),
]
for col_num in range(len(columns)):
c = ws.cell(row=row_num + 1, column=col_num + 1)
c.value = columns[col_num][0]
# c.style.font.bold = True
ws.column_dimensions[get_column_letter(col_num+1)].width = columns[col_num][1]
for obj in queryset:
row_num += 1
row = [
obj.master,
obj.code,
obj.title,
obj.begin_time,
obj.end_time,
obj.event_type,
obj.status,
# obj.published,
# obj.up_to_date,
]
for col_num in range(len(row)):
c = ws.cell(row=row_num + 1, column=col_num + 1)
c.value = row[col_num]
c.style.alignment.wrap_text = True
wb.save(response)
return response
但由于某些原因,我得到了以下错误:
ValueError at /admin/events/nationalconferenceproposal/
Cannot convert 9000476 | TEST SESSION 001 (draft) to Excel
Request Method: POST
Request URL: http://localhost:8000/admin/events/nationalconferenceproposal/
Django Version: 1.7.3
Exception Type: ValueError
Exception Value:
Cannot convert 9000476 | TEST SESSION 001 (draft) to Excel
Exception Location: /Users/dthota/Code/venvs/planning/lib/python3.4/site-packages/openpyxl/cell/cell.py in _bind_value, line 217
Python Executable: /Users/dthota/Code/venvs/planning/bin/python
Python Version: 3.4.3
它表示错误与最后一个for循环中的c.value = row[col_num]
有关。但我不明白!在
我知道这是一个老问题,但我只是在努力解决一个类似的问题。对我来说,解决方案是将行[col_num]转换为字符串:
请注意,数据随后以文本形式保存在excel工作簿上,因此,如果要对数据进行计算等,则可能需要其他内容。在
相关问题 更多 >
编程相关推荐