code 1716

 

#27 import_company
    def test_import_company(self):
        headers=self.headers
        headers["Content-Type"]="multipart/form-data; boundary=----WebKitFormBoundarywknEiWB8ukxAa0zz"
        


        #获取导入模版
        file_home = self.import_template
        log.info(file_home)
        
        wb = load_workbook(filename=file_home)
        ws = wb['sheet1']
        # 修改产废单位名称，以及备注
        ws['b3'] = 'itest产废单位'+self.dic["t"]
        ws['s3'] = 'i原料销售'+self.dic["t"]
        wb.save(file_home)

        url=self.url_1+"/companies/import"
        payload={"companyType":2}
        files = {'file': ('name.xls', open(file_home, 'rb'),'application/vnd.ms-excel')}

        r = requests.post(url, params=payload,headers=headers,files=files)
        log.info(r.json())
        assert r.status_code==200
        assert r.json()['code']==200