Экспорт данных в Excel в Django с помощью openpyxl

Я пытаюсь экспортировать данные в excel с помощью пакета openpyxl, но django выдает ошибку 'utf-8' codec can't decode byte 0xae in position 3: invalid start byte. Вы передали b'{\x1ah\xae' (<class 'bytes'>).

    class FeedbackExportView(View):

         def get(self, request):
              feedback_queryset = Feedback.objects.all()
              response = HttpResponse(
                         content_type='application/vnd.openxmlformats- 
                         officedocument.spreadsheetml.sheet',
                         )
              response['Content-Disposition'] = 'attachment; filename={date}- 
                                                 feedback.xlsx'.format(
                                   date=datetime.datetime.now().strftime('%Y-%m-%d'),
                                    )
             workbook = Workbook()
             worksheet = workbook.active
             worksheet.title = 'Feedback'
             columns = ['candidate email', 'candidate Name', 'vacancy', 'Interview 
                         Round', 'Interviewer', 'Recommendation']

             row_num = 1
            for col_num, column_title in enumerate(columns, 1):
                  cell = worksheet.cell(row=row_num, column=col_num)
                  cell.value = column_title

           for feedback in feedback_queryset:
              row_num += 1
              row = [
               feedback.candidate.user.email,
               feedback.candidate.user.full_name,
               feedback.candidate.vacancy.title,
               feedback.interview.interview_round,
               feedback.interview.interviewer_id.all()[0].full_name,
               feedback.selection_recommendation,
              ]

          for col_num, cell_value in enumerate(row, 1):
            cell = worksheet.cell(row=row_num, column=col_num)
            cell.value = cell_value

          workbook.save(response)
          return response

Вернуться на верх