如何解决错误返回binascii.a2b_base64 binascii.Error:填充不正确？

Question

当我创建excel文件和csv文件时，我得到了这个错误。错误显示在purchase_id = self.env['purchase.excel.extended'].create(attach_files)行中。我如何解决这个问题？

下面是我的代码：

for data in datas:       
            record = ';'.join(data)
            output.write(record)
            output.write("\n")
        data = base64.b64encode(bytes(output.getvalue(),"utf-8"))
        print('data', data)

        if platform.system() == 'Linux':
            excel_file1 = ('/tmp/Purchase Report-' + str(datetime.today().date()) + '.xls')
            csv_file1 = ('/tmp/Purchase Report-' + str(datetime.today().date()) + '.csv')

        else:
            excel_file1 = ('Purchase Report-' + str(datetime.today().date()) + '.xls')
            csv_file1 = ('Purchase Report-' + str(datetime.today().date()) + '.csv')
            
        excel_file1 = excel_file1.split('/')[2]
        csv_file1 = csv_file1.split('/')[2]
        
        workbook.save(excel_file1)
        fp = open(excel_file1, "rb")
        file_data = fp.read()
        out = base64.encodestring(file_data)  
                                                    
# Files actions         
        attach_files = {
                'excel_file': excel_file1,
                'file_name': out,
                'csv_file': csv_file1,
                'file_names': data,
            } 
        print(attach_files, 'attach_files')
                      
        purchase_id = self.env['purchase.excel.extended'].create(attach_files)
        fp.close()
        return {
            'type': 'ir.actions.act_window',
            'res_model': 'purchase.excel.extended',
            'res_id': purchase_id,
            'view_mode': 'form',
            'context': self.env.context,
            'target': 'new',
        }

Answer 1

我认为你已经交换了excel文件名和excel文件内容。与CSV文件类似。

attach_files = {
                'excel_file': excel_file1,
                'file_name': out,
                'csv_file': csv_file1,
                'file_names': data,
            }

应该是：

attach_files = {
                'excel_file': out,
                'file_name': excel_file1,
                'csv_file': data,
                'file_names': csv_file1,
            }