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

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

Python crifan 11902浏览 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切换到对应目录,去安装:

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.182 seconds, using 22.12MB memory