import xlwings as xw path='C:/Users/Administrator/Desktop/华润武宣项目箱单.xlsx' wb = xw.Book(path) sht = wb.sheets['箱件清单'] sht1 = wb.sheets['1'] case_number = sht.range('a7:a27').value for i in case_number: sht_copy = sht1.copy(name = i) sht_copy['b4'].value = i
总是在改名字那一行出错,不能进行下一步。。。。求大神帮忙,万谢!!!