[已解决]AttributeError: 'tuple' object has no attribute 'value'

liuhongrun2022

哪里报错

liuhongrun2022

1. from openpyxl import Workbook
   
2. from pandas import read_csv
   
3. 
   
4. df = read_csv('1.csv',encoding='gbk')
   
5. 
   
6. book = Workbook()
   
7. sheet = book.active   # 当前工作表
   
8. sheet['A1'] = list(df.columns)[1]
   
9. sheet['B1'] = list(df.columns)[2]
   
10. 
    
11. book.save("2.xlsx")

复制代码

liuhongrun2022

循环：

1. from openpyxl import Workbook
   
2. from pandas import read_csv
   
3. 
   
4. df = read_csv('1.csv', encoding='gbk')
   
5. 
   
6. book = Workbook()
   
7. sheet = book.active   # 当前工作表
   
8. 
   
9. for i, col in enumerate(df.columns[1:3]):
   
10.     sheet.cell(row=1, column=i+1, value=col)
    
11. 
    
12. book.save("2.xlsx")
    

复制代码