mid.append(base[rem])
return ''.join([str(x) for x in mid[::-1]])

#二进制 to 十六进制

def bin2hex(string_num):

return dec2hex(bin2dec(string_num))

hex2dec

十六进制 to 十进制

def hex2dec(string_num):

return str(int(string_num.upper(), 16))

十六进制 to 二进制: bin(int(str,16))

def hex2bin(string_num):

return dec2bin(hex2dec(string_num.upper()))

#为字符串按照输入长度补’0’

def add_zero(str,gd_length):

if (str.len() < gd_length):

add_zero = ‘0’

for i in range(gd_length - str.len() - 1):

add_zero += ‘0’

str = add_zero + str

return str

def EPC(request):

#获取数据

CompanyPrefixLength = int(request.POST.get(‘CompanyPrefixLength’, 0))

FilterValue = request.POST.get(‘FilterValue’, 0)

UPC = request.POST.get(‘UPC’, 0)

SerialNumber = int(request.POST.get(‘SerialNumber’, 0)) - 1

StartSerialNumber = SerialNumber + 1

AllNumber = int(request.POST.get(‘AllNumber’, 0))

#创建excel表

wb = openpyxl.Workbook()

wa = wb.active

wa.column_dimensions[‘B’].width = 15

wa.column_dimensions[‘C’].width = 20

wa.column_dimensions[‘D’].width = 30

wa.append([‘ID’, ‘SerialNumber’, ‘BarCode’, ‘EPC’])

ID = 0

ExcelIndex = 1 # excel插入行数据索引

#Header 二进制8bits

Header_bits = ‘00110000’

#filter过滤值3bits

if FilterValue == ‘0’:

Filter_bits = ‘000’

elif FilterValue == ‘1’:

Filter_bits = ‘001’

elif FilterValue == ‘2’:

Filter_bits = ‘010’

elif FilterValue == ‘3’:

Filter_bits = ‘011’

elif FilterValue == ‘4’:

Filter_bits = ‘100’

elif FilterValue == ‘5’:

Filter_bits = ‘101’

elif FilterValue == ‘6’:

Filter_bits = ‘110’

elif FilterValue == ‘7’:

Filter_bits = ‘111’

else:

print(‘error’)

# 根据GS1公司前缀长度进而判断

if CompanyPrefixLength == 6:

Cutoff_Point = 7

GS1_Company_Prefix_bitslen = 20

ID_IRN_bitslen = 24

Partition_bits = ‘110’ # 6

elif CompanyPrefixLength == 7:

Cutoff_Point = 8

GS1_Company_Prefix_bitslen = 24

ID_IRN_bitslen = 20

Partition_bits = ‘101’ # 5

elif CompanyPrefixLength == 8:

Cutoff_Point = 9

GS1_Company_Prefix_bitslen = 27

ID_IRN_bitslen = 17

Partition_bits = ‘100’ # 4

elif CompanyPrefixLength == 9:

Cutoff_Point = 10

GS1_Company_Prefix_bitslen = 30

ID_IRN_bitslen = 14

Partition_bits = ‘011’ # 3

elif CompanyPrefixLength == 10:

Cutoff_Point = 11

GS1_Company_Prefix_bitslen = 34

ID_IRN_bitslen = 10

Partition_bits = ‘010’ # 2

elif CompanyPrefixLength == 11:

Cutoff_Point = 12

GS1_Company_Prefix_bitslen = 37

ID_IRN_bitslen = 7

Partition_bits = ‘001’ # 1

elif CompanyPrefixLength == 12:

Cutoff_Point = 13

GS1_Company_Prefix_bitslen = 40

ID_IRN_bitslen = 4

Partition_bits = ‘000’ # 0

GTIN_BITS_PRO = Header_bits + Filter_bits + Partition_bits
GS1_Company_Prefix = UPC[1:Cutoff_Point]
ID_IRN = UPC[0] + UPC[Cutoff_Point:13]
# GS1\_Company\_Prefix化为二进制，如果不够规定位数，前面加'0'
GS1_Company_Prefix_bits = add_zero(dec2bin(GS1_Company_Prefix), GS1_Company_Prefix_bitslen)  # 24bits
# ID\_IRN 化为二进制，如果不够规定位数，前面加'0'
ID_IRN_bits = add_zero(dec2bin(ID_IRN), ID_IRN_bitslen)
GTIN_BITS = GTIN_BITS_PRO + GS1_Company_Prefix_bits + ID_IRN_bits
for i in range(AllNumber):
    ID += 1
    ExcelIndex += 1
    SerialNumber += 1
    wa.cell(ExcelIndex, 1, str(ID))
    wa.cell(ExcelIndex, 2, str(SerialNumber))
    wa.cell(ExcelIndex, 3, str(UPC))
    wa.cell(ExcelIndex, 4, bin2hex(GTIN_BITS + add_zero(dec2bin(SerialNumber), 38)))
output = BytesIO()
wb.save(output)
output.seek(0)
response = HttpResponse(output.getvalue(), content_type='application/vnd.ms-excel')
# ctime = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
# file\_name = 'export.xls' % ctime # 给文件名中添加日期时间
# file\_name = urlquote(file\_name) # 使用urlquote()方法解决中文无法使用的问题
response['Content-Disposition'] = 'attachment; filename=bug\_info.xls'
# response.write(output.getvalue()) # 在设置HttpResponse的类型时，如果给了值，可以不写这句
return response

前端请求代码与返回结果：

if(CheckData() == true){

KaTeX parse error: Expected '}', got 'EOF' at end of input: …nyPrefixLength:(“.CompanyPrefixLength”).val(),

FilterValue: ( " . F i l t e r V a l u e " ) . v a l ( ) , U P C : (".FilterValue").val(), UPC: (".FilterValue").val(),UPC:(“.UPC”).val(),

SerialNumber: ( " . S e r i a l N u m b e r " ) . v a l ( ) , A l l N u m b e r : (".SerialNumber").val(), AllNumber: (".SerialNumber").val(),AllNumber:(“.AllNumber”).val()

},

type:‘POST’,

dataType:‘json’,

complete:function (data) {

console.log(“complete”);

console.log(data);

}

})

返回的数据应该都是存储在reponseTest，还有乱码，所以可以用XMLHttpRequest来请求。  
 ![在这里插入图片描述](https://img-blog.csdnimg.cn/f3fd3344120a4316831eb933f707aa08.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBAQ2hlbldlbktlbg==,size_17,color_FFFFFF,t_70,g_se,x_16#pic_center)  
 前端用XMLHttpRequest请求代码：

let data = JSON.stringify({

“CompanyPrefixLength”: ( " . C o m p a n y P r e f i x L e n g t h " ) . v a l ( ) , " F i l t e r V a l u e " : (".CompanyPrefixLength").val(), "FilterValue": (".CompanyPrefixLength").val(),"FilterValue":(“.FilterValue”).val(),

“UPC”: ( " . U P C " ) . v a l ( ) , " S e r i a l N u m b e r " : (".UPC").val(), "SerialNumber": (".UPC").val(),"SerialNumber":(“.SerialNumber”).val(),

“AllNumber”😒(“.AllNumber”).val()

})

const req = new XMLHttpRequest();

req.open(‘POST’,‘http://192.168.0.68:8000/conversion/EPC/’, true);

req.responseType = ‘blob’;