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)
