'Worksheet' object has no attribute 'writer
时间: 2023-10-24 12:05:07 浏览: 30
It looks like you are trying to use the attribute 'writer' on a 'Worksheet' object, but this attribute does not exist on this object.
The 'writer' attribute is typically used on a 'Workbook' object to write data to a file.
Make sure you are using the correct object and attribute for your intended action.
相关问题
'Worksheet' object has no attribute 'columns'
错误提示"AttributeError: 'Worksheet' object has no attribute 'set_column'"是因为Excel对象没有"set_column"属性。根据引用的经验,这个错误可能是由于使用了错误的Excel文件后缀导致的。改为使用.xlsx后缀的文件可能会解决这个问题。此外,根据引用和引用的情况,可能还有其他原因导致这个错误,比如使用了错误的方法或数据格式转换问题。请检查你的代码,确保使用了正确的方法和数据格式。如果问题仍然存在,请提供更多的上下文信息以便进一步帮助。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [Python错误: AttributeError: ‘Worksheet‘ object has no attribute ‘set_column‘ 解决办法](https://blog.csdn.net/qq_39691492/article/details/119757362)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *3* [完美解决AttributeError: ‘Series‘ object has no attribute ‘columns](https://blog.csdn.net/weixin_50843918/article/details/130537647)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
'Worksheet' object has no attribute 'append'
在Python脚本中遇到AttributeError: 'NoneType' object has no attribute 'append'错误是因为你在尝试给一个空列表添加元素时使用了`.append()`方法的错误语法。正确的用法是直接使用`a.append(b)`而不是`a = a.append(b)`。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [python:python提示AttributeError: ‘NoneType‘ object has no attribute ‘append](https://blog.csdn.net/zhizhengguan/article/details/130127267)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"]
- *2* *3* [Python错误: AttributeError: ‘Worksheet‘ object has no attribute ‘set_column‘ 解决办法](https://blog.csdn.net/qq_39691492/article/details/119757362)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]