修改代码错误:mport openpyxl myBook = openpyxl.load_workbook('录取表.xlsx') mySheet = myBook['录取表'] myRange = list(mySheet.values) myDict = {} for myRow in myRange[3:]: if myRow[0] in myDict.keys(): myDict[myRow[0]] += [myRow] else: myDict[myRow[0]] = [myRow] for myKey, myValue in myDict.items(): myNewBook = openpyxl.Workbook() myNewSheet = myNewBook.active myNewSheet.append(myRange[:2]) for myRow in myValue: myNewSheet.append(myRow) myNewSheet.title = myKey+'录取表' myPath = '结果表-'+myKey+'录取表.xlsx' myNewBook.save(myPath)
时间: 2023-06-20 16:06:16 浏览: 69
import openpyxl
myBook = openpyxl.load_workbook('录取表.xlsx')
mySheet = myBook['录取表']
myRange = list(mySheet.values)
myDict = {}
for myRow in myRange[2:]:
if myRow[0] in myDict.keys():
myDict[myRow[0]].append(myRow)
else:
myDict[myRow[0]] = [myRow]
for myKey, myValue in myDict.items():
myNewBook = openpyxl.Workbook()
myNewSheet = myNewBook.active
myNewSheet.append(myRange[0])
myNewSheet.append(myRange[1])
for myRow in myValue:
myNewSheet.append(myRow)
myNewSheet.title = myKey + '录取表'
myPath = '结果表-' + myKey + '录取表.xlsx'
myNewBook.save(myPath)
这个代码有两个错误,第一个是在第2行缺少一个空格,应该写成 "import openpyxl";第二个错误是在第9行,应该使用 ".append" 方法而不是 "+=" 方法。
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)