[已解决]openpyxl问题

aaron.yang

为什么我运行下面代码会报错：

1. # -*- coding: utf-8 -*-
   
2. 
   
3. import openpyxl
   
4. from openpyxl.styles import PatternFill
   
5. 
   
6. orange = PatternFill(fill_type=None, start_color='#FFA100')
   
7. 
   
8. wb = openpyxl.load_workbook(filename="计划表.xlsx")
   
9. 
   
10. ws = wb.active
    
11. 
    
12. ws.title = "计划表"
    
13. 
    
14. ws["A1"].fill = orange
    

复制代码

报错内容：

1. Traceback (most recent call last):
   
2.   File "D:/files/Aaron/编程/code/python/PycharmProjects/计划表管理/main.py", line 6, in <module>
   
3.     orange = PatternFill(fill_type=None, start_color=(0, 255, 161, 0))
   
4.   File "D:\files\Aaron\编程\code\python\PycharmProjects\计划表管理\venv\lib\site-packages\openpyxl\styles\fills.py", line 91, in __init__
   
5.     self.fgColor = fgColor
   
6.   File "D:\files\Aaron\编程\code\python\PycharmProjects\计划表管理\venv\lib\site-packages\openpyxl\styles\colors.py", line 134, in __set__
   
7.     super(ColorDescriptor, self).__set__(instance, value)
   
8.   File "D:\files\Aaron\编程\code\python\PycharmProjects\计划表管理\venv\lib\site-packages\openpyxl\descriptors\base.py", line 42, in __set__
   
9.     raise TypeError('expected ' + str(self.expected_type))
   
10. TypeError: expected <class 'openpyxl.styles.colors.Color'>
    
11. 
    
12. Process finished with exit code 1

复制代码

最佳答案

月排行榜 / 总排行榜

疾风怪盗

2020-10-4 21:10:56

和你这个fill_type有关吧，而且最后要保存

1. # -*- coding: utf-8 -*-
   
2. 
   
3. import openpyxl
   
4. from openpyxl.styles import PatternFill
   
5. 
   
6. orange = PatternFill(fill_type="solid",  start_color='DC143C')
   
7. 
   
8. wb = openpyxl.load_workbook(filename="1.xlsx")
   
9. 
   
10. ws = wb.active
    
11. 
    
12. #ws.title = "计划表"
    
13. 
    
14. ws["B1"].fill = orange
    
15. ws['B1'].value='1'
    
16. wb.save("1.xlsx")
    

复制代码

跳转到最佳答案楼层

zltzlt

1. # -*- coding: utf-8 -*-
   
2. 
   
3. import openpyxl
   
4. from openpyxl.styles import PatternFill
   
5. from openpyxl.styles.colors import Color
   
6. 
   
7. orange = PatternFill(fill_type=None, start_color=Color('00FFA100'))
   
8. 
   
9. wb = openpyxl.load_workbook(filename="计划表.xlsx")
   
10. 
    
11. ws = wb.active
    
12. 
    
13. ws.title = "计划表"
    
14. 
    
15. ws["A1"].fill = orange
    

复制代码

aaron.yang

zltzlt 发表于 2020-10-4 21:04

又报错了：

1. Traceback (most recent call last):
   
2.   File "D:/files/Aaron/编程/code/python/PycharmProjects/计划表管理/main.py", line 9, in <module>
   
3.     wb = openpyxl.load_workbook(filename="计划表.xlsx")
   
4.   File "D:\files\Aaron\编程\code\python\PycharmProjects\计划表管理\venv\lib\site-packages\openpyxl\reader\excel.py", line 314, in load_workbook
   
5.     data_only, keep_links)
   
6.   File "D:\files\Aaron\编程\code\python\PycharmProjects\计划表管理\venv\lib\site-packages\openpyxl\reader\excel.py", line 124, in __init__
   
7.     self.archive = _validate_archive(fn)
   
8.   File "D:\files\Aaron\编程\code\python\PycharmProjects\计划表管理\venv\lib\site-packages\openpyxl\reader\excel.py", line 96, in _validate_archive
   
9.     archive = ZipFile(filename, 'r')
   
10.   File "C:\Users\Aaron\AppData\Local\Programs\Python\Python37-32\lib\zipfile.py", line 1222, in __init__
    
11.     self._RealGetContents()
    
12.   File "C:\Users\Aaron\AppData\Local\Programs\Python\Python37-32\lib\zipfile.py", line 1289, in _RealGetContents
    
13.     raise BadZipFile("File is not a zip file")
    
14. zipfile.BadZipFile: File is not a zip file
    
15. 
    
16. Process finished with exit code 1

复制代码

zltzlt

aaron.yang 发表于 2020-10-4 21:06
又报错了：

你的 计划表.xlsx 是否能正常打开？

疾风怪盗

和你这个fill_type有关吧，而且最后要保存

1. # -*- coding: utf-8 -*-
   
2. 
   
3. import openpyxl
   
4. from openpyxl.styles import PatternFill
   
5. 
   
6. orange = PatternFill(fill_type="solid",  start_color='DC143C')
   
7. 
   
8. wb = openpyxl.load_workbook(filename="1.xlsx")
   
9. 
   
10. ws = wb.active
    
11. 
    
12. #ws.title = "计划表"
    
13. 
    
14. ws["B1"].fill = orange
    
15. ws['B1'].value='1'
    
16. wb.save("1.xlsx")
    

复制代码

aaron.yang

zltzlt 发表于 2020-10-4 21:09
你的 计划表.xlsx 是否能正常打开？

修复了，重新创建了一个工作簿，成功了，感谢！
但又出现了一个问题：为什么单元格A1并没有变成橙色？

疾风怪盗

这个帖子不打算结一下么。。。。。。。。。。。。