def upload_simple_record(request): """ 生成原始记录表view :param request: :return: """ year = request.POST.get("year") month = request.POST.get("month") simple_record = request.FILES.get("simple_record") print(simple_record) aaa = xlrd.open_workbook(file_contents=simple_record.read()) wb, wb_name = deal_original_data(year, month, aaa) # wb为写入excel obj, wb_name为其文件名 # # wb = xlwt.Workbook() # # ws = wb.add_sheet('Sheetname') # # # # response = HttpResponse(content_type="application/ms-excel") # # response['Content-Disposition'] ='attachment; filename=%s' % ('111.xls') # # wb.save(response) b = io.BytesIO() wb.save(b) # 存入缓存 excel_bytes = b.getvalue() # 获得二进制文本 import sys reload(sys) sys.setdefaultencoding("utf-8") url = my_qiniu.excel_upload(excel_bytes, wb_name) return HttpResponse(url)
def upload_simple_record(request): """ 生成原始记录表view :param request: :return: """ year = request.POST.get('year') month = request.POST.get('month') simple_record = request.FILES.get('simple_record') print(simple_record) aaa = xlrd.open_workbook(file_contents=simple_record.read()) wb, wb_name = deal_original_data(year, month, aaa) # wb为写入excel obj, wb_name为其文件名 # # wb = xlwt.Workbook() # # ws = wb.add_sheet('Sheetname') # # # # response = HttpResponse(content_type="application/ms-excel") # # response['Content-Disposition'] ='attachment; filename=%s' % ('111.xls') # # wb.save(response) b = io.BytesIO() wb.save(b) # 存入缓存 excel_bytes = b.getvalue() # 获得二进制文本 import sys reload(sys) sys.setdefaultencoding('utf-8') url = my_qiniu.excel_upload(excel_bytes, wb_name) return HttpResponse(url)
def write_all_duty_record_table_view(request): """ 生成当月员工考勤记录总表view :param request: :return: """ year = request.POST.get('year') month = request.POST.get('month') original_data = request.FILES.get('original_data_table_a') aaa = xlrd.open_workbook(file_contents=original_data.read()) wb, wb_name = write_all_duty_record_table(year, month, aaa) # wb为写入excel obj, wb_name为其文件名 b = io.BytesIO() wb.save(b) # 存入缓存 excel_bytes = b.getvalue() # 获得二进制文本 import sys reload(sys) sys.setdefaultencoding('utf-8') url = my_qiniu.excel_upload(excel_bytes, wb_name) return HttpResponse(url)
def write_all_duty_record_table_view(request): """ 生成当月员工考勤记录总表view :param request: :return: """ year = request.POST.get("year") month = request.POST.get("month") original_data = request.FILES.get("original_data_table_a") aaa = xlrd.open_workbook(file_contents=original_data.read()) wb, wb_name = write_all_duty_record_table(year, month, aaa) # wb为写入excel obj, wb_name为其文件名 b = io.BytesIO() wb.save(b) # 存入缓存 excel_bytes = b.getvalue() # 获得二进制文本 import sys reload(sys) sys.setdefaultencoding("utf-8") url = my_qiniu.excel_upload(excel_bytes, wb_name) return HttpResponse(url)