最新消息:20210816 当前crifan.com域名已被污染,为防止失联,请关注(页面右下角的)公众号

【记录】Python中安装可以读写excel的xls文件的xlutils模块(需依赖于xlrd和xlwt)

Python crifan 12086浏览 0评论

背景

折腾:

【整理】Python中,添加写入数据到已经存在的Excel的xls文件,即打开excel文件,写入新数据

的过程中,需要用到xlutils,所以去安装。

 

下载xlutils

从:

Working with Excel Files in Python

提到的

http://pypi.python.org/pypi/xlutils

去下载,最新版本的

xlutils-1.5.2.tar.gz

得到47KB的xlutils-1.5.2.tar.gz

 

安装xlutils

解压后,打开cmd切换到对应目录,去安装:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
D:\tmp\dev_tools\python\excel\xlutils-1.5.2.tar\xlutils-1.5.2>setup.py install
running install
running bdist_egg
running egg_info
writing requirements to xlutils.egg-info\requires.txt
writing xlutils.egg-info\PKG-INFO
writing top-level names to xlutils.egg-info\top_level.txt
writing dependency_links to xlutils.egg-info\dependency_links.txt
writing entry points to xlutils.egg-info\entry_points.txt
reading manifest file 'xlutils.egg-info\SOURCES.txt'
writing manifest file 'xlutils.egg-info\SOURCES.txt'
installing library code to build\bdist.win-amd64\egg
running install_lib
running build_py
creating build
creating build\lib
creating build\lib\xlutils
copying xlutils\copy.py -> build\lib\xlutils
copying xlutils\display.py -> build\lib\xlutils
copying xlutils\filter.py -> build\lib\xlutils
copying xlutils\margins.py -> build\lib\xlutils
copying xlutils\save.py -> build\lib\xlutils
copying xlutils\styles.py -> build\lib\xlutils
copying xlutils\__init__.py -> build\lib\xlutils
creating build\lib\xlutils\tests
copying xlutils\tests\fixtures.py -> build\lib\xlutils\tests
copying xlutils\tests\test_copy.py -> build\lib\xlutils\tests
copying xlutils\tests\test_docs.py -> build\lib\xlutils\tests
copying xlutils\tests\test_filter.py -> build\lib\xlutils\tests
copying xlutils\tests\test_save.py -> build\lib\xlutils\tests
copying xlutils\tests\test_styles.py -> build\lib\xlutils\tests
copying xlutils\tests\__init__.py -> build\lib\xlutils\tests
copying xlutils\license.txt -> build\lib\xlutils
copying xlutils\readme.txt -> build\lib\xlutils
copying xlutils\version.txt -> build\lib\xlutils
creating build\lib\xlutils\docs
copying xlutils\docs\copy.txt -> build\lib\xlutils\docs
copying xlutils\docs\description.txt -> build\lib\xlutils\docs
copying xlutils\docs\display.txt -> build\lib\xlutils\docs
copying xlutils\docs\filter.txt -> build\lib\xlutils\docs
copying xlutils\docs\margins.txt -> build\lib\xlutils\docs
copying xlutils\docs\save.txt -> build\lib\xlutils\docs
copying xlutils\docs\styles.txt -> build\lib\xlutils\docs
copying xlutils\tests\date.xls -> build\lib\xlutils\tests
copying xlutils\tests\ragged.xls -> build\lib\xlutils\tests
copying xlutils\tests\test.xls -> build\lib\xlutils\tests
copying xlutils\tests\testall.xls -> build\lib\xlutils\tests
copying xlutils\tests\testnoformatting.xls -> build\lib\xlutils\tests
creating build\bdist.win-amd64
creating build\bdist.win-amd64\egg
creating build\bdist.win-amd64\egg\xlutils
copying build\lib\xlutils\copy.py -> build\bdist.win-amd64\egg\xlutils
copying build\lib\xlutils\display.py -> build\bdist.win-amd64\egg\xlutils
creating build\bdist.win-amd64\egg\xlutils\docs
copying build\lib\xlutils\docs\copy.txt -> build\bdist.win-amd64\egg\xlutils\docs
copying build\lib\xlutils\docs\description.txt -> build\bdist.win-amd64\egg\xlutils\docs
copying build\lib\xlutils\docs\display.txt -> build\bdist.win-amd64\egg\xlutils\docs
copying build\lib\xlutils\docs\filter.txt -> build\bdist.win-amd64\egg\xlutils\docs
copying build\lib\xlutils\docs\margins.txt -> build\bdist.win-amd64\egg\xlutils\docs
copying build\lib\xlutils\docs\save.txt -> build\bdist.win-amd64\egg\xlutils\docs
copying build\lib\xlutils\docs\styles.txt -> build\bdist.win-amd64\egg\xlutils\docs
copying build\lib\xlutils\filter.py -> build\bdist.win-amd64\egg\xlutils
copying build\lib\xlutils\license.txt -> build\bdist.win-amd64\egg\xlutils
copying build\lib\xlutils\margins.py -> build\bdist.win-amd64\egg\xlutils
copying build\lib\xlutils\readme.txt -> build\bdist.win-amd64\egg\xlutils
copying build\lib\xlutils\save.py -> build\bdist.win-amd64\egg\xlutils
copying build\lib\xlutils\styles.py -> build\bdist.win-amd64\egg\xlutils
creating build\bdist.win-amd64\egg\xlutils\tests
copying build\lib\xlutils\tests\date.xls -> build\bdist.win-amd64\egg\xlutils\tests
copying build\lib\xlutils\tests\fixtures.py -> build\bdist.win-amd64\egg\xlutils\tests
copying build\lib\xlutils\tests\ragged.xls -> build\bdist.win-amd64\egg\xlutils\tests
copying build\lib\xlutils\tests\test.xls -> build\bdist.win-amd64\egg\xlutils\tests
copying build\lib\xlutils\tests\testall.xls -> build\bdist.win-amd64\egg\xlutils\tests
copying build\lib\xlutils\tests\testnoformatting.xls -> build\bdist.win-amd64\egg\xlutils\tests
copying build\lib\xlutils\tests\test_copy.py -> build\bdist.win-amd64\egg\xlutils\tests
copying build\lib\xlutils\tests\test_docs.py -> build\bdist.win-amd64\egg\xlutils\tests
copying build\lib\xlutils\tests\test_filter.py -> build\bdist.win-amd64\egg\xlutils\tests
copying build\lib\xlutils\tests\test_save.py -> build\bdist.win-amd64\egg\xlutils\tests
copying build\lib\xlutils\tests\test_styles.py -> build\bdist.win-amd64\egg\xlutils\tests
copying build\lib\xlutils\tests\__init__.py -> build\bdist.win-amd64\egg\xlutils\tests
copying build\lib\xlutils\version.txt -> build\bdist.win-amd64\egg\xlutils
copying build\lib\xlutils\__init__.py -> build\bdist.win-amd64\egg\xlutils
byte-compiling build\bdist.win-amd64\egg\xlutils\copy.py to copy.pyc
byte-compiling build\bdist.win-amd64\egg\xlutils\display.py to display.pyc
byte-compiling build\bdist.win-amd64\egg\xlutils\filter.py to filter.pyc
byte-compiling build\bdist.win-amd64\egg\xlutils\margins.py to margins.pyc
byte-compiling build\bdist.win-amd64\egg\xlutils\save.py to save.pyc
byte-compiling build\bdist.win-amd64\egg\xlutils\styles.py to styles.pyc
byte-compiling build\bdist.win-amd64\egg\xlutils\tests\fixtures.py to fixtures.pyc
byte-compiling build\bdist.win-amd64\egg\xlutils\tests\test_copy.py to test_copy.pyc
byte-compiling build\bdist.win-amd64\egg\xlutils\tests\test_docs.py to test_docs.pyc
byte-compiling build\bdist.win-amd64\egg\xlutils\tests\test_filter.py to test_filter.pyc
byte-compiling build\bdist.win-amd64\egg\xlutils\tests\test_save.py to test_save.pyc
byte-compiling build\bdist.win-amd64\egg\xlutils\tests\test_styles.py to test_styles.pyc
byte-compiling build\bdist.win-amd64\egg\xlutils\tests\__init__.py to __init__.pyc
byte-compiling build\bdist.win-amd64\egg\xlutils\__init__.py to __init__.pyc
creating build\bdist.win-amd64\egg\EGG-INFO
copying xlutils.egg-info\PKG-INFO -> build\bdist.win-amd64\egg\EGG-INFO
copying xlutils.egg-info\SOURCES.txt -> build\bdist.win-amd64\egg\EGG-INFO
copying xlutils.egg-info\dependency_links.txt -> build\bdist.win-amd64\egg\EGG-INFO
copying xlutils.egg-info\entry_points.txt -> build\bdist.win-amd64\egg\EGG-INFO
copying xlutils.egg-info\not-zip-safe -> build\bdist.win-amd64\egg\EGG-INFO
copying xlutils.egg-info\requires.txt -> build\bdist.win-amd64\egg\EGG-INFO
copying xlutils.egg-info\top_level.txt -> build\bdist.win-amd64\egg\EGG-INFO
creating dist
creating 'dist\xlutils-1.5.2-py2.7.egg' and adding 'build\bdist.win-amd64\egg' to it
removing 'build\bdist.win-amd64\egg' (and everything under it)
Processing xlutils-1.5.2-py2.7.egg
creating d:\tmp\dev_install_root\python27_x64\lib\site-packages\xlutils-1.5.2-py2.7.egg
Extracting xlutils-1.5.2-py2.7.egg to d:\tmp\dev_install_root\python27_x64\lib\site-packages
Adding xlutils 1.5.2 to easy-install.pth file
Installing margins-script.py script to D:\tmp\dev_install_root\Python27_x64\Scripts
Installing margins.exe script to D:\tmp\dev_install_root\Python27_x64\Scripts
Installing margins.exe.manifest script to D:\tmp\dev_install_root\Python27_x64\Scripts
 
Installed d:\tmp\dev_install_root\python27_x64\lib\site-packages\xlutils-1.5.2-py2.7.egg
Processing dependencies for xlutils==1.5.2
Searching for xlwt==0.7.4
Best match: xlwt 0.7.4
Adding xlwt 0.7.4 to easy-install.pth file
 
Using d:\tmp\dev_install_root\python27_x64\lib\site-packages
Searching for xlrd==0.8.0
Best match: xlrd 0.8.0
Adding xlrd 0.8.0 to easy-install.pth file
 
Using d:\tmp\dev_install_root\python27_x64\lib\site-packages
Finished processing dependencies for xlutils==1.5.2
 
D:\tmp\dev_tools\python\excel\xlutils-1.5.2.tar\xlutils-1.5.2>

 

总结

接着去折腾:

【整理】Python中,添加写入数据到已经存在的Excel的xls文件,即打开excel文件,写入新数据

转载请注明:在路上 » 【记录】Python中安装可以读写excel的xls文件的xlutils模块(需依赖于xlrd和xlwt)

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

网友最新评论 (1)

  1. 楼主很牛X ,,,,很多很好的文章
    自然人12年前 (2013-05-27)回复
92 queries in 0.504 seconds, using 22.19MB memory