背景
折腾:
【整理】Python中,添加写入数据到已经存在的Excel的xls文件,即打开excel文件,写入新数据
的过程中,需要用到xlutils,所以去安装。
下载xlutils
从:
Working with Excel Files in Python
提到的
http://pypi.python.org/pypi/xlutils
去下载,最新版本的
得到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)