python--读取excel通过django框架入库mysql(完整代码)

水痕 2020-01-18

import xlrd , uuidclass JenkinsImport(View):
    def get(self,request):
        xls = xlrd.open_workbook(‘./test.xls‘)
        sheets = xls.sheet_names()  # 所有sheet,列表
        table = xls.sheets()[1]
        rows = table.nrows
        for line in range(1, rows):
            item = table.row_values(line)
            print(item)
            text = item[1]   # excel第二列

            snippet = Categroy.objects.create(
                text = text if text else None,
                cate_uuid=uuid.uuid4(),
            )return JsonResponse({})

相关推荐

inspuryhq / 0评论 2020-07-28