用xlutils.copy写入中文的问题
用xlutils.copy 将中文写入excel文档中
遇到的问题1:
Traceback:
Traceback (most recent call last):
File "C:\Users\Druid\Desktop\New Folder (3)\Luminos RF I.I. system\test_xlwt.py", line 24, in
wb.save(os.path.join(filepath,out_name))
File "D:\python\python27\lib\site-packages\xlwt\Workbook.py", line 643, in save
doc.save(filename, self.get_biff_data())
File "D:\python\python27\lib\site-packages\xlwt\Workbook.py", line 611, in get_biff_data
before += self.all_fonts_num_formats_xf_styles_rec()
File "D:\python\python27\lib\site-packages\xlwt\Workbook.py", line 516, in __all_fonts_num_formats_xf_styles_rec
return self.__styles.get_biff_data()
File "D:\python\python27\lib\site-packages\xlwt\Style.py", line 183, in get_biff_data
result += self._all_num_formats()
File "D:\python\python27\lib\site-packages\xlwt\Style.py", line 208, in _all_num_formats
result += NumberFormatRecord(fmtidx, fmtstr).get()
File "D:\python\python27\lib\site-packages\xlwt\BIFFRecords.py", line 791, in __init
ufmtstr = upack2(fmtstr)
File "D:\python\python27\lib\site-packages\xlwt\UnicodeUtils.py", line 50, in upack2
us = unicode(s, encoding)
TypeError: coercing to Unicode: need string or buffer, NoneType found
def upack2(s, encoding='ascii'):
# If not unicode, make it so.
if isinstance(s, unicode):
us = s
elif s is not None:
us = unicode(s, encoding)
else:
us = unicode('', encoding)
Workbook.py中的初始化改为utf8,原来默认的是ascii
def __init__(self, encoding='utf8', style_compression=0):
最新文章
- Java maven安装GDAL
- javascript js中的typeof使用
- IndexOf() LastIndexOf() Contains() StartsWith() EndsWith()方法比较
- weblogic服务器内存溢出问题解决
- innodb master thread 工作原理
- [关于SQL]查询成绩都大于80分的学生
- Codeforces 191C Fools and Roads(树链拆分)
- mysql基础(mysql数据库导入到处) 很基础很实用
- Arduino 串口篇 Arduino发送十六进制 send HEX via serial port RS232-to-USB to PC
- 【Egret】web版本报错:XMLHttpRequest cannot load
- zzuli--2134: 维克兹的进制转换(规律)
- 201521123071 《JAVA程序设计》第四周学习总结
- tensorflow can not find libcusolver.so.8.0
- MyBatis-Plus的简单使用
- 【NET CORE微服务一条龙应用】第二章 配置中心使用
- 活字格Web应用平台学习笔记3-显示数据列表
- shell 循环数组
- mysql关于数据库表的水平拆分和垂直拆分
- 兼容的动态加载JS【原】
- CentOS 安装python3.5