背景
折腾:
【整理】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切换到对应目录,去安装:
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)