一、使用workbook.get_sheet_by_name(name) 获取excel一个工作表时，发生字符集解析的错误。
网上搜集解决方案为添加以下三句：
import sys
reload(sys)
sys.setdefaultencoding("utf8")
相关文章
- 12-11【python】UnicodeEncodeError: 'ascii' codec can't encode/decode characters
- 12-11python3 UnicodeEncodeError: 'gbk' codec can't encode character '\xa0' in position 30: illegal multibyte sequence
- 12-11python3 UnicodeEncodeError: 'gbk' codec can't encode character '\U0001f9e0' in position 230: illegal multibyte sequence
- 12-11解决python3 UnicodeEncodeError: 'gbk' codec can't encode character '\xXX' in
- 12-11Docker内报错UnicodeEncodeError: ‘ascii‘ codec can‘t encode character ‘\u516c‘ in position 0
- 12-11接口测试中读取excel中的请求数据含有中文问题，UnicodeEncodeError: 'latin-1' codec can't encode character &
- 12-11解决UnicodeEncodeError: 'ascii' codec can't encode character
- 12-11python报错“UnicodeEncodeError: 'ascii' codec can't encode characters in position 22-26: ordinal not in range(128)”问题解决
- 12-11UnicodeEncodeError: ‘ascii‘ codec can‘t encode characters in position……错误的解决，亲测有效
- 12-11python3 输出中文报错UnicodeEncodeError: ‘ascii‘ codec can‘t encode解决方式