Python xlwt 模块出现Unexpected data type <class 'float'>错误，求大神指导 安装Python模块错误问题，怎么解决

Python\u53c2\u6570\u5316\uff0c\u8c03\u7528Excel\u91cc\u6570\u5b57\u65f6\u62a5\u9519\uff1aTypeError: object of type 'float' has no len()\u8bf7\u95ee\u8981\u600e\u4e48\u89e3\u51b3

\u5e94\u8be5\u662f\u8bef\u5c06float\u5f53\u4f5clist\u6216\u8005tuple\u6765\u64cd\u4f5c\u4e86 \u5bf9\u4e8elist\u6216\u8005\u5143\u7ec4\uff0c[]\u64cd\u4f5c\u662f\u8bbf\u95ee\u4e0b\u6807\u6240\u5728\u7684\u5143\u7d20\uff0c\u4e5f\u5c31\u662f__getitem__\u65b9\u6cd5\u3002 \u7531\u4e8epython\u5b9a\u4e49\u53d8\u91cf\u7684\u65f6\u5019\u5e76\u4e0d\u8bf4\u660e\u7c7b\u578b\uff0c\u7c7b\u578b\u90fd\u5728\u8fd0\u884c\u65f6\u786e\u5b9a\uff0c\u56e0\u6b64\u6709\u51fa\u73b0\u7c7b\u578b\u9519\u8bef\u7684\u53ef\u80fd\u6027\u3002 \u81f3\u4e8e\u5177\u4f53\u600e\u4e48\u4fee\u6539\uff0c\u65e0\u6cd5\u4ece\u4f60\u7684...

\u524d\u8a00\uff1a
\u8fd9\u51e0\u5929\u628apython\u7248\u672c\u5347\u7ea7\u540e\uff0c\u53d1\u73b0pip\u5b89\u88c5\u6a21\u5757\u597d\u591a\u90fd\u62a5\u9519\uff08\u6682\u4e0d\u786e\u5b9a\u662f\u4e0d\u662f\u56e0\u4e3a\u5347\u7ea7\u5bfc\u81f4\u7684\uff09\uff0c\u6211\u5b9a\u775b\u4e00\u770b\uff0c\u53d1\u73b0\u662f\u6743\u9650\u7684\u95ee\u9898\uff0c\u90a3\u4e48\u600e\u4e48\u89e3\u51b3\u5462\uff1f
1 \u6743\u9650\u95ee\u9898

C:\Users\ljf>pip install xlwtException:Traceback (most recent call last):File "c:\program files\python35\lib\site-packages\pip\basecommand.py", line 211, in mainstatus = self.run(options, args)File "c:\program files\python35\lib\site-packages\pip\commands\install.py", line 311, in runroot=options.root_path,File "c:\program files\python35\lib\site-packages\pip\req\req_set.py", line 646, in install **kwargsFile "c:\program files\python35\lib\site-packages\pip\req\req_install.py", line 803, in installself.move_wheel_files(self.source_dir, root=root)File "c:\program files\python35\lib\site-packages\pip\req\req_install.py", line 998, in move_wheel_filesisolated=self.isolated,File "c:\program files\python35\lib\site-packages\pip\wheel.py", line 339, inmove_wheel_filesclobber(source, lib_dir, True)File "c:\program files\python35\lib\site-packages\pip\wheel.py", line 310, inclobberensure_dir(destdir)File "c:\program files\python35\lib\site-packages\pip\utils\__init__.py", line 71, in ensure_diros.makedirs(path)File "c:\program files\python35\lib\os.py", line 241, in makedirsmkdir(name, mode)PermissionError: [WinError 5] \u62d2\u7edd\u8bbf\u95ee\u3002: 'c:\\program files\\python35\\Lib\\site-packages\\xlwt'

\u6ce8\u610f\u770b\u6211\u6807\u7ea2\u7684\u90a3\u90e8\u5206\uff0c\u63d0\u793a\u8bf4\u6743\u9650\u9519\u8bef\uff0c\u62d2\u7edd\u8bbf\u95ee\uff0c\u6211\u4eec\u8fd9\u6837\u89e3\u51b3\uff1a
1 \u9996\u5148\u5207\u6362\u5230c:\\program files\\\u76ee\u5f55\u4e0b\uff0c
2 \u6211\u4eec\u9f20\u6807\u53f3\u51fbpython35\u8fd9\u4e2a\u76ee\u5f55\uff0c\u70b9\u51fb \u5c5e\u6027 \uff0c
3 \u9996\u5148\u5207\u6362\u5230 \u5b89\u5168 \u8fd9\u4e2a\u5927\u6807\u9898\u4e0b\u9762\uff0c\u9009\u4e2d\u5f53\u524d\u767b\u9646\u7684\u7528\u6237\uff0c\u7136\u540e\u518d\u70b9\u51fb\u7f16\u8f91\uff0c\u7f16\u8f91\u5b8c\u4ee5\u540e\u4e0d\u8981\u5fd8\u8bb0\u70b9\u51fb\u5e94\u7528\uff0c

4 \u70b9\u51fb\u6dfb\u52a0\u7684\u6743\u9650\uff0c\u6211\u8fd9\u91cc\u4e3a\u4e86\u65b9\u4fbf\u5168\u90e8\u4e00\u5757\u9009\u4e86\uff0c\u53cd\u6b63\u6839\u636e\u81ea\u5df1\u7684\u5b9e\u9645\u60c5\u51b5\u800c\u5b9a\uff0c\u6700\u540e\u70b9\u51fb\u5e94\u7528\uff0c\u518d\u70b9\u51fb\u786e\u5b9a\u5c31\u5927\u529f\u544a\u6210\u3002

5 \u6211\u4eec\u6b64\u65f6\u518d\u770b\u770b\u81ea\u5df1pip\uff0c\u662f\u4e0d\u662f\u80fd\u591f\u5b89\u88c5\u6a21\u5757\u4e86\u3002

看报错信息是数据类型不对引起的。
写入Excel前，你先把q_num和tm_num打印出来看下是什麽东东先啊
..............
print q_num,tm_num
table.write(a,1,q_num)
..............

既然因为数据类型的原因写不进去，就强制转个类型啊，一般转成字符串就什么问题都没有了，write（1,1，str（x））

1. pandas库比xlwt好用

2. autopep8可以让代码格式自动符合pep8规范
   

table.write(a,1,str(q_num))

扩展阅读：python手机版下载官方 ... python msvcrt模块下载 ... 黑马java视频 ... python xlrd ... python官网入口 ... python random sample ... qpython安装第三方模块 ... python for beginners ... python shutil ...